2 Replies Latest reply on Feb 2, 2012 8:41 PM by matthew.w

    Compare different time periods in line chart

      Hi All,


      I have seen variations of this in other posts, but one that appear to answer this question.


      So, we have a database which counts legislative amendments over time and in different categories eg family law, property law etc.


      Column headers for example:

      Legislation name          Date of amendment          Legislative category          Division responsible


      What I would like to do is to compare the total number of legislative changes for Quarter 2 to the total in Quarter 1 in a running total continuous line chart - detail down to the day


      As far as i can tell the key problem is that the dates from each qtr don't correspond so they show on separate charts (side by side, not overlayed). I can compare the same date ranges year by year, and even month by month (using the day number).


      Im sure a calculated field might help eg number each day in the quarter from 1 to 92, or even number each week from 1 to 13 might work. But i cannot quite work this out.


      Any ideas?


      Thanks in advance.