1 Reply Latest reply on Jun 28, 2016 3:38 PM by Patrick A Van Der Hyde

    add 2 dimensions / columns

    SeaUrchin

      Hi, I've got data in 2 columns both giving me the times planes arrived and departed.

      The data is structured like this:

      Flight       Departed   HourDeparted Landed HourLanded

      BA899     18:07              18               22:00    22

      QF111     10:20             10               14:10    14

      SQ300     11:32             11               16:55    16

      RY710      0345               3                17:00    17

       

      With dual axis, I could get a chart that is almost correct.  Issues:

      - the blue line is calculating wrongly though the orange is correct

      - i want a stacked bar  -  so I can see its total.

       

      For example, using the data in the graph, at

      - 12 midnight, 787 planes departed; 60 landed.  Total planes = 847

      - at  1 am, there were 623 + 35 = 658 planes, etc...

       

      Without custom sql and doing a "union", is there a way?

       

      Message was edited by: Sea Urchin I thought the line graph was correct when I first posted, but now realise the blue line is counting incorrectly.