I am new to Looker Studio....very new. With that out of the way, here is my situation.
I have downloaded real estate sales data with one column for the sales date. The sales date for the first three rows appear as '36161, 36162, 36164' and so forth for the remaining rows. This is the data that I originally uploaded. However, the Time Series chart would not work and I could not format the date using a Parse_Date.
So, I changed the format for the column to a date format. The sales date for the first three rows appear as ' 1999-01-01, 1999-01-02, 1999-01-04.' I tried to Reconnect the data without success. I removed the old file and add the new saved file with the changed date format. However, when I go to Data Preview in the Edit section under Manage Added Data Sources, the date is still '36161, 36162, 36164.'
This is the second data file that I have tried to use to get a Time Series chart to count the number of sales each month in the past. I was able to get the Time Series chart to show the Record Count for each day of sales in the past but that did not look helpful at all.
Would you have any suggestions on how to get the Time Series chart to show the data in a manner that I would like.
This is my first post. I have been trying to figure this out over the last 4 days and figured I'd try here. Thank you.
LinkedIn
Twitter
