topic Re: Adding a filter pane for a calculated field in Data Movement & Streaming

Adding a filter pane for a calculated field

Selis — Wed, 19 Mar 2025 21:48:59 GMT

Hi,

I have a table with several columns. One of them is a calculated column. Now I want to add a filter pane which allows the user to filter this column (e.g - to choose all the numbers above or below a specific amount).

Is it possible (since I know that filter pane accepts only dimensions.) ?

Thanks.

Re: Adding a filter pane for a calculated field

sk88024 — Mon, 11 Nov 2024 07:04:40 GMT

you can make a master item (dimension) using the expression of that calculated column. And then use the same master item in the filter pane.

Re: Adding a filter pane for a calculated field

Selis — Mon, 11 Nov 2024 07:39:31 GMT

Hi,

I've tried it but it doesn't work.

Thanks.

Re: Adding a filter pane for a calculated field

sk88024 — Mon, 18 Nov 2024 07:39:03 GMT

Not sure what your data looks like, so I have just created an example based on your question:

Load * Inline [
Number, Amount
1, 20
2, 30
3, 40
4, 50
5, 60
6, 200
7,90
8,100
];

Create a master item (dimension) using the calculated expression with field "Number" from Inline Load table:

Now, use the same master item in the Filter pane:

Hope this helps!!