Hi All, I need to do something it may be simple but so far I'm no able to get it. So basically what I want is illustrated in the "AccumulatedCount" column below:
The closest shoot I got so far is use this expression:
if(StartDate< Previous(EndDate), Count+1, Previous(Count)) AS AccumulatedCount
But, of course that's not what I want cause I'm summing 1 to 1 all the time:
So I need something like that expression but over the AccumulatedCount field but not sure how to do it. Hope it makes sense.
Solved! Go to Solution.
It doesn't work. The problem really is that you need to add 1 every single time the conditions fulfills (i.e. a simple a++ in any programming language) but here in the load editor you can't just do that. So I'm not sure if this is doable or you need to do it in the chart instead (although the same problem might happen there).
Not sure how to solve it.
That's exactly what I tried before. But something weird is happening or I'm missing something cause even in a table chart using the below expression and simplifying it without taking into account the date fields:
Which should work to gave me and accumulated value, it's just displaying always 1.
The same thing happens in the script if I use peek.
But this will continue to accumulate regardless of change in any of your dimensions.... if that is what you want, then that is great... else you will have to play around with your expression to make it to work