Forum Discussion
How To Change Slicer Values According to Other Slice
My data like below.
| CreatedAt | Org | Dest | SearchCount | Type |
| 2022-11-01 | X | Y | 15 | Web |
| 2022-11-20 | X | Y | 25 | Mobile |
| 2022-12-15 | T | Z | 10 | Web |
And I have a table in my report like below.
| Org | Dest | SumSearchCount |
| X | Y | 40 |
| T | Z | 10 |
I want a create a slicer for SumSearchCount column in this table but it needs to be changes if I change other slicers like Type or CreatedAt.
If I use SearchCount column as it is for between slicer, it's not showing the sum amount. If I create a new column that shows sum of SearchCount group by Org and Dest, sum amounts are not changing with other slicer like CreatedAt or Type.
For example, If I want to see Org and Dest which has more than 30 Sum of SearchCount, between SearchCount slicer is not work for this case.
How can solve this problem?
Please I need help. Thanks.
2 Replies
- adudani
Memorable Member
Hi burcubelen ,
have re-created the scenario but curious question is that the amounts in the searchcount slicer is not changing selections in other slicers? Please provide a sample output if possible.
here, using the slicers, the searchcount is filtering based on selection:
unfiltered
Filtered version
- burcubelenFrequent Visitor
Thank you for responding! Sorry I couldn't explain it clearly (editted the question again).
The problem is here that if want to see if there is any Org-Dest for more than 30 sumSearchCount, between Slicer is not working as I want.