Forum Discussion

amummert's avatar
amummert
New Member
9 years ago
Solved

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 fo...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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

  • amummert's avatar
    amummert
    New Member
    9 years ago

    This works beautifully, thank you so much!