Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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:   i...
Need Help
Show and Tell
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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.

     

     

     

     

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

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.