I can display the value of a single value parameters in an Insight visual, but have not found a way to do this for a multiple value parameter.
I would like to be able to display all the values if there are only a few and something like the filter summary does on export when we have more values: Value 1, Value 2, Value 3, and 6 more
Hi @MikeB,
Did you try creating a control on the multi-value parameter? Using a control with a parameter in Amazon QuickSight - Amazon QuickSight. You will get a filter like experience. Is this what you were looking for or did i misunderstand the question?
@MikeB by display you mean e.g. in a title like “product by value1,value2, value3”
@awsvig @ErikG Thank you for the replies. I’m wanting something like what QuickSight generates at the bottom of an exported PDF for a dashboard with the controls on the top. It shows something like this:
Showing
Minimum Year 1999
Maximum Year 2013
Department Advertising, Research, Sales and 2 more...
If we could recreate this in a Text box or Insight, we could control the placement of this information and also display it when the controls are on the sheet instead of on top.
We might also be able to display more information as the generated version on export only uses about 40% of the width of the page.
I haven’t found a way to convert a multiple value parameter to a string or how to reference individual elements in the parameter in order to display them in a similar manner. It would be nice to have a function that could generate the string like Advertising, Research, Sales and 2 more... up to a specified length.
Hello @MikeB, it might take some trial and error, but based on my testing, you can definitely build something close to this using Insights. For example, if I am using a multi-value parameter controlled filter for Department, I can add Top Departments as a calculation into an insight. For this, I just based it on the count, and you can increase the number it returns (up to 20). As long as you never exceed that number this would work.
Then I created a line for Department, added the appropriate spacing and then added an Inline FOR function. Then you can return the Top.items[index].categoryValue.formattedValue for each option that is returned in a single line. Once you are done, you can add a filter for the visual based on the parameter. I know that only resolves part of what you wanted to build, but then you could add calculations for Min and Max to get your year values.
I will mark this as a solution, but if you have questions for implementing this, please let me know!
Hello @DylanM. Thank you very much for the suggestion. This gets us close to what we were wanting by giving us the ability to list up to the first 20 items. It looks like I can also add a count distinct on the column to get also the total number of items and calculate the and N more... using this count - 20.
Do you have any suggestions on how to determine if Select all is chosen for a given parameter. It would be nice to show All instead of trying to list everything out. Especially since we have more than 20 options for many of these.
Hello @MikeB, as far as I am aware, there isn’t a work-around to display more than 20, but you could include a 2nd function to display the bottom 20 as well. The only issue is if you filtered it down, it would just display the same filtered values twice. Plus if you have more than 40 total options, it wouldn’t display all items.