Numeric Range Slicer not showing correct values

Marvhall · ‎08-22-2023

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 want.

Then, I want to get a percentage of the records that are between those days. For example, 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.

Thanks in Advance!

Mahesh0016 · ‎08-22-2023

@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 · ‎08-28-2023

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!