19 Replies Latest reply: Jan 16, 2018 8:56 AM by pradosh thakur RSS

    Question for champions (can't find a right title to my question :D )

    omar bensalem

      Hi all, stalwar1

       

      I have this scenario:

       

      I have multiple clients :

      let's say : 3 clients

      each client has different start and end dates

      what I want to do: if a yearEnd ( a calculated field) is btwn StartDate and EndDate, we take the Measure into consideration, else, we don't:

      the red line are the good ones:

      (till now, it's fine)

       

      clientStartDateEndDateYearEnd(calculated = yearEnd(StartDate)Measure
      client1

      04/05/2014

      05/10/2014

      01/05/2015

      15/10/2015

      20/04/2016

      04/09/2014

      05/02/2015

      10/09/2015

      15/01/2016

      15/01/2017

      31/12/2014

      31/12/2014

      31/12/2015

      31/12/2015

      31/12/2016

      100

      200

      300

      400

      500

      client2

      10/01/2015

      12/12/2015

      01/02/2017

      20/09/2017

      05/08/2015

      20/02/2016

      10/05/2017

      15/01/2018

      31/12/2015

      31/12/2015

      31/12/2017

      31/12/2017

      100

      200

      300

      400

      client3

      10/07/2015

      15/01/2016

      11/01/2016

      15/01/2017

      31/12/2015

      31/12/2016

      100

      200

       

      Now, what I want to do is create a new bar chart as follow:

       

      as dimension: year  (probably, year(StartDate) ?

      as a measure : My Measure

      and it would be as follow:

       

      2014 : 200 (the first red of client1)

      2015 : 400 (2nd red for client1) + 200 (1st red for client2) + 100 (first red for client3)

      2016 : 500 (3rd red for client1) + 200 (2nd red of client3)

      2017 ; 400 (2nd red for client2)

       

      How can I do this?

      thanks !