I am trying to use Cohort Visualization feature. So, I wrote a query that returns 4 fields as Date, Days_Number, Value and Total(total users in the group). The query works and returns the expected values. But, the date field continues to return as a timestamp, even though I have tried all the format conversion functions. Moreover, when I copy and paste the original query into BigQuery, the Date field is displayed in date format, not timestamp.
Then I tried to get the start date from the other joined table. This time the Date field returned in date format, but the visualization module did not return any results again.
When I want to use the module, only an empty current date row is displayed, no data is reflected here.
I attached a screenshot from the result. Would you help me about this issue?