I need to implement the following functionality in Tableau:
- Grand Total-Based Range Filter
- The filter should allow users to select a range for <a Measure field 1> based on the aggregated grand total value (e.g., 590 Crs in the full dataset).
- Users should be able to specify minimum and maximum values to dynamically filter the data within that range.
- Sorting by <Measure field 2> (Collection Efficiency)
- Sorting should be based on the <Measure field 2> Grand total at the same level as the displayed data (e.g., Zone, District, State combined).
- Users should have the flexibility to choose Ascending or Descending order through a parameter.
- Top N Flexibility
- Users should be able to select the number of top records to display (e.g., Top 5, Top 10, Top 20) based on <Measure field 2> Grand total Value.
- This should work dynamically with the applied filters.
The goal is to provide a dashboard where users can:
- Filter by a range of <a Measure field 1> using grand total logic.
- Sort the view by <Measure field 2> in either ascending or descending order.
- Display only the top N records based on <Measure field 2>.
Note : Every thing should be implemented on Grand total values.
Below I am sharing the Dumb Data.
1 answer
@Rohit Chauhan Were you going to include a TWBX? An illustration of usage-- even if it's hand-drawn, would be helpful.
Michael Hesser (Tableau Forum Ambassador)
If this response has answered your question, kindly click "Best Answer"