7 Replies Latest reply on Aug 30, 2018 6:56 AM by Mahfooj Khan

    Double line graph with avg lines for selected measure

    Skaiste Papuskaite

      Hello creative people

       

      I would like to make a graph with a lot of information in it, so I have some struggles to put everything in one place.

      I want to make a line graph for selected measure (orders, revenue...) by days (please see data enclosed) in total and by shop. In the graph should be seen total line and more lines for each shop - I managed to do till this step.

      And also I would like to put a reverence lines which represent average value. Every line should have its own reference line. I was trying to use "reference line" from "Analysis" tab but then I get just 2 reference lines - one for total (correct) and one for all shops (incorrect).

      The view should be similar to this:

       

       

      Any help would be awesome!Double graph.jpg