GrantSmith Coach 
-
Re: Aggregate counts over time that keep a running total
Yeah, it should be a date field to return the proper year. If Org Creation is already the year then you can just remove the YEAR() function in the beast mode1 -
Re: Can I get the MIN date over a partition with a formula tile?
Have you looked into using a Rank & Window til in your Magic ETL to get the minimum date across your column partition?1 -
Re: I am using this beast mode but it wont let me save the card
You need to aggregate the aggregate when using a window function in a beast mode because of how Domo processes the beast mode. You could do something like: COUNT(MAX(`ID`)) OVER (PARTITION BY `Clinic…1 -
Re: Caculate percentage in same month when using two date columns in same data table
You should restructure your data so that it's stacked so you have one row per observation (sales or service) Unit ID | Date | Date Type 1 | 1-Jan | Sales 2 | 2-Jan | Sales 2 | 2-Feb | Service Th…2 -
Re: Managing Data Retention Policy
You could utilize Magic ETL dataflows to check the date on the data and either split it out and archive it or remove it from the dataset depending on your company's data retention policy.1
