jvanis Member

Thank you @ColemenWilson, but could you expand on the MagicETL method? I've been trying to use the Rank & Window with the previous date (lag), but not able to get to the grouping I'm hoping for. I need to somehow carry a constant down the rows until it sees that the datediff is >1, then a new constant until >1, etc.

This would be nice for exporting reports/dashboards as well, if you would be able to export a table/dashboard, and the table cards would grow, or have a "Max pages to export: " option so excel wouldn't be the only option to export tables to.

Thanks @MarkSnodgrass , even though I don't like your answer :), I appreciate the quick response. Idea submitted!!