I keep running into the problem outlined in TN5700-72X-1001. I want to create reports using Custom Groups that show Cumulative Frequency (using the RunningSum function), but the metric is not calculated in the order of the Custom Group. Anyone else run into this and figure out a workaround? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can't sort RunningSum metric by Custom Group
- Thread starter JRO061601
- Start date
Hi ,
I ran into the same problem. Running sum did not calculate based on the custom group elements. You could try this
Create new metrics M1 = max (1)
M2 = runningsum(M1)
If the runningsum metric you created is M3. Now in runningsum parameters choose sort by objects...and select M2.
In your report you will need to include metric M2.I was creating a graph so it did not matter to me.
your report would look like
Custom grp M2 M3
A 1 5
B 2 10
Hope this helps.
I ran into the same problem. Running sum did not calculate based on the custom group elements. You could try this
Create new metrics M1 = max (1)
M2 = runningsum(M1)
If the runningsum metric you created is M3. Now in runningsum parameters choose sort by objects...and select M2.
In your report you will need to include metric M2.I was creating a graph so it did not matter to me.
your report would look like
Custom grp M2 M3
A 1 5
B 2 10
Hope this helps.
- Status
Similar threads
- Locked
- Question