Build Line chart with 30 days interval data

user02319

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 

Date	Value
16oct-15nov	123
16nov-15dec	234
16dec-15jan	345

jaeW_at_Onyx

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.