Can I build a Pareto chart in BI Viewer?
I'd like to be able to build a Pareto chart in BI Viewer. Is it possible?
Building a Pareto chart in BI Viewer is fairly easy but does require several steps.
The first step is to create a bar chart and add a relevant measure and dimension to that chart. In this example, we've added Gross Margin as our measure and Product Name as our dimension.The next step is to sort the chart by Gross Margin and sort it in descending order.
Your chart should now look like this:
The next step is to add your measure a second time to the Values Pane and create a Window Calculation that creates a Running Summary along Arguments for that measure.
Because Pareto charts require the running percentage of the total of a measure, we must now edit the Window Calculation.
We use the Expression Editor to divide the running summary by the total value of our measure across all dimensions. That is accomplished using the Total() function in the Expression Editor. Our formula for Gross Margin would look like this:
Hit OK to accept your formula.
The two remaining steps are to plot our new percentage calculation on its own axis and then change the chart type to line for the calculation. We start this process by clicking on the Options Button next to our calculation.Choosing the desired line chart type:
And then plotting the calculation on the secondary axis.
Hit OK and your Pareto chart will be complete.