/datastudio/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
-
How do you view a time chart by hour/minute/second? 1 Recommended Answer 6 Replies 26 Upvotes
1 Recommended Answer
$0 Recommended Answers
1 Relevant Answer
$0 Relevant Answers
How do you view record counts over small time intervals, down to the seconds?

I'm looking at the 'TIme Series Chart' (and others) and I can only get the X-axis to be on an interval of days. I've tried setting the 'Date Range Dimension' to something like 'HOUR(timestamp)' but the display doesn't change. Attached is a picture of the graph.

Thanks!
Most Relevant Answer Most Relevant Answers (0)
All Replies (6)
Most Relevant Answer
That's useful, but I still don't see how to get it with Seconds
marked this as an answer
Most relevant based on info available
Most Relevant Answer
Hey User 3238252520494650299

Added a new page to the report as well as a GIF demonstrating the process below.

One way is to use a line chart with Date as a TEXT field:
Step 1: At the Data Source, Duplicate the Date field
Step 2: Change the field type to TEXT
Step 3: Create a Line Chart and use the TEXT date field as the primary dimension
Step 4: Sort the Chart by the Date field, in Ascending order


Hope this helps

marked this as an answer
Most relevant based on info available
Most Relevant Answer
Hi Nimantha
I just follow the steps in the first instruction GIF, but I cannot replicate the result.
It still shows that something went wrong.

The type of column in Bigquery is "TIMESTAMP", is it the problem?
marked this as an answer
Most relevant based on info available
Most Relevant Answer
Thanks! Hard to find a good answer to this one. Thank you for sharing!
marked this as an answer
Most relevant based on info available
Most Relevant Answer
Thanks Ivan Maldonado :)

Glad it helped.


Hope to see you around the forum
marked this as an answer
Most relevant based on info available
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
What type of post are you reporting?
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/datastudio/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Marked as Recommended Answer
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
/datastudio/profile/0?hl=en