Filter based on a field with different values

Q&A
,
1

Hello community,

I want to set up a filter across different datasets that contains the same column. The issue that I am finding is that I don’t have the same values across all the datasets, therefore when I set up a filter it will only show the vales existing on the dataset that I choose.

In a more practical way, here is what I have:

Dataset A - Column values:
A,B,C,D

Dataset B - Column Values:
A,E,F,J

Dataset C - Column Values:
A,B,F,G,H

The idea is to have a filter list that shows all the values. Is this possible?

Thanks for the help!

2

Hi @miguelantunesp ,

Sounds like you want to union the values against the column. Since this would involve appending the value list, we cannot do it in calculations.

However if you are querying a database, you can write a query to union unique value list and create a dataset only with these values. Then a parameter configuration can help show all values listed but filter only the ones applicable to each dataset. The only downside I can think here is creating another dataset where you have a data load / querying step which is redundant.

Alternately if the value list is not changing dynamically and you have a fixed list of values, you can skip the dataset creation part and directly configure a parameter and control with the list of expected values. Here the challenge is if new values are expected, you would need to add them manually to the control value list, else they will not appear on the dashboard.

Thanks,

Prantika

1 Like
3

Thanks @prantika_sinha! I will check what is the best solution, but probably a union of all the datasets should be the best solution. Thank you