Total device count in Dashboard

Grafana Configuration
1

Which version of Grafana and which operating system are you using?

Linux Rocky 9
Graphical version 10.4.8

What are you trying to achieve?

I’m trying to sum the number of managed devices on the Fortigate. For example, there are items created in Zabbix for 10 APs managed by the firewall. I need to sum the number of devices and ebiri on the dashboard.

How are you trying to achieve it?

Captura de tela 2025-12-16 123228
Captura de tela 2025-12-16 1232281092×577 115 KB

I’m trying data transformation in the add calculation field.

What happened?
The result multiplied several values. I did this based on the availability item of the APs.

What did you expect to happen?
Sum the number of devices and ebiri on the dashboard.

Can you copy/paste the settings you are having problems with?

Yes

Did you receive any errors in the Grafana UI or related logs? If so, please tell us exactly what they were.

No

Did you follow any online instructions? If so, what is the URL?

No

2

Can you post a sample “Table view” of your data? Sounds like you are after “Count” or “Distinct Count” instead of “Total” in the calcs.

“Total” is used for numerical sum so only applies to “number” values only not strings / plaintext data.

1 Like