Hey,
We have a dashboard and query filter. We are able to filter the table output, but we want the filter to also be applied on Aggregation values in this dashboard (Top area e.g. Total bitrate, number of services, Avg etc.) Today these aggregation values are not being filtered by the query filter (They show total amount regardless of the filter that is being picked).
Can you please help us achieve that these values will be filtered also by the query filter?
See snapshot below.
Thank you.
Today these aggregation values are specific "QUERIES" that calculate these values. We don't mind using a different approach if needed.
Thank you.
Hi Guy,
This is a known limitation. Ideally, your aggregation queries should be based on the filtered query from the Query Filter component.
The only workaround I’m aware of is to remove the Query Filter component and replace it with individual controls, like a static dropdown for the types, then link these controls to filter operations in your queries. However, this isn’t quite the same, since you’d lose your statistics and the filter would operate independently of whether the value exists in the table.
Overall, it’s not an ideal solution. This isn’t an uncommon request, so it’s on our backlog and we hope to include it in a future version of DataMiner.
Hi Guy,
Are these aggregation values done by aggregation rules, or are you aggregating in GQI?