Filtering data with 2 columns with beast mode?

KeiNish
KeiNish Member
in Cards, Dashboards, Stories

Now I have a dataset something as below;

ID

Cat

Name

Cond01

0001

1

A

3

0002

2

B

4

0002

1

A

3

0001

1

D

1

0003

2

B

7

0003

1

C

5

0004

1

A

9

…

…

…

…

Now I want to make two filter cards to select data by Name , conditioned with a Cat value,

where one card is for filtering data by Name when Cat = 1,

another one by Name when Cat = 2.

I want to extract data, for example, Name=A When Cat = 1 with the former and Name=B When Cat = 2 with the latter to get as below;

ID

Cat

Name

Cond01

0001

1

A

3

0002

2

B

4

0003

2

B

7

0004

1

A

9

But they don't work, they work separately.

Does anyone have an good idea to filter data with filter cards as above?

Thanks in advance!

Tagged:

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    Because you want to see the two combinations simultaneously, you'll need to combine the two columns. I did this using CONCAT(). I don't think this is the perfect solution, but it works. If you have many combinations of Cat and Name then this may not be ideal.

    1. Create a beastmode: CONCAT('Cat = ',Cat,' & Name = ',Name)
    2. Make the above beastmode a filter on the table card
    3. Make the selections in the filter:
      Screenshot 2024-04-25 at 6.15.54 AM.png

    4. End result is what you're looking for:

    Screenshot 2024-04-25 at 6.16.19 AM.png

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    Because you want to see the two combinations simultaneously, you'll need to combine the two columns. I did this using CONCAT(). I don't think this is the perfect solution, but it works. If you have many combinations of Cat and Name then this may not be ideal.

    1. Create a beastmode: CONCAT('Cat = ',Cat,' & Name = ',Name)
    2. Make the above beastmode a filter on the table card
    3. Make the selections in the filter:
      Screenshot 2024-04-25 at 6.15.54 AM.png

    4. End result is what you're looking for:

    Screenshot 2024-04-25 at 6.16.19 AM.png

    If I solved your problem, please select "yes" above

  • KeiNish
    KeiNish Member

    Thanks, ColemenWilson. It worked for tables to me.

    But indeed, what I really want is to make two or more filter cards function separately to get the data.

    For example, filter card X contains Name values A and C, and Filter card Y contains B and D.

    But choosing B of filter card Y after choosing A of filter card X, the choice of A is cancelled.

Categories