Forum Discussion

Marvhall's avatar
Marvhall
Icon for Helper I rankHelper I
3 years ago

Numeric Range Slicer not showing correct values

Hi all,   What I want to do, and can't find, is create a second slicer that shows the Min and Max values according to the submission period. See below. This is what I get. This is what I wan...
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

Marvhall  please can you elaborate on this, if there are 400 records between those min and max values and 800 records total, I should see 50% of records that lie between those values.

how to calculate  400 records and 800 records total.

 

  • Marvhall's avatar
    Marvhall
    Icon for Helper I rankHelper I
    3 years ago

    Good day!

    Sorry for the late reply, I was at a conference and didn't have a chance to answer this question.

    I am getting the results in the first set of pictures, where the Slicer that shows the min and max values as -241 and 207 for the submission period of 2023Q1. 

     

    First, I want to see is the Slicer that shows the min and max values as -6 and 49. 

    Second, a formula that gives me the percentage of the records between the slicer min and max values.

    For example, if there are 800 records in the entire dataset in 2023Q1 and 400 of them are between -6 and 49 (including -6 and 49), the percentage should be 50%. If I slide the slicer to values 0 and 7 and let's say there are 100 records between those values, the percentage should be 12.5% of the total records (in 2023Q1) are between 0 and 7. 

     

    Thanks!