As the title says, I am looking for a way to create a multi-select single control to be able to check/uncheck KPIs to be showed in a combo chart.
So far, I have managed to create a control for each parameter, and this achieves the functionality I want but from a user’s perspective it would be better to have it in a single control.
To clarify, do you want the user to be able to select one or multiple fields to appear in your group/colour by for your combo chart?
If so you have the right idea with your ifelse statement above, but I’m not sure what you mean with your current calculated field. Do you only want fields to be in the chart if they have a value greater than 1?
Did this response work for you? Were you looking for validation of your approach? 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!
