Combination Chart : Multiple Scales do not show up

[Sony Hejmady]

Hi,

I have a scnario where I have 6 matrix calculated separatley in two combination chart and the expressions of Y axis are as below.Now Can I display Primary Axis as Number and Secondary Axis as % together in one Combiantion Chart Also Multiple Scles do not work.

Percentsge calculation:

Sum([Auto-categorized Nr]) / Sum([Total Item Nr]) as [Auto-categorized %],

Sum([Categorized by User Nr]) / Sum([Total Item Nr]) as [Categorized by User %],

Sum([Total Uncategorized]) / Sum([Total Item Nr]) as [uncategorized %]

 

Number calculation out of Total Nr:

Sum([Auto-categorized Nr]) / Sum([Total Item Nr]) * 100000 as [Auto-categorized Nr],

Sum([Categorized by User Nr]) / Sum([Total Item Nr]) * 100000 as [Categorized by User Nr],

Sum([Total Uncategorized]) / Sum([Total Item Nr]) * 100000 as [uncategorized Nr]

[Fabian Duerr]

You can activate multiple scales in the properties of your visualization. Just go to 'Y-axis' and click multiple scales. Then got to 'Formatting' and change your axis format to whatever you need.

Please upload a dxp file if this somehow doesn't work for you.

[Sony Hejmady]

Hi,That did not work.Thank you for the response.I have this layout from the User which I need to build.

[Fabian Duerr]

Please see attached dxp file in my previous answer

 

 

If you can share your file I can try to find the issue