

Partner - Contributor III
2020-01-22
11:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Cumulative total for relative value
Hello, everybody!
Im try to calculate a relative value for chart visualisation where dimantion in days spend (0,1,2 etc)
Problem: in component of formula i need a cumulative total by my dimantion.
I'm make some example:
Im wont get chart like this
the problem is that I cannot use the previous values for the calculation. I need to take a measurement and count less than the current in a variable or in SetAnalysis
843 Views
1 Solution
Accepted Solutions

MVP
2020-01-22
11:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
may be this
=(rangesum(above(total sum({<ID>}OUT),0,RowNo(total)))/rangesum(above(total sum({<ID>}IN),0,RowNo(total))))*avg(1)
Where ID is the X-axis Dimension
2 Replies

MVP
2020-01-22
11:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
may be this
=(rangesum(above(total sum({<ID>}OUT),0,RowNo(total)))/rangesum(above(total sum({<ID>}IN),0,RowNo(total))))*avg(1)
Where ID is the X-axis Dimension


Partner - Contributor III
2020-01-23
06:18 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thenks, its work.
Im make a reference table and add it to model with references to main table. Im need it becose my formula with count(distinct id) ... so im need to calculate unicu id in each row...
806 Views
