5 Replies Latest reply on Nov 10, 2017 1:59 AM by Adam Norbury

    Is it possible to create a line chart with dates as field headers?

    Adam Norbury

      Here is an example I'm working on. I have a variety of retailers and their rank in given years based on American sales. I also have type, which I want to use to filter/highlight by.

       

      I know I am able to create a line chart by having the list of companies as columns(field headers) and the list of years as each row, but then I wouldn't be able to add the type of store they are.

       

      Here is a picture of the example:

      Capture.PNG

       

      Is there anyway I can turn this into a line graph where the various dates are columns on a line graph, and each line being a various company, with the value for each year being their rank, while still having company type be a dimension that can be used to filter?