Forum Discussion
CNC987654
Helper I
Helper IBest graph that shows multi-level historical data?
Can you please suggest (link to sample or video) graphs that can best display multi-level time series data?
For example, here is the pivot table showing % of Account vs Index (in different countries) in the last 5 years.
| Values | |||
| Year | Country | Sum of Account | Sum of Index |
| 2010 | CA | 0.33 | 0.25 |
| KR | 0.34 | 0.5 | |
| US | 0.33 | 0.25 | |
| 2010 Total | 1 | 1 | |
| 2011 | CA | 0.3 | 0.25 |
| KR | 0.4 | 0.5 | |
| US | 0.3 | 0.25 | |
| 2011 Total | 1 | 1 | |
| 2012 | CA | 0.3 | 0.25 |
| KR | 0.3 | 0.5 | |
| US | 0.4 | 0.25 | |
| 2012 Total | 1 | 1 | |
| 2013 | CA | 0.25 | 0.25 |
| KR | 0.25 | 0.25 | |
| US | 0.5 | 0.25 | |
| 2013 Total | 1 | 0.75 | |
| 2014 | CA | 0.33 | 0.25 |
| KR | 0.33 | 0.25 | |
| US | 0.5 | 0.5 | |
| 2014 Total | 1.16 | 1 |
