Skip to Content
Feb 16, 2016 at 07:22 AM

Unable to create the Pie chart for the Horizontal table?


Hi All

I am unable to create the pie chart properly for my horizontal table which has hardly two fields.The value for those fields are getting retrieved from the Formula.However upon turning them to pie chart its displaying hardly one measure😔

After choosing the "Turn Into" option we are getting the following chart

The formula for Direct Customers: =(Count([UNIQUE KEY]) Where ([Customer type]<>"P"))

Indirect Customers:=(Count([UNIQUE KEY]) Where ([Customer type]="P"))

The assign data option of the chart shows hardly the count(unique key) as the selected value:


chart data.png (4.7 kB)
pie chart.png (7.7 kB)
Chart Images.png (19.1 kB)