Hi ,
I have a query with four calculated data items an when put ona list shows these values
DiscountA DiscountB PromotionalSavings Rebate Amount
26500 242000 0 11350
User is requesting this to show on a latest pie chart by percentage value .
Pie chart has only 2 inputs segments and size . so now my 4 measues are my categories with value on it.
Has anyone had similar use case and how did you achieve the similar result .
did you use an old pie chart or had a pass thriugh sql in required format.
Thanks,
It's not very clear what it is that you're trying to show in the pie chart. What do you want the percentage to be? Rebate Amount / Discount A ?
You might want to reconsider if the pie chart is the best way to represent your data.
I am showing four categories in pie chart which is
discount A
discount b
promotional savings
Rebate Amount
so it divdes the amount in each category by total amount of 4 columns.
Ahhh...ok, that makes slightly more sense. In that case, based on your original figures, you presumably want something along the lines of
Category % of Total
Discount A 9.5%
Discount B 86.5%
Promotional 0%
Rebate 4%
Yes exactly ,like the results you have.
I have the four data items with measures
DiscountA DiscountB PromotionalSavings Rebate Amount
26500 242000 0 11350
And I need in pie like
Category % of Total
Discount A 9.5%
Discount B 86.5%
Promotional 0%
Rebate 4%
Now i wanted to know how to get them in pie , becasue pie accepts one measure and category
Thanks,