Formulae: RunningTotal - Count Steps?

Valentina · April 1, 2014 5:36AM

Hi all,

I am trying to create a column ( as in Steps) in order to count the steps of an ID based on the date. I tried to use the recordcount function but it returns the total number of records for each cell.Any ideas?

ID Date Steps
AW 3/5/14 1
AW 5/5/14 2
AW 6/5/14 3
RT 5/5/14 1
RT 9/5/14 2
UL 6/5/14 1
UL 7/5/14 2
UL 8/5/14 3
UL 12/5/14 4

Thanks in advance.

paola · April 1, 2014 6:00AM

You should add a new formula field, where value =1. This will enable you to use the RunningTotal formula that is adding the values for the above field [One], for each value of [Id].
RUNNINGTOTAL([One], SUBSET([Id]))

Image shows application in the DataManager space, but you can also apply the same formula in the DataExplorer. Difference is that the first method will import the results into Omniscope as static values.

Valentina · April 1, 2014 6:09AM

Thanks a million Paola that worked perfect!!!!

Welcome!

Categories

Ideas Parade

Tagged