Hi,
I need to add a data range as a dimension for a set of graphs featuring a number of different metrics.
I would rather not go down the set analysis route if possible.
My date field is [Date] (formatted DD/MM/YYYY) and I need to add a calculated dimension for the last 3 months based on the max [date] in the data currently loaded (which is usually yesterday).
I have tried something like:
=if([Date]>= Date(Max([Date])-100, 'DD/MM/YYYY') and [Date]<= Date(Max([Date]), 'DD/MM/YYYY'), [Date])
I know that this, if it worked, would look back 100 days but I was trying to get something close.
I have other date fields that could be used however I have two years of data so cannot only use Month or Month name without year too.
I do have a [Period] field which is a concatenate of year and month (201610) which might be better to use. Not too sure really.
Any help or suggestions would be greatly appreciated.
Thanks
Tim