Problems with Redash 2.0 and Cohort Visualization


Hi all, I’m having fits with Cohort visualization. I’m creating a new thread because we are on ReDash 2.0 and still having issues with this Viz. We are running against Big Query. Hopefully those who have figured this out can help, I have read the earlier threads.

2 issues:

  1. Dates are not correctly grouping month/year (in monthly) in the time column. The month/year also go way out in the future years.
  2. I’m calculating difference in months (still calling it days) and I only get 5 columns across the top and would expect up to 15).

I’m attaching a snippet of the data table, my SQL, and the viz output.