david_cunningham Coach 
-
Re: How can I auto send an entire dataset each week?
You can attach a dataset to a scheduled report as an excel/csv file2 -
Re: How can i subtract current values from previous week values?
Assuming your data will always be grouped by week, you could use a lag function. You would use a Rank & Window tile to achieve this in ETL. One thing to keep in mind, is that lag will always go t…1 -
Re: Using beast mode to compare strings
@Mark Puddephatt - just to second what @Sean_Tully is saying, it's part of my standard practice to wrap text strings in UPPER() before comparing. It just helps to minimize any chance of variability. …2 -
Re: Flexible SUM Aggregates With Duplicate Values in Dataset
@jmmc you can do this with SUM(DISTINCT ()) SUM(DISTINCT Price) FIXED (BY Product ID) Yields the following results. You can see that the column fixed1 only includes the total once per id.2 -
Re: Starting Day of the Week - Monday
If this is going to be a consistent, recurring use-case. I.e. you’re going to want other cards to replicate the same behavior. I’d recommend using the fiscal calendar option in Domo. When setting it …2
