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

  • 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.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
This discussion has been closed.