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 :

       

      Weather:

       

       

      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.