swagner Contributor

@GrantSmith thanks for the reply. I'm really trying to do this in Magic ETL so I don't have to add another layer (if possible).

@MarkSnodgrass THANKS!

@Neeti the case statement I provided is simply an example of the logic I am attempting to build with a real beast mode. This beast mode does not work as is.

@Neeti what are you asking?

@DataMaven From YouTube help docs, I found this: Replace a video You can’t replace a video because any new video you upload to YouTube will get a new URL. Sorry... I wish you could do this as well.

@user10714 I found your post today while searching how to do the same thing myself. I found a solution! You can use a set column type tile and change the decimal to a whole number. That rounds to the nearest whole number. I also thought about converting the decimal to text and then breaking it apart with string operations,…

@user041099 take a look at custom roles (admin >>> roles) Here is the KB article on the topic: https://knowledge.domo.com/Administer/Controlling_Access_in_Domo/Managing_Custom_Roles

@user02674 (Adam) Good news! I understand the application you are describing below. (I work in distribution) I refer to this as dependent demand. Your store usage (demand) is essentially rolled up in forecasting inventory levels at the DC served (DC also may have it's own independent demand to consider). If this is still…

@user15431 @DaniBoy Have you tried using OVER() ? Here's an example I used for the included screen shot. SUM(`Extended Price`) / SUM(SUM(`Extended Price`)) OVER()

My first thought is to use series & color rules to plot two lines on the card. Then write a beast mode with a case statement to determine if the date is in the past, or in the future. Suppress the lines so that: * The past values are "Actual" and are represented by a green line (Jan thru Jul shows that line). * The future…

Not exactally sure I understand, but I don't think there is a way to hide items in the legend that are still available in the card (not filtered out).

@smike626 Try this approach: SUM(`Contract Amount`) / SUM(SUM(`Contract Amount`)) OVER()

Posting for those that many follow this post later. Below is the summary number beast mode I put together based on feedback here, adapted for $ (the post @cwolman referenced, altered for my use case). Includes the red/green color formatting, the directional arrow, and currency formatting. CASE WHEN…

@Godiepi thank you! I will defintely use what you've posted here sir!

@cwolman - nevermind... when I hit save & close it showed up with the format. THANKS!

I've got the following working, but the color formatting is not being applied. Can you see what I'm missing: CONCAT( CASE WHEN (SUM(`Mayer`)-SUM(`Par`))>0 THEN '<div style="color: green">' WHEN (SUM(`Mayer`)-SUM(`Par`))<0 THEN '<div style="color: red">' ELSE '<div style="color: black">' END, (SUM(`Mayer`)-SUM(`Par`))*100,…

@SIL2 The only thing I'll add to what has already been said by @ST_-Superman-_ and @DataMaven is that I do a lot of this work before I pass data to Domo. Sometimes you have to do it closer to the cards via the methods they mention, but if you can do those joins ahead of Domo (or in workbench via SQL) that's my first…

Here is the link to the video I created: https://www.youtube.com/watch?v=S9l56QtsUkc and the relevant Domo Knowledge Base article. Thanks!

If I am understanding correctly, I don't think the current functionality supports what you're trying to do. This would be something worth putting in the Idea Exchange. I would give it a like for sure.

@ST_-Superman-_ Thanks for the detailed info, I am sure this will come in handy for me and others. I have played around with this kind of linking a bit, but I'm not sure it allows enough flexibility for my users. In my instance my users come up with all kinds of combinations of filter that they want to see on a regular…

Thanks @DataMaven let me know if you want to collaborate.

Here is an updated version of the video

Here is an updated version of the video

Yes sir, I will do my best. I enjoyed the Dojo awards at dp18, would love to join you and the other Dojo folks next year. Thanks for the kind words, was great seeing you as well. I'll keep looking for opportunities to share, make videos, and learn in this great community.

I figured it out on my own. Post solution in case others have the same issue. I was over complicating the Beast Modes: Project Hit Rate: CASE WHEN IFNULL(COUNT(`Quote Number`),0)=0 THEN 0 ELSE Sum(case when `Converted to Order?`='Yes' then 1 else 0 end) / COUNT(DISTINCT `Project Name`) END Quote Hit Rate: CASE WHEN…

@ST_-Superman-_ I wanted to let you know I found this thread, followed your example, and was able to implement a Customer Churn page in my instance of Domo based on what you provided here. HUGE THANK YOU!

AWESOME!!!!

@DaniBoy wanted to be sure you saw how this turned out. Thanks as always for your help. Great seeing you in ATL yesterday sir! Safe travels home, and please have a great weekend!

@GTA thanks again for the feedback. I have inplemented the solution you offered. Here is a short video overview of how I implemented the Window function in case others want to see this in action.

Had a simple question this morning. I recorded the short video and sent back to the user. Once you get the hang of Camtasia you can turn these kinds of videos around FAST! https://youtu.be/wYhPj9h7f28 Attached is a screen shot of the page in my Domo instance where I have all of those business questions users have asked,…