I have been asked to have 3 graphs that are controlled by a global filter which shows "Year-Week".
Graph 1 will show the last 4 weeks (by day) worth of data with for the same period of time, last year as a second line.
Graph 2 will show the current week (by day) with for the same period of time, last year as a second line.
Graph 3 will show the next 2 weeks of data (by day) for last year only.
I think the direction if to create a calculated field which shows month/day (excluding year so they can be mapped year over year). Then separate by year by dropping a year field in the colour picker.
Graphs 1 and 3 will have to have calculated date fields that show different periods based on the filter...
anyway, I have been trying loads of stuff but am stuck. Any ideas?
Retrieving data ...