I’m working on configuring a Metric Card that summarizes data from an Object Table (the table includes item numbers, sale price, repair cost, quantity, etc.).
The issue I’m running into when applying search filter variables.
When I search for multiple item numbers (e.g., 3 part numbers), the table correctly displays all 3 items however,
When trying to connect the same search filter variable to the Metric Card (so that the metric only calculates the filtered results in the object table), it immediately forces the filter down to a single item. This happens when I’m trying to perform an object aggregation to calculate the total Qty of parts in the object list.
In other words, the Object Table correctly filters to the input in the search bar, but when trying to add a search filter variable to the metric card to calculate the SUM (aggregated) list of parts in the search. The search bar prevents the ability to select multiple parts in the search.
Has anyone solved this before, or is there a known workaround to make the Metric Card perform a SUM aggregation to an object list that has a search filter applied, without the search bar only allowing 1 input.
Hi @WJAMR could you show what you mean that it „forces you to select a single“? to me your setup looks correct. only thing I noticed is that you have configured „total qty selected“ to be only calculated by event trigger. Is there any specific reason? Since this would prevent your variable from updating even if the table backing object set updates. Can you set this to automatic and see what changes?
Thanks for getting back to me, you’re right about the event trigger and have made the change to automatic now. i’ve added the search filter variable to display the results from the search bar - however upon adding the filter it prevents you from being able to search for other parts choose from. (see red arrows)
the black arrows show the that the SUM for the Qty is working. however, when i add the search filter variable {Named: part_number_filter_output} , the search only allows me to select 1 part number and does not allow me to search for other parts.
(ignore the validation error in the bottom of the screenshot, as this is unrelated)
What is the input object set to your search filter? I suspect you are passing it the table object set, instead of the full set of all parts. That is the only reason I can think that it reduces down to a single object.
Can you send a snapshot of the parts search filter setup?
Okay I think I have an assumption what the issue is.
It looks like your filter variable is backed by the same objective set as the object table itself. This causes the behaviour to also filter down the filter list itself after having applied a selection (and not only the resulting set for the table). It can be a desired behaviour and it is also the default when using the in-table filtering.
However in your case you want to de-couple the two. Can you Check which is the starting object set of your filter variable? I assume it is Part Number Object Table. By replacing this with Part Pricing your filter list should always keep all objects while the table is getting filtered for the selected.
as you mentioned de-coupling - I’ve had to create a new Object set definition especially for the metric card and applied the search filter output from the object table as the variable output. so whilst it’s performing the same output. it’s no longer inherently linked to the object table.
Attached is the object set filter configuration - I’m applying this same filter variable for the object set table & the filter list widget and the issue is when adding this filter to the metric card metrics. Essentially, I want to apply the same filter across all the metrics on the card so all the relevant calculations are performed against the same list of parts in the object set. (total profit, repair costs, etc.). I’m using the whole object “part pricing” for the object type with a string array variable against PN.
See screenshots for the string array variable transformation, which is attached to the search, as well as the complete configuration for the filter list widget.
