Help with data and time formatting

[whosleonardo]

Hi everyone! I have a spreadsheet with statistics for Instagram posts. The columns are: 1) the time and date of the post; 2) the number of likes. In this case, I post from Monday to Friday, at 12pm or 6pm. What I wanted to do in Looker was to track the average monthly likes performance for each of these posting times (Monday 12, Monday 6pm, Tuesday 12, Tuesday 6pm, etc.). However, I'm not able to get Looker to recognize the time of the post. I did a test with a test column of only days and it managed to group them by the days of the week, but when I change it to the date and time column, even formatting it ("EEEE, HH"), it divides the days into several days and shows a generic time (they all have 6pm). Can someone help me? Should I separate times and dates into separate columns? If so, how would I do it in this case? I hope you can understand me, thanks!

[sam8]

I think the first step here would be to make sure Looker Studio is seeing this field as a datetime field. Check the type of the field and change it to a date and time there. Once you've done that, does the default formatting include the times correctly? Once you have that working, then we can start to work on formatting.