Forum Discussion
Count Measure category in Donut Chart
I don't know a easy way to supply sample data.
I have 3 tables;
1: Object information; Id, address, gas_ID, heat_ID
2: RegisterID; gas_ID / heat_ID, address, type (gas or heat) (there is a relationship with Object info based on address)
3: Usage; Date, gas_ID / heat_ID, usage; also a couple of calculated columns to seperate the gas and heat usage
Table 3 has a relationship with table 2 based on gas_ID/heat_ID
In the table 3 I have the following measures:
YieldPercentage = IFERROR( (sum(heat usages)/sum(gas usage));0)
PercentageCategory = if(or(ISBLANK([YieldPercentage]);[Rendement%]=0);"Blank"; if([YieldPercentage]<0,80;"<80%"; if([YieldPercentage]<0,85;"80-85%"; if([YieldPercentage]<0,9;"85-90%"; if([YieldPercentage]<1;"90-100%";">100%")))))
For the column chart I have the following measures:
<80% = IFERROR(if([YieldPercentage]<0,8;[YieldPercentage];0);0)
80-85% = IFERROR(if(and([YieldPercentage]<0,85;[YieldPercentage]>0,8);[YieldPercentage];0);0)
85-90% = IFERROR(if(and([YieldPercentage]<0,9;[YieldPercentage]>0,85);[YieldPercentage];0);0)
90-100% = IFERROR(if(and([YieldPercentage]<1;[YieldPercentage]>0,9);[YieldPercentage];0);0)
>100% = IFERROR(if([YieldPercentage]>1;[YieldPercentage];0);0)
I made a measure for every category so I could determine the colours of the bars.
Please let me know how I can give better/more informatie without showing actual customer data
Hi LonnekedeLeeuw,
You can copy your data here, or you can supply data using file as attachments.
Best Regards,
Angelia