-
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: Calculating Percent of Total, and Getting Correct Totals
@pstrauss It's because the total is calculated based on the overall distinct count, but the rows are the distinct count within the group. Take this example dataset. To do this with a distinct count, …2 -
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: May 2024 Domo Release
Thanks @BenSchein! This is perfect because I was on a work call when it popped up and accidentally closed it out. Thanks for sharing!1