user095459 Member

We are unfortunately limited through through a third-party Domo license, which hosts federated data externally, so we don’t get all of the nice data ETL functionality. I’m limited to Beast Mode for data manipulations. I wondered if maybe there’s something I hadn’t considered, but it seems like we would need to build a…

I imagine there is a way to do this, perhaps better than I'm initially imagining, so I welcome any suggestions.

I am checking into the possibility of enabling the windows function, but the beast mode seems better, since we want the distinct count of customer ID's over these different time periods. From your video, I see you build a table that you join. Our Domo instance unfortunately is only a front-end with federated external data,…

Thank you for the quick reply! So for the date dimension, is that based on the beast mode case statement you recommended? Also, it would be ideal if this could be dynamic with variables, so you don't have to hard code months. You mention "Rpt_Date", which I presume is placeholders for hard-coded value for the month in…