Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
StayHome
Contributor
Contributor

Problems with heatmap chart

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 1category 2category 3
category 1123
category2031
category 3204

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!

0 Replies