Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
got two graphs with the same expression and dimensions but the one on the right is set to display the cumulative percentage that is shown in the first graph
in the second graph I used the rangesum and above functions and I accomplished the desired result
However in the second graph I want to ignore selection made on the values of the dimension on the x-axis
it works on the first graph but doesn't work on the second graph unless I remove the second dimension (area)
kindly advise on how to solve this issue
on the second graph when user clicks on one of the values the graph shows result for that value
what I want is keep accumulation regardless of any selection of values on the x-axis
Kindly advise
@sunny_talwar
Try Comparative Analysis and it can be solved easily.
If not try use set expression to ignore x axis dimension
you may try using alternative state or bypass the dims in set analysis
I already did this
it doesn't work
You can ignore the field that user selected to see result from the second graph.
Like, If this is your expression Sum(Sales) try like this, Sum({<FieldName>} Sales)
It's not working with accumulation or while using range sum
It's works only if there is one dimension in the graph