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!