Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for Time series Panels #34

Open
logut opened this issue Sep 3, 2023 · 4 comments
Open

Support for Time series Panels #34

logut opened this issue Sep 3, 2023 · 4 comments
Labels
enhancement New feature or request

Comments

@logut
Copy link

logut commented Sep 3, 2023

Are Time series supported ? If so could you provide an exemple Panel with query ?

I tried select date_trunc('minute',CAST(datetime AS Timestamp)) as datetime, host, count(*) as count from httpaccess where status like '2%' group by host, date_trunc('minute',CAST(datetime AS Timestamp));, it works when adding in the Panel a Transform Convert field type to manually set datetime field as Time type.
I would also like to have multiple series based on the host field but can't get it to work.

@nitisht
Copy link
Member

nitisht commented Sep 3, 2023

Thanks for reporting @logut . Do you have an example - what are the columns and what type of output you're looking for?

@nitisht nitisht added the enhancement New feature or request label Sep 3, 2023
@trueleo
Copy link

trueleo commented Sep 3, 2023

@nitisht i think this is what they are referring to https://grafana.com/docs/grafana/latest/panels-visualizations/visualizations/time-series/

from query it looks like. It is series on different hosts where Y values are count and X is time in minutes

@logut
Copy link
Author

logut commented Sep 9, 2023

Stream is for http server access logs and looks like:

{
  "datetime": "2023-09-08 18:18:52.228",
  "host": "example.com",
  "hostname": "server01",
  "p_metadata": "",
  "p_tags": "",
  "p_timestamp": "2023-09-08T16:19:12.223",
  "status": "200",
  "timetakenms": "485",
  "ua": "Uptime-Kuma/1.23.1",
  "uid": "ZPtJbDECRXzn_xsGypWcQQAAAAc",
  "uri": "/index.php",
}

The output might look like:
image

@nitisht
Copy link
Member

nitisht commented Nov 23, 2023

Thanks @logut we'll see how to add this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants