0 Replies Latest reply on Mar 18, 2013 10:12 AM by Jake Pearson

    trending 3 graphs with historic data with a single filter

    Jake Pearson

      Hey Guys,

       

      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?

       

      Thanks,

       

      Jake