Graphing aggregate data from all cross-sections
Posted: Tue May 11, 2010 7:22 am
Hi Guys,
I have created some time series graphs out of a panel data (same variable, using "graph {%graph_name}.line(panel=i) ..."), and I am trying to make an aggregate line graph out of it. I need to add up, week-by-week, the values of the variable, and chart them. I could think of a matrix solution (so that I don't need to maintain the panel structure), but it wouldn't have the time series associating to the data points, but I can't find the graph console function from the manual. Another way is to create a new ts page and copy the data over there, matching only the @dateid and sum it up, but it would be a bit cumbersome if I have to run the program several times with a new page created each time it is run. So, is there any other way I should try? Please let me know. Thanks.
Tchaithonov
I have created some time series graphs out of a panel data (same variable, using "graph {%graph_name}.line(panel=i) ..."), and I am trying to make an aggregate line graph out of it. I need to add up, week-by-week, the values of the variable, and chart them. I could think of a matrix solution (so that I don't need to maintain the panel structure), but it wouldn't have the time series associating to the data points, but I can't find the graph console function from the manual. Another way is to create a new ts page and copy the data over there, matching only the @dateid and sum it up, but it would be a bit cumbersome if I have to run the program several times with a new page created each time it is run. So, is there any other way I should try? Please let me know. Thanks.
Tchaithonov