Problem using group by with unix datetime value

Grafana Dashboards
1

I’m using a instalation from docker hub with version 9.4
I need to import some data from github and create dashboards from it, I’m using the Github plugin GitHub plugin for Grafana | Grafana Labs

The problem is: I have a panel in a dashboard to show a bar chart with total commits/day, but I can’t do that because of timestamp, I can’t group the date by day because he consider the timestamp with miliseconds.

image
image1390×422 27.3 KB

Here is the transformation

image
image2066×307 18.7 KB

Here is debug

image
image2092×694 93 KB

I tried to use overrides and the date are formatted correctly, but the new formatting is not used for transformations.

I just need to group this commits by day, how can I do ?

3

:Hi @jaconsmorais,

Welcome to the :grafana: community support forums !!

We are excited that you joined our OSS community. Please read about some of the FAQs in the community :slight_smile:

Can you please try to reproduce this same issue on https://play.grafana.org/ and then share the dashboard link so that we can view it?

Thanks

4

I think this is a bug

5

Hi!
You can reproduce the problem with this panel
{ "type": "table", "title": "Github Commits", "gridPos": { "x": 0, "y": 0, "w": 12, "h": 8 }, "id": 12, "targets": [ { "datasource": { "type": "grafana-github-datasource", "uid": "_sJ_nZm7k" }, "refId": "A", "queryType": "Commits", "repository": "grafana", "owner": "grafana", "options": { "gitRef": "main" } } ], "options": { "showHeader": true, "cellHeight": "sm", "footer": { "show": false, "reducer": [ "sum" ], "countRows": false, "fields": "" } }, "fieldConfig": { "defaults": { "custom": { "align": "auto", "cellOptions": { "type": "auto" }, "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "value": null, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "thresholds" } }, "overrides": [] }, "datasource": { "uid": "_sJ_nZm7k", "type": "grafana-github-datasource" }, "pluginVersion": "9.5.0-cloud.5.a016665c", "transformations": [ { "id": "convertFieldType", "options": { "fields": {}, "conversions": [ { "targetField": "committed_at", "destinationType": "time" } ] } }, { "id": "groupBy", "options": { "fields": { "committed_at": { "aggregations": [], "operation": "groupby" }, "pushed_at": { "aggregations": [ "count" ], "operation": "aggregate" } } } } ] }

image
image931×301 16.8 KB

6

I don’t know, Convert Field Type do not ask for output format, ask for input format, the format that de date is received from data source.

7

Hi, you can reproduce this problem using this panel.
{ "type": "table", "title": "Github Commits", "gridPos": { "x": 0, "y": 0, "w": 12, "h": 8 }, "id": 12, "targets": [ { "datasource": { "type": "grafana-github-datasource", "uid": "_sJ_nZm7k" }, "refId": "A", "queryType": "Commits", "repository": "grafana", "owner": "grafana", "options": { "gitRef": "main" } } ], "options": { "showHeader": true, "cellHeight": "sm", "footer": { "show": false, "reducer": [ "sum" ], "countRows": false, "fields": "" } }, "fieldConfig": { "defaults": { "custom": { "align": "auto", "cellOptions": { "type": "auto" }, "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "value": null, "color": "green" }, { "value": 80, "color": "red" } ] }, "color": { "mode": "thresholds" } }, "overrides": [] }, "datasource": { "uid": "_sJ_nZm7k", "type": "grafana-github-datasource" }, "pluginVersion": "9.5.0-cloud.5.a016665c", "transformations": [ { "id": "convertFieldType", "options": { "fields": {}, "conversions": [ { "targetField": "committed_at", "destinationType": "time" } ] } }, { "id": "groupBy", "options": { "fields": { "committed_at": { "aggregations": [], "operation": "groupby" }, "pushed_at": { "aggregations": [ "count" ], "operation": "aggregate" } } } } ] }

Here is the screenshot

image
image931×301 16.8 KB

9

Thank you yosiasz, I could make it using apache echart.

image
image1167×744 53.6 KB

1 Like
10

meu prazer you are welcome