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:
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.
