Could the new Heatmap work like Carpet Plot

ulrichc · June 18, 2022, 6:52am

I use Carpet Plot to show a dot for each hour (y-axis) of each day from a year (x-axis).

My data is stored in an influxDB:

How could i do this with heatmap in grafana 9?

yosiasz · June 19, 2022, 2:32am

Could you please provide some sample data as csv inline like

time,value
2022-06-18 01:00:00,4

Created with random data

github.com

yosiasz/learninflux/blob/main/scripts/carpet.py

import pandas as pd
from influxdb_client import InfluxDBClient, Point, WritePrecision, WriteOptions
from influxdb_client.client.write_api import SYNCHRONOUS
from datetime import datetime
from dotenv import load_dotenv
import os
load_dotenv()

TOKEN = os.getenv('TOKEN')
URL = os.getenv('URL')
ORG = os.getenv('ORG')

bucket = "venus_default"

"""
Write data into InfluxDB
"""
client = InfluxDBClient(url=URL, token=TOKEN, org=ORG, debug=True)
write_api = client.write_api(write_options=SYNCHRONOUS)

This file has been truncated. show original

ulrichc · October 26, 2022, 12:50pm

sry for late reply

carpet plot changes x with y, so you could have a different view

public access: Grafana

Topic		Replies	Views
Plot heat map or carpet plot of multiple sensors vs time Grafana	0	1262	March 14, 2019
Table with values like HourlyHeatmap or CarpetPlot InfluxDB heatmap	1	242	June 6, 2023
24-hour heatmap / histogram of n Days (data source- graphite / Whisper DB) Grafana	5	3817	January 25, 2021
Can we use "Carpet plot" plugin for heatmap n*n Grafana	0	475	November 1, 2019
Heatmap - IP traffic by IP-address Grafana	0	1028	November 11, 2019

Could the new Heatmap work like Carpet Plot

Related topics