Comments
-
@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,…