MarkSnodgrass Coach

You should be able to do this with creating a rank in a beast mode and then adding it to the filters section and filter to less than or equal to 100. Your beast mode would look like this: RANK() OVER (PARTITION BY QUARTER(date), YEAR(date) ORDER BY SUM(score) DESC) Your client should be in the series, your date should be…

Do you get this error message when you click on the preview (eyeball) icon in the job as well? Is it an .xls file or .xlsx?

I believe this was requested on the last beta call and they are putting it on their list of things to consider for future updates.

This video walkthrough may be helpful for you as well.

You would use the Unpivot Tile and configure it like this:

I agree with Michelle's suggestion. I'd also point out that in your original syntax, you are missing multiple END statements. Every time you use CASE, you need to have a matching END. You have 2 CASEs with no ENDs.

Are you saying that you want the raw dataset that pulls data from Salesforce to be on this custom schedule and not a Magic ETL dataflow that uses this dataset?

Yes, you can create multiple triggers for when an ETL to run. You can create one trigger that runs every 4 hours M-F. Then create another trigger by pressing the Add Trigger button that runs every Tuesday at 10:45.

The DomoStats connector has a Buzz dataset that can give you information about Buzz usage. It won't give you the chat contents if that is what you are looking for, but it will give you other useful information.

This idea has already been submitted here: Consider adding your vote to this idea and hopefully it will be implemented by Domo at some point.

When using Bricks, you will be querying your data using the JavaScript section of the brick. Your question really becomes a JavaScript question. If you haven't reviewed this section of the Domo Developer Docs, I would recommend looking through their tutorials.…

I don't think there is a way to be notified that a card doesn't load. To fix the issue, edit the card and the issue should be highlighted when you are in Analyzer. I have also seen this happen when the dataset has not been accessed in a long time. To fix this, you need to go to the dataset and click "start" (I believe) to…

Is there a specific error message that is displayed when you try to save?

Similarly, you can do: DATE(CONCAT(`Month`,'/1/',`Year`))

@jaeW_at_Onyx has compiled a pretty solid library of API endpoints. Here's a link to it:

You can use the HOUR function in a beast mode to extract the hour of the day out of your datetime field. You would then put this beast mode in your x-axis. Beast mode would look like this: HOUR(startdate)

You need to go to the accounts section in Workbench which is the key on the left side and then re-authorize. It will typically open up a browser window and have you put in your Domo credentials to authenticate. The easily missed step is clicking on the Save icon in the top right of Workbench after you finish the browser…

It seems like you have a running total option selected. Assuming you are using the Line Bar chart type, go to your Chart Properties and make sure the Number of Running Total Bars is set to None.

Great post! Thanks for documenting this for everyone!

I walk through how to do this in this video:

Yes, you can do this using the Variables feature. Here's an overview of how to use them.

I think you are going to want to look into the fixed functions feature for this. https://domo-support.domo.com/s/article/4408174643607?language=en_US You may also want to look into the segments feature. https://domo-support.domo.com/s/article/4403089503383?language=en_US

I agree that it could be improved. You can use traditional SQL or their Data API syntax. These links on the developer.domo.com site should help you. https://developer.domo.com/portal/8s3y9eldnjq8d-data-api https://developer.domo.com/portal/6fa7587d4c2ea-querying-data…

You might try changing the inner joins to left joins and then use a filter or remove duplicates tile to get to your desired result.

I would re-write them to use IN and NOT IN like this: CASE WHEN GL Group Code NOT IN (170, 175, 190) and Current Balance >=100000 THEN '01' ELSE 'N' END CASE WHEN GL Group Code IN (170, 175, 190) and Current Balance <100000 and Current Balance > 0 THEN '02' ELSE 'N' END

You can use two join tiles and do an inner join on each. the first one joins ID → New ID and the 2nd join tile joins ID → Legacy ID. You would then use the append tile to bring the data together. Would look something like this:

I was just looking into some remote triggering of Workbench jobs and one of my Domo contacts thought about Workflows as well. He did some asking around with the Domo engineers and was told Workflows would not be able to help in this scenario. There is a beta of Domo Workbench Enterprise that might be worth looking into. It…

I have been able to use the HTML br tag in summary numbers to do line breaks. Like this: CONCAT(IFNULL(Street1,''),'<br />',IFNULL(city,''),', ',IFNULL(state,''),' ',IFNULL(Zip,''))

Like this: CONCAT(IFNULL(Street1,''),' ',IFNULL(city,''),', ',IFNULL(state,''),' ',IFNULL(Zip,''))

CONCAT can have trouble dealing with nulls, so I would suggest wrapping each element in IFNULL and replace it with an empty string, like this: IFNULL('zip','') Hope this helps you.