Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
perfect...... thank you