Feature request - Calendar Heatmaps

[accforgithubtest]

It would be great to have a calendar heatmap chart as a component. Similar to the github commit activity charts. Any chance you might consider adding this chart as a feature ?

something that looks neat as a example - https://github.com/g1eb/calendar-heatmap. [Probably this question doesnt make sense, I am not a developer myself, but is there any way this calendar-heatmap library can use used with sqlpage ? ]

[lovasoa]

Hello, and welcome to SQLPage !

This is a very specific feature, which was not on my personal roadmap but why not ! If you are ready to fund the development of this feature, feel free to drop me a line on [email protected].

[f8dca]

This is actually a very useful component that I could also use.

[lovasoa]

What I'm currently envisioning is a more traditional calendar component. You could emulate a heatmap by filling it with one event every day, but the main feature would be showing events on a calendar.

For time series visualization, the main component would remain the chart component.

[lovasoa]

I just added an example to the documentation for heatmaps, that can be used to build calendar heatmaps.

select 
    'chart'                     as component,
    'Survey Results'            as title,
    'heatmap'                   as type,
    'Database managemet system' as ytitle,
    'Year'                      as xtitle,
    'blue'                      as color,
    'blue'                      as color,
    'blue'                      as color;
select 
    'PostgreSQL' as series,
    '2000'       as x,
    48           as y;
select 
    'SQLite' as series,
    '2000'   as x,
    14       as y;
select 
    'MySQL' as series,
    '2000'  as x,
    78      as y;
select 
    'PostgreSQL' as series,
    '2010'       as x,
    65           as y;
select 
    'SQLite' as series,
    '2010'   as x,
    22       as y;
select 
    'MySQL' as series,
    '2010'  as x,
    83      as y;
select 
    'PostgreSQL' as series,
    '2020'       as x,
    73           as y;
select 
    'SQLite' as series,
    '2020'   as x,
    28       as y;
select 
    'MySQL' as series,
    '2020'  as x,
    87      as y;

[accforgithubtest]

Thank you ! This looks great and Will give this a try next weekends.

Quick question about this part

 'blue'                      as color,
    'blue'                      as color,
    'blue'                      as color;

Is this optional ? Is this for each "column" ? Or Row ? If the number of rows and columns are dynamically generated, how would this work ?

I had a look at the docs for apexcharts heatmaps and found a interesting configuration reverseNegativeShade

reverseNegativeShade: true

Can this config be passed in the select statement that also specifies ?

'heatmap'                   as type,

[lovasoa]

Hi !

'blue' as color, 'blue' as color, 'blue' as color Is it optional ?

Yes, by default, each series has a different color. But understanding heatmaps is easier when everything has the same color. In your calendar heatmap, you could use that to display weekends in a different color, for instance.

Is this for each "column" ? Or Row ?

For each row (each series).

If the number of rows and columns are dynamically generated, how would this work ?

You could use the json form: (select json_group_array('blue') from my_series) as color

I had a look at the docs for apexcharts heatmaps and found a interesting configuration reverseNegativeShade

No, unfortunately, it's currently not possible.

[accforgithubtest]

ok, thanks, will give this a go !

[accforgithubtest]

I gave the heatmaps a go, with below test data, and here are my initial observations.

I totally understand this component is new, I am hoping to help you with testing this component. Any suggestions you might have to tweak the input data to make it easier to work with is appreciated.

1. Some issues with chart background in dark theme - see screenshot for data-sample-1.

2. How can I get the chart to display an "empty" cell on the charts ? Passing 0, false or null still keeps the color in a cell. In case of boolean values, it will be useful to indicate a "true" or "false" for a given cell if the cell basically becomes "transparent".

3. When using x-axis as time, it looks like each series is starting after the previous one finishes, instead of aligning them by timestamp. The x-axis displays the time correctly, however the data displayed in the graph doesn't actually line up with the time on x axis. Use data-sample-1 to see this issue between the timestamp of the data and the value on the graph.

4. There seems to be difference in behavior on how the chart displayed, not sure what is causing this, other than some changes in the y values to create another set of test data. Other than this difference in y values, what else could be causing the difference in behavior. Compare the data-sample-1 and data-sample-2 along with their corresponding screenshots to see this issue.

5. reverseNegativeShade would be a very useful feature that might provide benefits directly from apexcharts, would you pls consider making this available to be passed to the chart.

screenshot for data-sample-1

screenshot for data-sample-2

data-sample-1

select 
    'chart' as component,
    'HeatMaps' as title,
    'heatmap' as type,
	true as time;

select "2024-01-05 19:00" as x, "group_a" as series, "0" as y;
select "2024-01-05 19:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 19:00" as x, "group_c" as series, "0" as y;
select "2024-01-05 19:00" as x, "group_d" as series, "0" as y;
select "2024-01-05 19:00" as x, "group_e" as series, "0" as y;
select "2024-01-05 20:00" as x, "group_a" as series, "0" as y;
select "2024-01-05 20:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 20:00" as x, "group_c" as series, "50" as y;
select "2024-01-05 20:00" as x, "group_d" as series, "0" as y;
select "2024-01-05 20:00" as x, "group_e" as series, "0" as y;
select "2024-01-05 21:00" as x, "group_a" as series, "0" as y;
select "2024-01-05 21:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 21:00" as x, "group_c" as series, "50" as y;
select "2024-01-05 21:00" as x, "group_d" as series, "0" as y;
select "2024-01-05 21:00" as x, "group_e" as series, "100" as y;
select "2024-01-05 21:00" as x, "group_e" as series, "0" as y;
select "2024-01-05 22:00" as x, "group_a" as series, "0" as y;
select "2024-01-05 22:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 22:00" as x, "group_c" as series, "0" as y;
select "2024-01-05 22:00" as x, "group_d" as series, "0" as y;
select "2024-01-05 22:00" as x, "group_e" as series, "0" as y;
select "2024-01-05 23:00" as x, "group_a" as series, "0" as y;
select "2024-01-05 23:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 23:00" as x, "group_c" as series, "0" as y;
select "2024-01-05 23:00" as x, "group_d" as series, "0" as y;
select "2024-01-05 23:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 00:00" as x, "group_a" as series, "0" as y;
select "2024-01-06 00:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 00:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 00:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 00:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 01:00" as x, "group_a" as series, "0" as y;
select "2024-01-06 01:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 01:00" as x, "group_c" as series, "0" as y;
select "2024-01-06 01:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 01:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 01:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 02:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 02:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 03:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 03:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 03:00" as x, "group_c" as series, "0" as y;
select "2024-01-06 03:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 03:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 04:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 04:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 04:00" as x, "group_c" as series, "0" as y;
select "2024-01-06 04:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 04:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 05:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 05:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 05:00" as x, "group_c" as series, "0" as y;
select "2024-01-06 05:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 05:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 06:00" as x, "group_a" as series, "0" as y;
select "2024-01-06 06:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 06:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 06:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 06:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 07:00" as x, "group_a" as series, "0" as y;
select "2024-01-06 07:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 07:00" as x, "group_c" as series, "0" as y;
select "2024-01-06 07:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 07:00" as x, "group_e" as series, "0" as y;

data-sample-2

select 
    'chart' as component,
    'HeatMaps' as title,
    'heatmap' as type,
	true as time;

select "2024-01-05 19:00" as x, "group_a" as series, null as y;
select "2024-01-05 19:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 19:00" as x, "group_c" as series, null as y;
select "2024-01-05 19:00" as x, "group_d" as series, null as y;
select "2024-01-05 19:00" as x, "group_e" as series, null as y;
select "2024-01-05 20:00" as x, "group_a" as series, null as y;
select "2024-01-05 20:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 20:00" as x, "group_c" as series, "50" as y;
select "2024-01-05 20:00" as x, "group_d" as series, "-10" as y;
select "2024-01-05 20:00" as x, "group_e" as series, null as y;
select "2024-01-05 21:00" as x, "group_a" as series, null as y;
select "2024-01-05 21:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 21:00" as x, "group_c" as series, "50" as y;
select "2024-01-05 21:00" as x, "group_d" as series, null as y;
select "2024-01-05 21:00" as x, "group_e" as series, "100" as y;
select "2024-01-05 21:00" as x, "group_e" as series, null as y;
select "2024-01-05 22:00" as x, "group_a" as series, null as y;
select "2024-01-05 22:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 22:00" as x, "group_c" as series, null as y;
select "2024-01-05 22:00" as x, "group_d" as series, "-50" as y;
select "2024-01-05 22:00" as x, "group_e" as series, null as y;
select "2024-01-05 23:00" as x, "group_a" as series, null as y;
select "2024-01-05 23:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 23:00" as x, "group_c" as series, null as y;
select "2024-01-05 23:00" as x, "group_d" as series, null as y;
select "2024-01-05 23:00" as x, "group_e" as series, null as y;
select "2024-01-06 00:00" as x, "group_a" as series, null as y;
select "2024-01-06 00:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 00:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 00:00" as x, "group_d" as series, null as y;
select "2024-01-06 00:00" as x, "group_e" as series, null as y;
select "2024-01-06 01:00" as x, "group_a" as series, null as y;
select "2024-01-06 01:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 01:00" as x, "group_c" as series, null as y;
select "2024-01-06 01:00" as x, "group_d" as series, "-30" as y;
select "2024-01-06 01:00" as x, "group_e" as series, null as y;
select "2024-01-06 01:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 02:00" as x, "group_d" as series, null as y;
select "2024-01-06 02:00" as x, "group_e" as series, null as y;
select "2024-01-06 03:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 03:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 03:00" as x, "group_c" as series, null as y;
select "2024-01-06 03:00" as x, "group_d" as series, "-10" as y;
select "2024-01-06 03:00" as x, "group_e" as series, null as y;
select "2024-01-06 04:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 04:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 04:00" as x, "group_c" as series, null as y;
select "2024-01-06 04:00" as x, "group_d" as series, "-1" as y;
select "2024-01-06 04:00" as x, "group_e" as series, null as y;
select "2024-01-06 05:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 05:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 05:00" as x, "group_c" as series, null as y;
select "2024-01-06 05:00" as x, "group_d" as series, null as y;
select "2024-01-06 05:00" as x, "group_e" as series, null as y;
select "2024-01-06 06:00" as x, "group_a" as series, null as y;
select "2024-01-06 06:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 06:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 06:00" as x, "group_d" as series, null as y;
select "2024-01-06 06:00" as x, "group_e" as series, null as y;
select "2024-01-06 07:00" as x, "group_a" as series, null as y;
select "2024-01-06 07:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 07:00" as x, "group_c" as series, null as y;
select "2024-01-06 07:00" as x, "group_d" as series, null as y;
select "2024-01-06 07:00" as x, "group_e" as series, null as y;

[accforgithubtest]

The appearance of the heatmap has changed in v0.18.2, for the same test data above. Though appearance has changed, the issues / notes from above are still the same -

[lovasoa]

Hi !

There hasn't been any explicit change to stacked bar charts inside SQLPage itself in v18 (outside of the default color scheme change), but the charting library that powers the charts (ApexCharts) has been updated from v3.44.0 to v3.45.1 (see changes).

And indeed, the handling of data splits in heatmaps with a time axis has changed. But the new behavior is the correct one, isn't it ? The data contains one point per hour, and that is what the graph displays. The old behavior was to add multiple subdivisions in each hour, that are not present in the data.

[accforgithubtest]

Hi and thanks for the reply. Yes agreed that new behaviour for data splits is better than before and it is correct !

I think below items needs addressing for heatmaps in sqlpage (though I am not sure if these are things that can be changed with sqlpage, or if they are underlying issues in apex charts) -

1. There seems to be difference in behavior on how the chart displayed, not sure what is causing this, other than some changes in the y values to create another set of test data. Other than this difference in y values, what else could be causing the difference in behavior. Compare the data-sample-1 and data-sample-2 along with their corresponding screenshots to see this issue.

2. How can I get the chart to display an "empty" cell on the charts ? Passing 0, false or null still keeps the color in a cell. In case of boolean values, it will be useful to indicate a "true" or "false" for a given cell if the cell basically becomes "transparent".

3. reverseNegativeShade would be a very useful feature that might provide benefits directly from apexcharts, would you pls consider making this available to be passed to the chart.

4. Issues with chart background in dark theme - see screenshot for data-sample-1. It should be dark colored instead of light ?

5. The intensity of the colors (lightness/darkness) in each cell doesnt seem to move much making it hard to see the difference between 0 and 100 vs 50 and 100 ,etc. It would be nice if the change in color is higher / distinguishable.

Screenshots :

Data:

select 'shell' as component,
	'dark' as theme,
	'Test Page' as title,
	'#' as link,
	'en-AU' as language;

select 
    'chart' as component,
    'data-sample-1' as title,
    'heatmap' as type,
	true as time;

select "2024-01-05 19:00" as x, "group_a" as series, "0" as y;
select "2024-01-05 19:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 19:00" as x, "group_c" as series, "0" as y;
select "2024-01-05 19:00" as x, "group_d" as series, "0" as y;
select "2024-01-05 19:00" as x, "group_e" as series, "0" as y;
select "2024-01-05 20:00" as x, "group_a" as series, "0" as y;
select "2024-01-05 20:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 20:00" as x, "group_c" as series, "50" as y;
select "2024-01-05 20:00" as x, "group_d" as series, "0" as y;
select "2024-01-05 20:00" as x, "group_e" as series, "0" as y;
select "2024-01-05 21:00" as x, "group_a" as series, "0" as y;
select "2024-01-05 21:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 21:00" as x, "group_c" as series, "50" as y;
select "2024-01-05 21:00" as x, "group_d" as series, "0" as y;
select "2024-01-05 21:00" as x, "group_e" as series, "100" as y;
select "2024-01-05 21:00" as x, "group_e" as series, "0" as y;
select "2024-01-05 22:00" as x, "group_a" as series, "0" as y;
select "2024-01-05 22:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 22:00" as x, "group_c" as series, "0" as y;
select "2024-01-05 22:00" as x, "group_d" as series, "0" as y;
select "2024-01-05 22:00" as x, "group_e" as series, "0" as y;
select "2024-01-05 23:00" as x, "group_a" as series, "0" as y;
select "2024-01-05 23:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 23:00" as x, "group_c" as series, "0" as y;
select "2024-01-05 23:00" as x, "group_d" as series, "0" as y;
select "2024-01-05 23:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 00:00" as x, "group_a" as series, "0" as y;
select "2024-01-06 00:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 00:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 00:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 00:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 01:00" as x, "group_a" as series, "0" as y;
select "2024-01-06 01:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 01:00" as x, "group_c" as series, "0" as y;
select "2024-01-06 01:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 01:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 01:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 02:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 02:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 03:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 03:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 03:00" as x, "group_c" as series, "0" as y;
select "2024-01-06 03:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 03:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 04:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 04:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 04:00" as x, "group_c" as series, "0" as y;
select "2024-01-06 04:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 04:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 05:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 05:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 05:00" as x, "group_c" as series, "0" as y;
select "2024-01-06 05:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 05:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 06:00" as x, "group_a" as series, "0" as y;
select "2024-01-06 06:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 06:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 06:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 06:00" as x, "group_e" as series, "0" as y;
select "2024-01-06 07:00" as x, "group_a" as series, "0" as y;
select "2024-01-06 07:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 07:00" as x, "group_c" as series, "0" as y;
select "2024-01-06 07:00" as x, "group_d" as series, "0" as y;
select "2024-01-06 07:00" as x, "group_e" as series, "0" as y;


select 
    'chart' as component,
    'data-sample-2' as title,
    'heatmap' as type,
	true as time;

select "2024-01-05 19:00" as x, "group_a" as series, null as y;
select "2024-01-05 19:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 19:00" as x, "group_c" as series, null as y;
select "2024-01-05 19:00" as x, "group_d" as series, null as y;
select "2024-01-05 19:00" as x, "group_e" as series, null as y;
select "2024-01-05 20:00" as x, "group_a" as series, null as y;
select "2024-01-05 20:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 20:00" as x, "group_c" as series, "50" as y;
select "2024-01-05 20:00" as x, "group_d" as series, "-10" as y;
select "2024-01-05 20:00" as x, "group_e" as series, null as y;
select "2024-01-05 21:00" as x, "group_a" as series, null as y;
select "2024-01-05 21:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 21:00" as x, "group_c" as series, "50" as y;
select "2024-01-05 21:00" as x, "group_d" as series, null as y;
select "2024-01-05 21:00" as x, "group_e" as series, "100" as y;
select "2024-01-05 21:00" as x, "group_e" as series, null as y;
select "2024-01-05 22:00" as x, "group_a" as series, null as y;
select "2024-01-05 22:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 22:00" as x, "group_c" as series, null as y;
select "2024-01-05 22:00" as x, "group_d" as series, "-50" as y;
select "2024-01-05 22:00" as x, "group_e" as series, null as y;
select "2024-01-05 23:00" as x, "group_a" as series, null as y;
select "2024-01-05 23:00" as x, "group_b" as series, "100" as y;
select "2024-01-05 23:00" as x, "group_c" as series, null as y;
select "2024-01-05 23:00" as x, "group_d" as series, null as y;
select "2024-01-05 23:00" as x, "group_e" as series, null as y;
select "2024-01-06 00:00" as x, "group_a" as series, null as y;
select "2024-01-06 00:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 00:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 00:00" as x, "group_d" as series, null as y;
select "2024-01-06 00:00" as x, "group_e" as series, null as y;
select "2024-01-06 01:00" as x, "group_a" as series, null as y;
select "2024-01-06 01:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 01:00" as x, "group_c" as series, null as y;
select "2024-01-06 01:00" as x, "group_d" as series, "-30" as y;
select "2024-01-06 01:00" as x, "group_e" as series, null as y;
select "2024-01-06 01:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 02:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 02:00" as x, "group_d" as series, null as y;
select "2024-01-06 02:00" as x, "group_e" as series, null as y;
select "2024-01-06 03:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 03:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 03:00" as x, "group_c" as series, null as y;
select "2024-01-06 03:00" as x, "group_d" as series, "-10" as y;
select "2024-01-06 03:00" as x, "group_e" as series, null as y;
select "2024-01-06 04:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 04:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 04:00" as x, "group_c" as series, null as y;
select "2024-01-06 04:00" as x, "group_d" as series, "-1" as y;
select "2024-01-06 04:00" as x, "group_e" as series, null as y;
select "2024-01-06 05:00" as x, "group_a" as series, "100" as y;
select "2024-01-06 05:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 05:00" as x, "group_c" as series, null as y;
select "2024-01-06 05:00" as x, "group_d" as series, null as y;
select "2024-01-06 05:00" as x, "group_e" as series, null as y;
select "2024-01-06 06:00" as x, "group_a" as series, null as y;
select "2024-01-06 06:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 06:00" as x, "group_c" as series, "50" as y;
select "2024-01-06 06:00" as x, "group_d" as series, null as y;
select "2024-01-06 06:00" as x, "group_e" as series, null as y;
select "2024-01-06 07:00" as x, "group_a" as series, null as y;
select "2024-01-06 07:00" as x, "group_b" as series, "100" as y;
select "2024-01-06 07:00" as x, "group_c" as series, null as y;
select "2024-01-06 07:00" as x, "group_d" as series, null as y;
select "2024-01-06 07:00" as x, "group_e" as series, null as y;

[accforgithubtest]

Another quick question @lovasoa - true as logarithmic doesnt seem to work in heatmaps. I was assuming since there is a y value which plots the color of the cell in heatmap logarithmic would work, but it doesnt seem to. Would you be able to comment if it is supposed to work ?