another question to make it even more difficult 😂
Is there a possibility to change the background colour of a field when the average value is 0-50: red, 50-75: orange and 75+ : green?
or maybe above total average green and below total average red?
☺️☺️
I have an existing database (with around 10.000 records and growing) with a timestamp and a value. From this database i want to make a dynamic heatmap with the average value per our of the day.
I've uploaded a file. In Table "Content" i have the data. In Table "Heatmap" I want the average of the field "Value" of the related records.
Thanks!
Naamloos.fmp12
I would like to create a heat map with data from a related table.
In table 1 different records with a field with a value. A field with hour of the day. A field with day of the week.
In another table I would like (in 1 global record) an overview with times per day with a field containing the average value of that hour of the day of the week.
What is the best way to do this? Thanks