Build Line chart with 30 days interval data

Hi,

Is it possible to build a line chart where the Graph by value is interval for 30 days

For example:-

the current date is 15th jan

So the values are displayed by 

DateValue
16oct-15nov

123

16nov-15dec

234

16dec-15jan

345

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    create a Beast Mode ... this is pseudo code.

    Case

    when Date >= today - 30 then 'Group 1'

    when date >= 60 then 'Group 2'

    ...

    END

     

    Alternatively if you're using this logic a lot, build a date dimension  ( a table with one row per day) in Magic or SQL and then add the '30 day trailing' column with similar logic from your beast mode.

This discussion has been closed.