Displaying rolling data

user04187
user04187 Member
in Magic ETL

I have a rolling metric as my top level card so Jan sums Jan data, Feb sums Jan+Feb, Mar sums Jan+Feb+Mar etc, is there a way in my drill down that when I drill in March say that my drill down will also show me the raw data for Jan, Feb & March and so on? Thanks

Answers

  • GrantSmith
    GrantSmith Coach

    What you can do is restructure your data so that for each month you'd have all the other months included (for Mar would have a record with Mar as the date but Jan Jan as the value, another with Feb value and a third with Mar value). This way when the user selects a month it'll have all the other months available in the drill down

    I've done a write up on this before on how to format your data you can find here: https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories