Note: Users should be familiar with how to create a basic/ chart table. If you're not, please read this article.
In the Basic Chart option, the user can click on the Metric name. Clicking on the Metric name will open an option box. One of the first options in that box will be Series Type. Any Metric in a visualization can be shown as any of the 5 Series Types.
I’ve included an example below that shows Headcount (EOP) across time based on the different Series Type chosen.
Horizontal Column Charts
For Column Charts a user will be able to select a tick box for Horizontal to make a Column chart horizontal instead of vertical.
Stacking a Metric with a Dimension
All Basic Charts can be stacked. Below are examples using the dimension Gender (pivoted) with time and the Metric Headcount (EOP). Both Metrics and Dimensions can be stacked.
Users have two options when stacking a chart, Values or Percentages.
Values will show the data as is in the Metric.
Percentages will show a percent of the whole. Any of the chart types can be shown as a Percentage, but I’ve provided an example of the Stacked Column below since that is the one that will be most often used.
Basic charts can have multiple metrics with different chart types.
Below are some examples of multiple metrics with mixed chart types.
The first example uses Area Spline and Column charts. Each Metric in the example will have a Series Type associated with it. I chose to leave all of this data on the same Y axis, since I wanted to compare them, but it is possible to show as 3 different Y axis. The order in this view is very important. I wanted the Hires (Net) bars to be on top of the Hires – External, so I needed to make sure that it was last on my list.
Note: The order can be determined based on how I select the metrics or I can move them around by dragging and dropping.
The second example uses a Line and Column chart. Each Metric in the example will have a Series Type associated with it. In this example, I chose to create a new Y axis and move it to the right, since one of my Metrics is a rate and the other is a value. I also chose in this situation to only show the numbers on my rate metric because of the overlap. This option is also on the Metric and can be set for each individual Metric.