Forum Discussion
JoosePekkarinen
4 years agoFrequent Visitor
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...
- 4 years ago
Did you try unpivot option ?
- 4 years ago
JoosePekkarinen
Once unpivoted, you can use both columns (Date & Time) for slicing and dicing
mh2587
4 years agoSuper User
Did you try unpivot option ?
- JoosePekkarinen4 years agoFrequent Visitor
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!
- tamerj14 years agoCommunity Champion
JoosePekkarinen
Once unpivoted, you can use both columns (Date & Time) for slicing and dicing- JoosePekkarinen4 years agoFrequent Visitor
Thanks! I got it now.
- JoosePekkarinen4 years agoFrequent Visitor
Thank you!