Forum Discussion
Filtering dates in visual that is based on time.
Hello,
I have a following datasheet.
| Date | 6:05 | 6:45 | 7:10 | 8:00 | 8:35 | 9:15 | 9:50 | 10:25 | 11:00 |
| 1.1.2022 | |||||||||
| 2.1.2022 | |||||||||
| 3.1.2022 | 3 | 2 | 3 | 6 | 5 | 7 | 7 | 5 | 8 |
| 4.1.2022 | 4 | 3 | 5 | 5 | 4 | 7 | 7 | 8 | 9 |
| 5.1.2022 | 3 | 2 | 4 | 7 | 5 | 6 | 6 | 9,5 | 6 |
| 6.1.2022 | 9 | 3 | 9 | ||||||
| 7.1.2022 | 4 | 3 | 1 | 7 | 5 | 8 | 8 | 4 | 8 |
| 8.1.2022 | 9 | 9,5 | 9,5 | ||||||
| 9.1.2022 | 7 | 4 | 8 |
(The dates and times go further.)
I transposed the data to create a visual using the specific times as a x-axis. After calculating averages and "usage" it looks like this based on the times.
I would like to know if there is a possibility filter that data with my dates. The dates in this configuration are now headers so my timetable can't understand them. I know I am missing something big. Any answer or guidance to a different way to configurate the data would be highly appreciated.
The data which I used to create the visual looks like this:
So basically I just transposed the table. I think that there is a more simple way to create the visual without transposing so that I can use datetable as a slicer without problems. Thanks for any help.
Did you try unpivot option ?
JoosePekkarinen
Once unpivoted, you can use both columns (Date & Time) for slicing and dicing
6 Replies
Did you try unpivot option ?
Hi, I have two tables of the same data. One is transposed and one is in its original format (The first datasheet in original post). With original data, I can create visuals that are based on dates but I want to spefically use the times as x-axis and as a base for the visual. Thank you!
JoosePekkarinen
Once unpivoted, you can use both columns (Date & Time) for slicing and dicing
Thank you!
JoosePekkarinen
No other option than to unpivot your data
