4 Replies Latest reply: Mar 10, 2015 5:40 AM by Gysbert Wassenaar RSS

    how to use 1 common selection (year month date) to show 2 different date field data in 2 different charts?

    Jim Chan

      Hi guys,

       

      I am facing a problem with date. Here's the requirements

       

      i have selections - year month date - using field [logged_date]

      I have a bar chart 1 - dimension - month(logged date) and measure by sum(functional_hrs) and sum(technical_hrs)

      i have a bar chart 2 - dimension - month(closed date) and measure by sum(functional_hrs) and sum(technical_hrs)

       

      Question:

      in my selections, what can i do, when i select on  Month 'Feb', it shows functional and technical hours spent based on logged_date in bar chart 1, and shows functional and technical hours spent based on closed_date in bar chart 2?

       

      In short, how can i use 1 common selection (year month date) to show 2 different date field data in 2 different charts?

       

       

      ticket_numberlogged_dateclosed_datefunctional_hrstechnical_hrs
      00113/02/201520/2/20152023

      002

      14/03/201521/3/20151326
      00315/04/201522/4/20151220