Question

Filtering dimension selections

  • 6 December 2023
  • 3 replies
  • 129 views

Badge +2

Is there existing functionality to facilitate the filtering of a dimension input metric, say on a Department dimension, whereby subsequent selections would then be filtered based on only valid intersections that apply?  I currently have two input metrics, one by dimension Department and the other by dimension Position.  Is there a way that when the selection is made for Department, say “Accounting”, only the relevant Job Positions are now available within that dimension drop-down, so that something like Job Position “Legal Analyst” isn’t a viable option?


3 replies

Userlevel 6
Badge +12

Hi,

 

I believe the “Dependant dropdown” feature is answering your need:

 

It allows you to “connect” two metrics of type dimensions in order to have a dependency between them.

 

Does this help?

Badge +2

It looks as though this feature is isolated to a Transaction List, is that accurate?

Userlevel 3
Badge +4

Hi,

 

Yes you are correct - this feature is currently only available in list properties.

 

As you can see here, we hope to roll this feature out to metrics in the not-too-distant future.

 

Cheers,

Reply