synthetic Dimension with calculated values

[#1]

Hello,

it is possible to create a chart with a calculated dimension?

Data:

[ Orgname, .......... ,Tax-Number

'A', ......, null

'B', ......, 123

'C, ......., 111

'D', ......, null ]

I want a pie chart with to values

- count of Orgname with a taxnumber

- count of Orgname without a taxnumber

and without a calculated field from the script

best regards

[#2 · Accepted solution]

Yes Bauern its possible.

Use the below code in pie chart: dimension and expression respectively.

=If(isnull(Tax-Number),'Without Tax Number','Tax Number')
=count(Distinct Orgname)

Regards,

Kiran.

[#3]

perfect...... thank you