I’m here again asking for help.
This time I’m trying to create a table to show a trend with a simple green/red arrow. This trend has to be calculated out of a comparison between the data on that current row vs the one on top of it.
I would like it to be:
Trend on first row: empty
Trend on second row: red
Trend on third row: green
Trend on fourth row: green
All this has to be dependent on what’s currently there in the table. But I have no clue on how to build a measure like that (or if it’s possible at all)
Hello again! I was able to pull off the trend that I was looking for using
I’m having a different issue now:
I created these calculated members inside the Sprint dimension:
And I have to create the same trend with previous sprints (can’t use the Time dimension now because of weird sprint dates).
How can I compare different members so the trend gets created dynamically?
Great that you found the correct solution for the Time previous member!
For any other dimension, you can use the VisibleRowsSet() function to find the previous of the row members.
Note that I have added an empty set for the first member. Here is the formula for the above:
) = 1
THEN "<i class='far fa-empty-set' style='color:black'></i>"
[Measures].[Issues resolved] >
) - 1
)), [Measures].[Issues resolved])
"<i class='far fa-arrow-up' style='color:green'></i>"
"<i class='far fa-arrow-down' style='color:red'></i>"
Note that the order in which you select the bookmarked members would be important in this approach.
Lauma / firstname.lastname@example.org