Forum Discussion

burcubelen's avatar
burcubelen
Frequent Visitor
3 years ago

How To Change Slicer Values According to Other Slice

My data like below.

CreatedAtOrgDestSearchCountType
2022-11-01XY15Web
2022-11-20XY25Mobile
2022-12-15TZ10Web

 

And I have a table in my report like below.

OrgDestSumSearchCount
XY40
TZ10

 

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's avatar
    adudani
    Icon for Memorable Member rankMemorable 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

     

     

     

    • burcubelen's avatar
      burcubelen
      Frequent 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.