Forum Discussion
Suggestions for Numeric Range Slicer based on aggregate data
I have a report that shows aggregate page views for a long list of pages on our websites (among other things). The underlying data is broken down by date, but the table in the visual is aggregated for all dates.
I want to add a numeric range slicer so that users can look at pages within a selected range of page views. problem is, the slicer is based on the row-level data, not the aggregate, so my slicer's ranges don't match what's actually displayed in the report.
I tried adding a conditional column in the query, but realized it's the same problem there...the ranges apply to each row, not the aggregate.
I can't do a numeric slicer on measures.
Any ideas of another way I can get there?
-Anita
Hi amummert,
If I understand you correctly, you can firstly create a summarize table to list all page ids and its page views, and add a relationship between the summarize table and your table with the page id column. Then you should be able to use the page views column from the summarize table as Number Range Slicer on report in your scenario.
The formula below to create the summarize table is for your reference. :smileyhappy:
Table = SUMMARIZE ( 'Your_Table_Name', 'Your_Table_Name'[Page ID], "Total Page Views", [Sum of Page Views] )Regards
2 Replies
Hi amummert,
If I understand you correctly, you can firstly create a summarize table to list all page ids and its page views, and add a relationship between the summarize table and your table with the page id column. Then you should be able to use the page views column from the summarize table as Number Range Slicer on report in your scenario.
The formula below to create the summarize table is for your reference. :smileyhappy:
Table = SUMMARIZE ( 'Your_Table_Name', 'Your_Table_Name'[Page ID], "Total Page Views", [Sum of Page Views] )Regards
This works beautifully, thank you so much!
