Hi forum,
We have a huge table with clicks within a performance support system. This table has the followig date info for each click:
- Date UTC
- Date
- Year
- YearMonth
| Publication | Date (UTC) | Date | Year | YearMonth |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 07:28:04+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 07:31:42+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:10:22+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:10:25+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:10:27+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:10:30+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:10:31+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:10:34+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:10:38+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:10:43+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:10:53+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:10:57+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:31:48+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:31:50+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:31:53+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:31:55+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:31:57+00:00 | 02.11.2020 | 2020 | 2020-11 |
| 4a2eea50-a958-4c52-99e5-09bdfa8d7a5b | 2020-11-02 09:32:01+00:00 | 02.11.2020 | 2020 | 2020-11 |
(These are only entries for Nov. 2nd, 2020. The list is way way longer.)
We now want to know which are the most poluar days and times a user user the performance support system.
I though about using a Dax formular to extract the week day out of the date (Mon - Sun). This would give me day. I guess I can also get the time out of the column Date (UTC).
However, has someone an idea how I could then show the most popular days & times? Should I use some kind of heat map?
Maybe some one did do this before.
Thank you very much in advance for your constant help and kind regards from Germany,
Mathias
