Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
CN
Contributor II
Contributor II

Pie Chart Expression Trouble

I have two fields in the same table that I would like to compare with a pie chart. I don't know what I'm doing wrong, but it's not working. I want to display the sum of rejects by reject type. The two fields are called, (StkScrapCnt) and (ProdScrapCnt).

In the Dimensions for the Pie Chart I wrote an expression for each dimension, which was =Sum (StkScrapCnt) and =Sum (ProdScrapCnt).

What am I doing wrong?

 

2 Replies
rubenmarin

I think you need set Reject type as dimension and use two expressions: Sum (StkScrapCnt) and Sum (ProdScrapCnt)

Or use two pie charts, one for each expression. Radar chart, bar chart and line chart can also help to compare two metrics
jonathandienst
Partner - Champion III
Partner - Champion III

A pie chart is not a great way to compare values. Unless the ratio itself is the relevant takeaway, I would use a pair of linear gauges or a bar chart. 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein