@abacon @Naveed
I need to create a pivot table by grouping Site domain and summing up the impressions.
Then I need only the bottom 10 site domains having IMPRESSIONS >1000.
I am not able to figure this out .
I have added a bottom 10 filter and another Impression >1000 filter . (I know this is incorrect because its not filtering on the grouped impression value but individual impression value.).
Does anyone know how to solve this issue or any work around?
Hello @SanthoshV, it seems like the best way to handle this type of filtering on the table would be utilizing the Top and Bottom filter type on your visual. You can select the number of values you want to be included. I’m having trouble finding some solid documentation on the filter, but I did find this info page and this stack overflow page. Your best might might be adding a calculated field that would run an ifelse to only return Impressions > 1000, then utilize the top and bottom filter to only get the bottom 10. Let me know if that helps!
Hey Thanks for your reply , But I don’t want to run an ifelse to only return Impressions > 1000. I want to filter impressions>1000 in the pivot table sum(impressions) values by site domain and do bottom 5 Values.
After this Whenever I try to do bottom 5 filter It’s showing “no data found in this visual”
Hello @SanthoshV, what if you used the denseRank function on your impressions field, sorted it for DESC so the lowest 5 would be at the top, and partitioned it by site_domain. Then you can add that calculated field to your table and select “hide” on the dropdown from the field well. Now you could add a filter to return values that are less than or equal to 5. I think that would work!
