I have some data similar to this structure and i want to create dashboards based on the sub categories (like XXXXX is one type of category)
and this is how i want part of my dashboard to look like (with bar graph only showing the selected customerid in x-axis)
expectedresult
I am new to data visualization, so please ignore if this is a dumb question.
Thank you in advance
Hi @arun,
To do this you can do the following:
- Load the data in to QuickSight.
- Create a bar chart based off item_id and price - decide if you want price to be sum, avg, min, max etc…
- Create a parameter for customer id.
- Add the parameter as a control on the sheet.
- Add the parameter in a filter - to do this select custom filter, then check use parameter.
You can’t show the selected ‘customer id’ in the x-axis, but you can include the value of the parameter in the visual title.
Let me know if that helps.
1 Like
Thank you so much, it worked.
2 Likes