Hi all,
I have an question about an visual that I'm trying to create. I have two different tables that are connected with the date field. The first table is a simple calander table with just the regular items in it. The most important items for this visual are the items below.
| Day |
| Monday |
| Tuesday |
| Wednesday |
| Thursday |
| Friday |
| Saturday |
| Sunday |
The second table is also not that difficult and looks like this. I have shortend this table a little bit because otherwise it will be to long for this post. The table contains for each hour each day a number.
| Date | Number | Time |
| 29/07/2020 | 23 | 10:00 AM |
| 29/07/2020 | 53 | 11:00 AM |
| 29/07/2020 | 213 | 12:00 PM |
| 29/07/2020 | 754 | 01:00 PM |
| 29/07/2020 | 23 | 02:00 PM |
| 29/07/2020 | 657 | 03:00 PM |
With these two tables I can create a heatmap visual where I can display each day of the week (mon, tue, wed...) with the hours and the count of each hour. It will look something like this.
| Day | 10:00 AM | 11:00 AM | 12:00 PM |
| Mon | 123 | 432 | 124 |
| Tue | 435 | 1235 | 664 |
| Wed | 752 | 213 | 342 |
I have colorised each number field based on the percentage of the amount. So the field will be green when the amount is below 33%, orange if it is between 33% and 67% and red when above 67%. I hope you can still understand my story..
But now comes the tricky part, I want to set some specific field on another color (for example black). This is not correlation to the amount of the number field but based on the day and time. But because these are two seperate tables and I already put an color filter based on the number field I do not know how to set a color filter based on that specific measure.
I hope that I'm clear enough and you can understand me. I'm sorry for my bad english and maybe some typeerrors. If you have questions please ask!
