Realtime Dataset - how to format date field

Hi Everyone, hope you're staying safe. 

I have a question on how to format a realtime dataset with a date field. I'm using a realtime dataset and I have a Timestamp column which contains timestamps for the different data points. I want to be able to visualise this on a bar chart or a line graph with the date as the x-axis. Instead of the actual time being shown on the x-axis, i want to summarise the datapoints by day. 

i.e. on the x-axis, i want to see 17 Sept, 18 Sept, etc instead of 1.00pm, 2.00pm, 3.00pm, etc. Then Y axis i want to see the values pertaining to each day. I can only see the date if i hover of the data points. 

Because I can't create calculated columns and i can't manipulate the column like i usually would with normal datasets, i'm not sure on how to format. 

Is anyone able to help? any assistance would be appreciated. Thanks so much in advance.