5 Replies Latest reply on Jun 7, 2016 5:45 PM by swaroop.gantela

    Complex Date calculation_Custom Date levels

    Somok Sarkar

      Hello Folks,


      I need a help from this community regarding a date calculation we are trying to achieve. I have created a replica using the superstore data. The requirement is I would like to view a graph of sales Vs month for different segments.


      Now I know tableau would allow me to show the date is continuous or discrete format, however we need to show it as Month 1, Month 2, Month 3 etc. Month 1 - should be from any start date of a month till the end date of the same month. Then comes Month 2 and then so on.


      We have a dataset where we have various dates of different years. In order to avoid the visual problem we need to create a new calc.


      However even if we create a calc field can someone please tell me how to use it as a date level? like we have the order date?


      The graph should be the month 1, 2, 3..... vs the sum(Sales)etc (instead of the discrete or continuous months).