I would like to be able to exclude items from visuals like bar charts but without changing the filtering, as this would affect calculated fields. (The calculated field already uses PRE_AGG, but only in the denominator, not in the numerator, so in the calculated field I cannot just ignore the filtering completely).
This is a feature request.
This is what happens when you exclude an item from a visual via the QuickSight interface. It also gets filtered out:
Hello @DanielH !
Thank you for suggesting this! I will mark this as a feature request for you.
One workaround that you could try is creating a calculated field that retains your Pre_AGG but also excludes your unwanted values.
Many thanks!
Regarding your workaround: The user should be able to select the items to be displayed via a filter or control panel.
I solved this with a multi-value parameter (selectedForVisual) and a multi-select control for the parameter as well as a calculated field (selected_for_visual).
This is the calculated field selected_for_visual:
ifelse(in({product name} , ${selectedForVisual}), {product name}, 'other products')
I then use selected_for_visual instead of product name for the X axis in the field wells for the bar chart.
The problem is, there is still a column other products in the bar chart which I donât get rid off without changing the value of the other calculated field which is used as the value to be displayed for each product in the bar chart. This calculated value is calculated as: distinct_count({xID}) / min(distinctCountOver({xID}, [{as_of_date}], PRE_AGG)). The items taken into account can be filtered via a regular filter, but the products to be displayed can be a subset of the filtered products.
Hey @DanielH !
What happens when you try âhidingâ the column in the field well? Does that distort what you want the end user to see?
Hi @duncan,
I donât see a way to âhideâ the column in the field well. I just want to âexcludeâ certain items (products) of the column product name from the bar chart. In my solution, I would now like to exclude the item other products.
When I right-click on the bar chart, I can âexcludeâ a specific item/product from the visual (in my case now other products), but this means it also gets filtered out which affects my caculated field which is being visualized in the visual.
Maybe I havenât phrased my solution precisely enough. Let me clarify a sentence from above:
The problem is, there is still a bar (formerly: column) other products in the bar chart which I donât get rid off without changing the value of the other calculated field which is used as the value to be displayed for each product in the bar chart.
Hello @DanielH !
I realized I made a mistake when saying âhideâ in the field well because that probably doesnât exist for the visualization you were using.
For the âother productsâ field, is that a field in your dataset or is QS creating that for values that donât match your filter like this screen shot below where I wanted Top 5 Customers in Sales by Month:
Please see my first post in this thread.
I have a field product name and select some of the products for the visual plus the remaining products are displayed in a bar under the name âother productsâ.
Hey @DanielH , itâs doing that because I used a function in the stacked bar graph visual that allows you to show a specific number of data points in each bar that can be found in the Group/Colour section of the visualization editor panel.
I chose 5 so that I would only see the Top 5 customers in sales each month and how many sales they made up collectively, but it includes âothersâ to be a total of the other customers from the range to show total sales for that month.
Heads up, I am going to archive this so that the feature request for being able to exclude items from visuals without filtering is pinged to the Quicksight team.
