Table Panel not updating number of rows filtered

Grafana Dashboards
1

  • Versions Tested (Grafana v9.16 , 8.5.2)
    Table panel not updating the number of rows when a filter is applied in UI.

  • What are you trying to achieve?

Want to show count of rows when a client side filter is applied through table panel filter
I am using Table panel to display data from MySQL database.
Using Column filter (Enables/disables field filters in table) button on panel configuration, table filtering is enabled.
Also the table panel has pagination enabled.

  • What happened?

When a user filter data using the column filter, th count of rows that appears at the bottom right is not getting updated with the count based on filter, rather shows the total count of rows read from panel query.

  • What did you expect to happen?

The count of rows should be updated with the count based on filter if a filter is active ?

  • Can you copy/paste the configuration(s) that you are having problems with?
    Attached dashboard JSON using a simple mysql.metrics table.

For example. The below table panel is having no filters and it shows 602 rows at the bottom.

without_filter
without_filter1826×521 39.4 KB

The below screen , I am filtering 2 metrics. But the count still shows 602 entries.

with_filter
with_filter1822×430 47.1 KB

Is there any way to show the number of rows present when user do a client side filtering ?

2 Likes
2

Any response from Grafana team? Its odd that going to last pagination page shows x-y of n where y is updated on filtered list but the count view still shows n

3

is there an update on this? I have a manager requesting a row count on a filtered table.