Hello all,

I'm looking to build a report that is basically a series of line charts that is plotting a value over time.  I can accomplish this one chart/dataset at a time, but I believe with 'List's this can be achieved in a more automated fashion.

If I have some data similar to this:

Area_ID, Location_Name, DataValue, ReadingDate
1,Site1,100,1990-10-10
1,Site1,110,1990-11-11
1,Site2,105,1994-01-07
1,Site2,105,1994-02-07
2,Site3,113,1994-06-02
2,Site3,120,1994-07-30
2,Site4,120,1994-06-30
2,Site4,120,1994-07-30

I want the charts grouped by the Area_ID, and then each Location_Name is a Series in that chart.  So in this example, I would end up with 2 charts (Areas 1 & 2), each have 2 series (Area 1: Site1, Site2 and Area 2: Site3, Site4)

Is it possible to build this with a list? or do I need to structure the data differently?

Any suggestions, nudges in the right direction would be greatly appreciated.

Thanks,

Warren 

Hi Warren,

As per your approach, I try to implement with a chart and placed the chart in to a LIST. It is working. Please find the below screenshots for you to guide.

1. Created a chart, Category group with AreadID and Location_Name.

2. Created LIST, drag and drop chart into LIST.

3. On LIST, group by Area_ID.

Part-1

Part-2:

Final Output:

Hope, this helps you. T

Thanks for the help Maruthi.

This is a little different than what I'm trying to do, but I'll see if I can adapt it to what I need.  After some trial and error, I did also have some success using the Matrix to generate the charts.

I'm trying to plot the data over time (ReadingDate) so the chart would look like this:

So now I just need to figure out the grouping in the List.

Thanks again.

Warren

For anyone looking for this in the future, this is also a good reference video:

https://www.youtube.com/watch?v=h8EidVXasYg&feature=youtu.be

Good video Warren. Your issue got resolved now?