Transformation does not calculate Total, Mean correctly

Grafana
1

Using Transformation when there are blank/null or Zero values causes incorrect Total or Mean calculations … is this a known issue or something to do with the data type of the field ? I tried giving 0 and also converting the data type to Numeric in the Query … still the issue persists … Grafana version is 9.3

image
image913×445 25.2 KB

Query
select A,B, count(*) :: int as Count
from table_name
group by A,B
order by 1

PS: There is a transformation before the above , that does transpose of data using “Grouping to matrix”

2

In the case of the image you posted what part is wrong?

Also what is your data source?

3

The totals highlighted in yellow … shows 16 +6 = 166 (string concat rather than addition)
and the next row result (15+409+18) = 4218 … not the math i learnt :smiley:

4

For sure :smile: I have seen this as a bug. Can you see if latest 9.x still has this issue?

5

will try on latest G10, but for now i am on 9.3.2 … tried using Volkov DynamicText and solved using js

image

2 Likes
6

And the latest dynamic text you can import external js and css

1 Like
7

Glad it worked for you.

@yosiasz Have you tried it? We will release a new version with external js/css next week.

1 Like
8

hey @mikhailvolkov I thought it was released in 4.0.0 :crazy_face:

Was planning to use it like following

<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js" integrity="sha384-geWF76RCwLtnZ8qwWowPQNguL3RmwHVBC9FhGdlKrxdiJJigb/j/68SIy3Te4Bkz" crossorigin="anonymous"></script>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-9ndCyUaIbzAi2FUVXJi0CjmCapSmO7SnpJef0486qhLnuZ2cdeRhO02iuK6FUUVM" crossorigin="anonymous">

or

<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Bootstrap demo</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-9ndCyUaIbzAi2FUVXJi0CjmCapSmO7SnpJef0486qhLnuZ2cdeRhO02iuK6FUUVM" crossorigin="anonymous">
  </head>
  <body>
    <h1>Hello, world!</h1>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js" integrity="sha384-geWF76RCwLtnZ8qwWowPQNguL3RmwHVBC9FhGdlKrxdiJJigb/j/68SIy3Te4Bkz" crossorigin="anonymous"></script>
  </body>

but will wait till released and read up on the doco for it

1 Like
9

unless I can clone

and build locally and test?

10

You can download the latest signed CI artifact to test: Add External JavaScript, CSS Resources (#197) · VolkovLabs/volkovlabs-dynamictext-panel@2ff9233 · GitHub

1 Like
11

Sanitizing should be disabled to see the panel options. Links have to be swapped :slight_smile:

Screenshot 2023-07-14 at 12.55.20

We don’t support link and script tags for security reasons and to ensure that scripts is loaded before rendering the panel.

2 Likes
12

this is yuuuge, game changer!

2 Likes
13

Looks great!

image
image1213×416 12.7 KB

2 Likes
14

thanks for addressing this ask Mikhail …

1 Like
15

tested with 4.1 and seems working wonderfully !! 1 minor issue though with “refresh interval” feature … the global js calls are not being made … guess can live with this for now :slight_smile:

image
image1015×345 26.3 KB

1 Like
16

We release Dynamic Text 4.1.0 and submitted it to the Grafana team for review: GitHub - VolkovLabs/volkovlabs-dynamictext-panel at v4.1.0.

What kind of data source do you use in the panel? The panel does not subscribe to Refresh Event. It relies on the Data Source to refresh the data and re-render the panel.

17

currently postgres but this is a special case - relying on web page events than datasource events alone :slight_smile:

1 Like
18

@samant You can subscribe to the Refresh Event in the Dynamic Text panel yourself since v4. Make sure you unsubscribe from all events to avoid memory leaks.

1 Like
19

Thanks @mikhailvolkov for this tip ! Will try

1 Like