Create a Range Filter with Min/Max Values Defaulted to Pivot Value Fields?

Q&A
, , , ,
1

How can I create a range filter (min and max) on a Pivot Table’s value field that defaults to the relevant min/max values in that field in the table? I am trying to replicate a slider control from Tableau (see below), but am open to any on-dashboard filter control(s) type so long as it has the same with the same functionality: default to the min/max shown, and the user can filter within that value range.

Fields:

Revenue Per Account = sum({Transaction Amount})/distinct_count({Account ID})

Transactions Per Account = distinct_count({Transaction ID})/distinct_count({Account ID})

Considerations:
The user has controls to dynamically change the pivot table groupings (attributes) as well as other filters. The values will change due to the filters and groupings.

What I’m trying to replicate:

This is how it the defaults look in Tableau. Ignore the data bars and group-wise color, I know that is not possible in Quicksight (though it should be, please!).

  1. No filters applied. Revenue filter defaults to 72-74704. Transactions range from 1.50-83.

screen shot of pivot in tableau. slider filters at the bottom default to the relevant values from the table.
screen shot of pivot in tableau. slider filters at the bottom default to the relevant values from the table.594×386 38.5 KB

  1. Changed attribute groupings and filtered by Age Decade, which changed the values. The slider filter min/max reflects the new range of values.

screen shot of pivot in tableau. slider filters at the bottom default to the relevant values from the table after filters are applied.
screen shot of pivot in tableau. slider filters at the bottom default to the relevant values from the table after filters are applied.574×246 20.4 KB

2

Hi @C_B ,

To my knowledge it is currently not possible to have the values of a slider control to be drawn from a table visual. That would be a neat feature to have. With that said, I will attach the ‘feature-request’ tag to this post to help increase visibility to the Quick team.

Create a Range Filter with Min/Max Values Defaulted to Pivot Value Fields? pt 2