Forum Discussion
Lenin
9 years agoFrequent Visitor
Display multiple data sets in hierarchy
Hi I was wondering if it is possible for a visual, say a line chart in a hierarchy to show more than one data set? I have a hierarchy that has a structure Year | | ___Team Name ...
- 9 years ago
Hi Lenin
Do you mean more than one table? If so, yes you can simply by dragging extra categories to the Axis field in the Visualization area (you can stack these up). You just want to make sure there is some form of relationship between the fields (either same table or related table).
In this example I have added Countries and Cities in the Axis
Phil_Seamark
9 years agoMicrosoft Employee
Hi Lenin
Do you mean more than one table? If so, yes you can simply by dragging extra categories to the Axis field in the Visualization area (you can stack these up). You just want to make sure there is some form of relationship between the fields (either same table or related table).
In this example I have added Countries and Cities in the Axis
Lenin
9 years agoFrequent Visitor
Thanks Phil. Much appreciated.