Forum Discussion
sjs2020
5 years agoFrequent Visitor
Using Measure as Dimension; Comparing Snapshots
Hello We are trying to analyze data from a table that has snapshots of data. User needs to select 2 dates and the analysis has to report on the changes between the new dates. site_id_id nod...
- 5 years ago
sjs2020 , Not able to get it completely. But two make measure to work as dimension you need bucketing with an independent table. Then you have to create new measures with Grouping(values/summarize) and using a between or equal to filter with the new table.
refer my video if that can help - https://www.youtube.com/watch?v=CuczXPj0N-k
sjs2020
5 years agoFrequent Visitor
Great, the video was clear and well explained. Thank you so much! Any iputs on how to make the Calculated measure filtrable by the user?