david_cunningham Coach

@chapman - I don't think this is how it was done in the KB article, but here is an example of how you could achieve the same outcome. Note, this doesn't make use of a fixed function. If we create a beast mode "city_state_rank". rank() over (partition by state order by SUM(amount) desc) We can then filter to where rank = 1…

@user09845 You could filter the column to exclude "In Scope" for all except for Training 1. case when Order Status != 'Completed' and Lead Source = 'Sales' then 'Exclude' else 'Include' end For example above you can see we have "Marketing","Organic", and "Sales" listed for both "Completed" and "In Progress". Once we filter…

If I had to venture a guess, they are most likely using referencing another column (City) in the dataset and using that in a tooltip field that they are then referencing in the data label settings.

Do you have a company time zone set? Domo assumes that all data imported is in UTC, and then will display it based on the company time zone setting. To set the company time zone, you must be an Admin or have a custom role with the following grant enabled: (Admin-level) Manage All Company Settings — This grant permits the…

You can attach a dataset to a scheduled report as an excel/csv file

@swapnilparab0202 You could create a beast mode that will pull the data for the most recent working day. On Monday you would want to go back 2 days to Saturday, and then every other day you would want to go back 1 day to the previous working day. case when date = ( CASE WHEN DAYOFWEEK(CURRENT_DATE())=2 then…

@Lu_zhang There are 2 types of timezone settings in Domo. Anyone can define their personal time zone in Domo to determine when they receive alerts, notifications, and scheduled reports. Admin-level users can define a company time zone for the entire instance to standardize how visualizations display. If there is a company…

@pstrauss when you say that it returns zero values, do you mean that the table isn't showing any rows? Or that the values are 0 for each row? Please include a screenshot of what you're seeing so that I can help troubleshoot. Also, I noticed that your case statement changed. In your initial post, all of your column names…

@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, you would use the following beast mode SUM(COUNT(DISTINCT id)) over (partition by group) You can see that this results in a…

@BMilner the difference between COALESCE and IFNULL is below for your reference. COALESCE: Returns the first non-NULL value in the list of columns, or NULL if there are no non-NULL values. IFNULL: If expr1 is not NULL, IFNULL() returns expr1; otherwise it returns expr2. You can nest multiple IFNULLs, but usually using…

In order to achieve this you would need to have those rows available in your dataset. What I mean by this is | month1: 100, month2: 0, month3: 75 Rather than | month1: 100, month3: 75 You'll want to use a date dimension table and joining up in your ETL.

My first inclination would be to leverage the API. This wouldn't be perfect, but you could have a script that would run daily, iterate through all pages, and check if a particular card id resides on each page. If not, you could copy that card onto that page. This solution wouldn't automatically add the card at page…

Completely agree @MichelleH . I can't tell you the number of times where I've had users click on a value, and the assumed behavior is that they will drill into the records that make up that aggregate value. This would be a nice UX enhancement.

Some great new features! Many thanks to the entire team that has been working hard to get these out to us!

@gbrown it looks like you have this set up to lag 300 rows. Is that what you want? You can always test the output by running a preview in ETL, and then checking the output to see if it matches what your desired output is.

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 to the last value, so if you are missing data for a week, it would go back 2 weeks. If you want to avoid this, you will need to…

@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. String != string != STRING

case when Fixed Value is not null then "Fixed Contract" when Spot is not null then "Spot Contract" else "Undefined" END I don't have your actual data, so this is assuming that there is never a time when both "Fixed Value" and "Spot" are both populated, and that you don't have to check any other conditions. I threw in an…

I believe that there is a way for Domo to restore the page from their backups. There isn't a way to restore yourself from the Admin side. I'd suggest reaching out to your CSM and support.

How are you bringing this in (what type of connector/data source)? Are you doing an append or a replace?

You can specify the date format as an option argument in the config of the connector.

@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.

what exactly do you mean by dynamic? Are you saying that the goal will be dependent on changing aggregate chart values. Or that the goal is dependent on the particular series or date range? If you let me know, I can help walk you through a solution using either beast mode or ETL depending on your particular use-case.

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 up you’ll be able to specify your week start date. You can then either toggle that setting on/off to use your Monday start…

Thanks @BenSchein! This is perfect because I was on a work call when it popped up and accidentally closed it out. Thanks for sharing!

Something to keep in mind with this approach is that it's an all or nothing switch. Either all your scheduled reports will be .xlsx, or all will be .csv

The easier approach is to use Domo's built in chart type "Running total grouped bar". If you want to use the chart properties option, you'll need to use a line/bar combo chart. Then you can set the series on left scale to 0 and set number of running bars to 2. I don't see much advantage to this approach given your…

So this would require you to use an HTML table, which would mean restructuring your data because transpose isn't an option. But if you're really set on changing the font color instead of the cell color, you can achieve that by using this beast mode. CASE WHEN SUM(value) < 0 THEN CONCAT('<p…

@chetan_cricut if by first column, you mean the first column non-transposed, ie. Average daily projects. You could do something like this. CONCAT('<p style="text-align:left;">',SUM(value),'</p>') Keep in mind that concat removes the ability to use the native domo formatting. So you'll have to do the formatting in your…

The easiest way to achieve this is to set the negative numbers to show in red, and then use card color rules to set > 0 to show in green. The red negative number setting will override the green. However, this approach causes the cell to be filled in, just an FYI.