Hi @Vish , Thanks for the update. As per the recent requirement, if the rows with similar COMPONENT are required to be combined in a single row, then one of the following options could be used, if the BASKET is required in the final result, then use the following search, index=<index_name> sourcetype=<sourcetype_name>
| table COMPONENT, BASKET, AGE
| search BASKET=$tok_basket$
| stats values(AGE) as AGE, values(BASKET) as BAKSET by COMPONENT if BASKET is NOT required in the final results, then use the following search, index=<index_name> sourcetype=<sourcetype_name>
| table COMPONENT, BASKET, AGE
| search BASKET=$tok_basket$
| stats values(AGE) as AGE by COMPONENT Here, the filter $tok_basket$ passes the BASKET number as the user selects and filters out the results. Kindly support the answer if found helpful.
... View more