2 Replies Latest reply: Feb 11, 2018 8:28 PM by Kian Teck Lee RSS

    Comparing Sales data for different customers in same chart

    Kian Teck Lee

      Good day!

       

      My data looks something like this:

       

      CustomerNameOrderNumberSalesAmtOrderDateCustomerGroup
      Alpha11000Jan 2017Manufacturing
      Alpha22000Jan 2018Manufacturing
      Omega3300Jan 2017Education
      Omega45000Jan 2018Education
      Charlie54000Jan 2017Food and Beverage

       

      I would like to plot a line graph that allows my users to pick multiple customers, or different groups of customers in a line chart for the same period over 2 or more years.

       

      Would anyone knows what is the best way to do this in SENSE?