If I have fields that have the potential to contain any number of values, from null to many, how can I get the sum function to work on all cases using stats or chart?
For example:
CaseID Process X Time Process Y time Process Z time
1 .24
1 .65
1.54
1 .45
1 .66
1.5
2 .56
2 .23
.99
1.87
2 1.2
2 2.5
When i use "... | stats sum(process_x), sum(process_y), sum(process z) by caseID
it only sums the cells that have multiple values, not the cells that only contain a single value. Any misconception or misconstruction I'm running into here?
Thanks!
... View more