n8isjack Contributor

Awesome, thanks Rich!

Impressive!

And to be careful, though unlikely to happen, you can protect against "divide by zero" errors: CASE -- If denominator is zero, result is zero WHEN (100000 - SUM(CASE WHEN `Status` = 'Won' THEN `Value` ELSE 0 END)) = 0 THEN 0 -- else, do the real calculation ELSE SUM(CASE WHEN `Status` = 'Open' THEN `Value`) ELSE 0 END) /…

There is a limited set of css styles you can control. Tehre is a list here: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Sample_Beast_Mode_Calculations%3A_Card_Element_Transforms Line-height is not one of them. However, you can use header tags, which have expanded…

Alert functionality is driven on the card type and settings. For example, a table card can only track changes to the summary number and so it is the only element that can be alerted for. Bar charts can track changes to values for the x/y axis and/or series. There is a balance to getting a card built right such that it will…

I can't get it to happen. I created a chart and resize it to different sizes but the different views resize all the lines, drop labels, but show everything. Can you show a picture of what is happening?

Short answer: No, the page filters will apply to all cards on that dataset. Workaround: You can create two outputs from the same ETL. This means you can easily duplicate your dataset into two different datasets. If you use one for the YTD cards and another for the monthly cards then it can filter them independently. Issues…

The trick here is that you updated existing data instead of adding future data. The Short Answer: You'll have to add values for dates in the future using a dataflow or other data prep process. The Long Answer: Here is a few sample rows of data Date Values 1/1/2019 10 2/1/2019 20 3/1/2019 30 Here it is with a new Beastmode:…

Ok, I think you are right. There will have to be something done to the file to load it. You might consider Domo Workbench which can integrate with an external script (vb script for example). Workbench can run the script, which would download from the SFTP site and extract the sheet you want, and then upload the results…

Just to be clear, does it have multiple sheets? The sheet name is optional so if it is the only sheet, or first sheet, then you can just leave that field blank.