4 Replies Latest reply on Sep 12, 2018 5:12 AM by totolo

    Combine two months together on a series of monthly data

    totolo

      Hello everyone,

       

      I would like to combine two months together in a visualization.

      Indeed the months of July and August are the months of the holidays and I would like not to have July on one side and August on the other.

      Ideally I would like to have just one item which will aggregate the data for the two months called  "July-August".

      Capture.PNG

       

      I tried different techniques without sucess because I lose the date logic:

       

      If month([Date]) <=1 then  'Janvier'

      ELSEIF

      month([Date]) <=2 then  'Février'

      ELSEIF

      month([Date]) <=3 then  'Mars'

      ELSEIF

      month([Date]) <=4 then  'Avril'

      ELSEIF

      month([Date]) <=5 then  'Mai'

      ELSEIF

      month([Date]) <=6 then  'Juin'

      ELSEIF

      month([Date]) <=7 then  'Juillet'

      ELSEIF

      month([Date]) <=8 then  'Août'

      ELSEIF

      month([Date]) <=9 then  'Septembre'

      ELSEIF

      month([Date]) <=10 then  'Octobre'

      ELSEIF

      month([Date]) <=11 then  'Novembre'

      ELSEIF

      month([Date]) <=12 then  'Décembre'

      END

      I'm a stuck I've been through the forum and I find myself without a solution. I don't know if that's possible.

       

      Best regards.

       

      Totolo