Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart where I am trying to restrict the dimension values displayed in the chart. I want it to show all the values for the proj_type_code field except ESG Activities.
This works:
=If (proj_type_code = 'ESG Activities', proj_type_code)
But this does not work:
=If (proj_type_code -= 'ESG Activities', proj_type_code)
Any help would be greatly appreciated
You used my expression as calculated dimension?
Have you checked "suppress when value is NULL"?
Hi
I think you mismatched the use of -= with a set expression.
Why not try
=If (proj_type_code <> 'ESG Activities', proj_type_code)
?
Regards,
Stefan
Please see the two attachements. Image 1 is the chart before filtering on the dimension. Image2 is after applying the filter. Its not displaying properly.
Suppress null values of the calculated dimension on the dimensions tab.
You used my expression as calculated dimension?
Have you checked "suppress when value is NULL"?
Yes. In the meantime, I got it to work by adding the filter to my expression:
count({$<proj_mgr_name -={"Admin","*admin*"},proj_active_flag={"Yes"},proj_type_code -={"ESG Activities"}>}proj_nbr_id)
I'm just surprised that I can't seem to get this to work using a calculated dimension.
I didn't check supress value when null. Its working now - thanks.