Reg Dynamic Sliders based on User Input Measure parameter values

Question & Answer
, , ,
1

We have a user defined single select parameter ( With two values Sales and Quantity) for X axis selection for Scatter Plot

The chart displays Sales Measure if user selects Sales

and Quantity Measure if user selects Quantity

We are able to achieve the dynamic axis implementation in the graphs.

In addition to this, we need a slider control displayed in the screen and filter based on slider as well

If User selects “Sales”, we need to vary the min and max value of the slider to database min(Sales) and max(Sales)

If user selects “Quantity” We need to vary the min and max value of the slider to database min(Quantity) and max(Quantity)

Please advise on this implementation

1 Like
2

Hello @SAILAKSHMI, welcome to the QuickSight community!

I have experienced a very similar requirement. There are basically 2 possible solutions to for this. First, you can create the slider filter based on a calculated field. The only issue with this is that the default min and max values will need to work across each of the possible field types a user can select. I have had the best luck with this when using percent values since that is always 0 - 1.

If your field was like this:

ifelse(${Parameter} = 'Sales', {Sales}, ${Parameter} = 'Profit', {Profit}, ${Parameter} = 'Quantity', {Quantity}, NULL)

Then you could create a filter for the sheet that would use the Between option:
image

This can then be added as a control to the dashboard:
image

Alternatively, if you switch to the free-form layout for the sheet, you can create slider filters for each of the field options the user selects between. Then, depending on the parameter selected, you can hide all of the filters besides the one selected. This will then allow you to use better min and max options for each of the field values. You are required to use the free-form layout for this option because it is the only way to utilize the conditional rules feature for the visuals:

This also means the sliders will need to be in the sheet itself rather than in the control panel.

One of these 2 options will be the best way to create the filter you are looking for. Please let me know if you have any remaining questions. Thank you!

1 Like
3

I understand the dynamic parameter picking part and also hiding multiple slicers in free form layout

Suppose I have two sliders one for sales and other for quantity
It is asking me to explicitly define the Max and min value (hard code some number)
What I want here is my min and max to be dynamic .
It should be based on the database state , like min(Sales), max(Sales)

That way I see different values for min and max based on my DB loads

Hope Iam making my use case clear

Thanks,
Lakshmi

1 Like
4

Hello @SAILAKSHMI, unfortunately, there is not a good way to manage this with a slider filter. I have come across this same limitation in dashboards I have created, which is why I primarily use the double slider filters for percent values so it can just be 0 - 1 or 0 - 100. That is where I have had the most success.

In order to provide more information to assist the user, you could leave the slider filter with arbitrary min and max values, but also display the min and max values from their data in KPIs to work alongside the filter. That way you could provide the necessary information to assist with the filter.

Otherwise, there really isn’t a better alternative option. At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. Since the functionality you are looking for is not currently possible in QuickSight, I have tagged this as a feature request. Please let me know if you have any remaining questions, otherwise I can archive this topic for our support team. Thank you!

1 Like
5

Hello @SAILAKSHMI, since we have not heard back from you with any remaining questions, I will archive this feature request for the support team. Thank you!