Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Group date time data by date

Hi, I'd like to ask if I have datetime data, can I visualise the data by date on the fly without creating another date column? 

 

For example, data looks like this, with timestamp:

 

           id   timestamp               data  group 
27001   27242   2020-01-01 09:07:21.277 19.5    1   
27002   27243   2020-01-01 09:07:21.377 19.0    1   
27581   27822   2020-01-02 07:53:05.173 19.5    1   
27582   27823   2020-01-02 07:53:05.273 20.0    1   
27647   27888   2020-01-02 10:01:46.380 20.5    1   

Can I visualise "data" by date? 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @Anonymous 

Please correct me if I wrongly understand your question.

Without creating another date-table, or another time-table, or another date-column, and when you drag the timestamp column into the visualization, for instance like the below picture, it will automatically create date hierarchy Axis (Year -> Q -> M -> D), but not to the hour -> minute -> second level.

So, in my opinion, the answer is yes.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

 

Picture5.png

 

 

 

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi, @Anonymous 

Please correct me if I wrongly understand your question.

Without creating another date-table, or another time-table, or another date-column, and when you drag the timestamp column into the visualization, for instance like the below picture, it will automatically create date hierarchy Axis (Year -> Q -> M -> D), but not to the hour -> minute -> second level.

So, in my opinion, the answer is yes.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

 

Picture5.png

 

 

 

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.