Best Of
Re: Beast Mode: Syntax issues on filtering out a Sum Total
Try this:
SUM(values) - SUM(CASE WHEN Id= 'Liability' THEN values ELSE 0 END)
Re: Is there a way to make a Summary display of a Beast Mode a color?
Yes, you can. It requires adding HTML and also formatting your value because it becomes a string in the process. This post outlines how to do it.
I have gone away from this method and stacked a multi-value gauge on top of my other chart as @PaulJames suggests as it requires a lot less effort.
Re: Thoughts from Ben
Many people may know that we hosted a case competition recently (finalists coming to Utah next week). As part of that process, I helped our education team put together a cheat sheet for the teams. sort of a quick dump of what I might want to know if I was getting started in Domo for the first time. Posting here in case people find it useful.
Re: Sort Column in ETL?
I wholeheartedly agree with the idea of a seperate sort tile. Rank and Window is fine, but not every situation calls for a window function or the additional configuration/grouping options needed for Rank and Window to function the way you want or expect. And as Apurkhardt mentions, there are actual use cases that rank and window aren't good for.
Not only that but when I'm doing previews in Magic, many times I just want a quick and easy way to visually sort the preview data so I can validate chunks of organized data without a bunch of extra configuration. It's easier and quicker on the brain.
From personal experience… my company is brand new to Domo and all of us come from a SQL background, but we have many developers who are struggling to grasp aspects of MagicETL because it doesn't have basic things like sort that have been in every single database technology since before I was born and is in every modern other modern BI product :)
Sort in and of itself may not be 'necessary' in DOMO in the traditional sense, but I'd guess most end users come from a SQL background where sort is a main staple and part of everyday life where as window functions are use case specific. Giving more options, especially something as simple as a sort tile does nothing but help developers and make adoptibility for new-comers a bit easier.
@Simon_King please post this in the ideas exchange area and I will upvote it.
DomoDork
Re: Cloud Amplifier dataset views can't be remapped to use datasets from other CA connections
Hey @akeating - thank you so much for the input. And I 100% agree with you that this makes a lot of sense. I'll add this to our roadmap.
Re: Domo Webpage
Hi,
I downloaded the org chart from the app store and copy pasted the data and it worked. I had to modify the report and made it work for now.
Thanks everyone for your suggestions.
Gunjan
Gunjan
Re: How can I embed a website into my DOMO Dashboard? Not a hiperlink to open a new tab.
Yep! Just ask ChatGPT and it will basically do it for you!
Prompt: Can you take this website and make it an iframe using HTML?
If you get stuck let us know!
Re: Syntax error with beast mode
@Stucker This looks like a datatype error. If I'm interpreting this correctly, you have a time field (`AVG Answer`) that you are trying to convert into a number of seconds/milliseconds. You are on the right track with the TIME_TO_SEC portion of the formula, but the problem is with the second part where you are looking for the number of milliseconds. The DATE_FORMAT function returns a text value, which cannot be used in mathematical expressions.
If you want to get down to millisecond granularity, then you will have to use a MagicETL instead of Beast Mode since the Formula Tile supports the MILLISECOND function, which returns a numerical output. Your calculation should look like this:
TIME_TO_SEC(`AVG Answer`) + ( MILLISECOND(`AVG Answer`)/1000000)
