Grouped data in line chart

[johan_fox]

Within a Chart, is it possible to use groupField in the same way that you can group data within a Grid?

I am attempting to overlay multiple series on one chart, from a single store. I understand that charts do not support multiple stores, so I have generated a single store that returns all of my data. I have included some example data of what I mean below - this data should show a line chart with x-axis of Month/Year, y-axis of Total, with 3 different series (LINE1, LINE2, LINE3). Without grouping this data by the Name field, the resulting chart is a single series that joins the last point of LINE1 to the first point of LINE2, and the last point of LINE2 to the first point of LINE3, which is not useful. How can I separate these series into different lines?


{
"Name":"LINE1",
"Month":5,
"Year":11,
"Date":"May/11",
"Total":10
},{
"Name":"LINE1",
"Month":6,
"Year":11,
"Date":"June/11",
"Total":6
},{
"Name":"LINE1",
"Month":7,
"Year":11,
"Date":"July/11",
"Total":8
},{
"Name":"LINE1",
"Month":8,
"Year":11,
"Date":"August/11",
"Total":14
},{
"Name":"LINE2",
"Month":5,
"Year":11,
"Date":"May/11",
"Total":18
},{
"Name":"LINE2",
"Month":6,
"Year":11,
"Date":"June/11",
"Total":16
},{
"Name":"LINE2",
"Month":7,
"Year":11,
"Date":"July/11",
"Total":18
},{
"Name":"LINE2",
"Month":8,
"Year":11,
"Date":"August/11",
"Total":19
},{
"Name":"LINE3",
"Month":5,
"Year":11,
"Date":"May/11",
"Total":23
},{
"Name":"LINE3",
"Month":6,
"Year":11,
"Date":"June/11",
"Total":28
},{
"Name":"LINE3",
"Month":7,
"Year":11,
"Date":"July/11",
"Total":34
},{
"Name":"LINE3",
"Month":8,
"Year":11,
"Date":"August/11",
"Total":22
}


Is this possible in Ext? Any advice would be much appreciated!

[scottmartin]

Does this chart help?
http://dev.sencha.com/deploy/ext-4.0.7-gpl/examples/charts/GroupedBar.html

If this is not what you are looking for, can you provide a screen of the type of chart that you would like to see?

Regards,
Scott.

[johan_fox]

Visually, the result would appear like http://dev.sencha.com/deploy/ext-4.0.7-gpl/examples/charts/LiveUpdates.html (without necessarily updating).

However, imagine a reports dashboard where the user is able to select the criteria for the data they want to see on the chart. They might select a particular date range, or x number of items to compare against each other, each item being a seperate series. Following the examples though, I would need to know in advance what the user wanted to report on, and hard-code those criteria into my view. What I am trying to achieve needs to be dynamic.

A new post today (http://www.sencha.com/forum/showthread.php?197044-creating-store-and-model-dynamically) may be the answer. Does anyone know if this will help solve my issue, and where I might find a working example?

Thank you.