1 Reply Latest reply on Oct 11, 2016 4:23 PM by Shinichiro Murakami

    Create month mark axis from days

    amulya.sharma

      I wanna plot results by month marks on x-axis where the months are calculated from days between two different dates

      Eg: Date 1 = 6/24/2016 and Date 2 = 6/29/2016

      Formula for Calculated Measure called Month Mark =  DATEDIFF('day',[Date 1],[Date 2])

      This gives me 5

       

      I can create 30 day bins for Month Mark but that would make my x-axis show 30 days, 60 days etc. (I can create for 30 days=1 month alias for each value but that's tedious)

      I want my x-axis to not say 0 days, 30 days, 60 days etc. but  1,2,3 months.. etc.

      So 5 would fall in month 1. 35 would fall in month 2. And so on.