Problems with heatmap chart

StayHome — Sat, 16 Nov 2024 18:31:10 GMT

Hi! I need help I'm trying to make a heatmap chart, and it's not working well.

I have data with orders, date of order, and products, this products have a category, well I want a heatmap chart like this:

	category 1	category 2	category 3
category 1	1	2	3
category2	0	3	1
category 3	2	0	4

and in this case for example the bold entry means that in the last 14 days, two orders had the category 1 and category 2 at the time. I was using something like this:

count({$<dateOrden={">=$(=max(date(today()-14)))"}, valid={'1'}> }distinct id_order)

valid means the order was confirmed, and it's necessary. The problem is that I only have results for wich the value in columns and rows match, that is I only have values in the diagonal.

Can yo help me! please!

topic Problems with heatmap chart in App Development

Problems with heatmap chart