3 Replies Latest reply on Aug 10, 2016 9:18 AM by Louisa Kho

    How do I show level of rainfall affects and number of accidents per day?

    Louisa Kho

      Hi, as the title says, I would like (if possible) to combine 2 sets of data - daily weather and accidents. I would like it to be a multiple chart, 1 of it to be line and the other to be a bar chart to show the level of rainfall and number of accidents daily to look like this for example :




      Before joining the two tables of data together, I am able to get the number of accidents per day correctly :





      After combining with the daily rainfall data :




      Here are my data :





      Accidents :



      I'm not too sure on how to join both data sets together or if it is even possible to join them.


      Thank you.