Hi, my team is currently working on a dashboard for a client who needs users to be able to select any measures from the data set to cross tab/visualize. is there a way to set up the dashboard so that a set of filters can allow users to choose the fields for both the x and y axis of a bar chart, for example?
Hi @jtroxel,
Would you be able to share a bit more information so that we can better assist?
- What are the two measures you’d like to use for the chart and what are you looking to show?
- How would you like the filters to be setup and operate in accordance to your visual?
- Are those measures being used for the chart calculated fields, and if so, please share
If any screenshots can be shared as well, that is always helpful!
Thank you
@Brett the idea is that there are a wide range of possible variables and we would like to give users the ability to choose which variables they want to see plotted at any given time. Our data set includes over a hundred variables collected from participants of a specific program and from many organizations across the country. These have been recorded at the encounter level so the ability to cross tab any combination of these data points can be a powerful analysis tool since the user query, (eg. age, by survey response category, or organization type) may likely change from session to session and building a dashboard that included a visual for every single possible permutation of these variables in not feasible or very user friendly.
The filters would simply list all the possible variables from the data set, and plot the X and Y axis based on user input.
Hi @jtroxel,
Thank you for the additional context!
Potentially, you could build a custom list dropdown and write out each of the options manually. Then write an ifelse statement for the Y and X values and return a specific field depending on user selection. This would be completely static and rely on the author to build out each of the options.
The best option though, may be to attach a Q topic to the dashboard so the user can ask natural language questions. That would allow for more individualized visuals and metrics to be displayed.
2 Likes
@Brett thanks i was thinking the custom dropdown but that offers less flexibility for users. Amazon Q looks very interesting as a solution but do you know if the pricing is associated with each author or anyone who visits the embedded dashboard?
Hi @jtroxel,
I’ll include a link below that explores the pricing options a bit more in depth! I believe that the pricing is more based on authors and readers in QuickSight as opposed to the users that view on an embedded dashboard. However, part of the pricing structure is for amount of questions asked, I believe questions asked at the embedded level would go against that total.
Let me know if you have any other questions!
1 Like
Hi @jtroxel, another approach is to develop using QuickSight SDK – control the filter from an external HTML/JS logic, here are some examples:
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
1 Like