14 Replies Latest reply: Oct 24, 2015 9:03 AM by Kumar Pramod RSS

    Week number or Quarter number

    Kumar Pramod

      Hi all,

       

      I have a date from 2012 in my database. I have created a master calendar.

      The week number and quarter is same for all the four years(2012,2013,2014,2015).

      Example:  January month of all the 4 years belongs to Quarter Q1. I don't need like this i need as jan-2012 in Q1, jan-2013 in Q5, jan-2014 in Q9, jan -2015 in Q13.

       

      Because i need to show data in quarter for all the 3 years in line graph.

       

      or anyone explain how can i achieve this?

       

      quarter.png

       

      You can see in above image that the data is comparing for every four months i need to prepare a line graph like above.

       

      Regards,

      Pramod