3 Replies Latest reply on Nov 10, 2015 11:01 AM by Matt Day

    Line chart on aggregated data, without date as a field

    Matt Day

      Hello.  This seems to be a pretty simple question, but I couldn't find any answers on the forum.

       

      I have a set of data where I'm looking to track performance over time and display using a line chart.

      The tricky part is that this is aggregated data, taking a set of about 20 values and grouping them into 3 segments.

       

      I want to display the overall results, over time, of each segment.  I can do this numerically, using a table, but I can't find a way to display it as a line chart.  Unfortunately, reformatting/rearranging the source data is not an option, as the full data set is somewhat more complex.

       

      Attached is the example, thanks in advance for any help!