Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I am using SVG Map. my requirement is to display count of CUST_ID as % as well as #. to display % , I'm using following expression.
Num(Count([CUST_ID]) /Count(Distinct([Cust_ID])),'###0')&'%',
But when I add second measure count( distinct(CUST_ID) ) to show count as number , my visualization gets disabled.
How can I show both outputs in single SVG . Really appreciate your help!!
Num(Count([CUST_ID]) /Count(Distinct([Cust_ID])),'#,##0.00%')
Hi,
in the map you can simply use the expression as
=num(Count([CUST_ID])/count( all [CUST_ID]),'#,##0.00%')
or
=num(Count([CUST_ID])/count( total [CUST_ID]),'#,##0.00%')
Hi,
It has to be:
Num(Count([CUST_ID]) /Count(Distinct([Cust_ID])),'###0%')
Thanks,
AS