Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to write an expression in order to create a "fast choice button" on a filter pane?
In the dimension Department, I have three departments (HR, Finance & Legal) that I would want to include in the filter pane as "Business support" in order to save the user two clicks.
I've looked around and found solutions on how to filter out one, or show sub-categories, but nothing on above. I'd be grateful if anyone can help, thanks!
Create a filter as follow:
if(Department='HR' or Department='Finance' or Department='Legal', 'MyGroup', 'other')
per analogy; u can even use it as a button not a filter
as follow:
create a treemap
as dimension:
=if(Dep='Dep1' or Dep='Dep2','MyGroup','Others')
as a measure : 1
result:
Create a filter as follow:
if(Department='HR' or Department='Finance' or Department='Legal', 'MyGroup', 'other')
per analogy; u can even use it as a button not a filter
as follow:
create a treemap
as dimension:
=if(Dep='Dep1' or Dep='Dep2','MyGroup','Others')
as a measure : 1
result:
Perfect! Thank you!