Report Filter limitations

[pramn]

Hey Team, 

in a specific  dashboard we are using filter is called middleware , we would like to limit the options , can we do that ?

suppose 

in the filter we have several options, can we limit to above 4 values? only 4 of this should visible remaining should not .

[Dr Atul G- LNG]

No mate, that’s not possible as it’s coming directly from the table level. @pramn 

[VinayKumarKarne]

Hi @pramn 

Yes, it is possible to limit the values users can see in Platform Analytics filters.

There are two ways to achieve this:

Option 1: Add a Condition Directly on the Filter (Easy Method)
Open your Dashboard.
Edit the Interactive Filter.
Add a filter condition.

Result: Users will only see records that match the condition.

Option 2: Use a Breakdown Source (Recommended Method)
Create a Breakdown Source on the required table (for example, sys_user).
Add conditions to limit the records.

Result: Only the users returned by the Breakdown Source will appear in the filter list.

Note: Identify Middleware field original table (sys_choice)

[Matt H NW]

In the filter's Configuration panel did you try Filter source > Configure values or Default values.