I’m new to quicksight and i want to create visuals where I can modify one of the axis, for eg if I want count of fruits, I choose fruits and get a bar chart with each fruit and it’s count. I have been trying with parameters but unable to use it, any help? A
Hi,
You can use calculated field long with a control to achieve this. Create a calculated field called Yaxis like:
ifelse(
${Xaxis} = ‘Fruits’, {Fruit_Col_Name},
${Xaxis} = ‘Vegetables’, {Vegetables_Col_Name},
NULL)
And when plotting, you can use Yaxis calculated field as the Yaxis and Count as the XAxis for example, for a horizontal bar chart.
Hope that helps!
Best Regards