MarkSnodgrass Coach

You can actually get this field populated pretty easily using Magic ETL. Here's a picture of what your ETL would generally look like: Here's a breakdown of the steps in the ETL 1. Split your input dataset into to two datasets by using the filter tiles. Filter one to Product equals AUM. Filter the other one to not equal to…

@jaeW_at_Onyx is correct that you won't be able to do this in a beast mode, but you should be able to do this with the Rank & Window tile in Magic ETL utilizing the SUM and LAG functions. Here's a link to the KB article: https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_Rank_and_Window You…

Spoiler (Highlight to read)The following did not give me an error when trying it in Domo's MySQL : SELECT CAST(NULL as char) as mycol You could try that and see if that works for you.The following did not give me an error when trying it in Domo's MySQL :SELECT CAST(NULL as char) as mycolYou could try that and see if that…

You should use the DATEDIFF function to get this. You can also simplify your statement due to the way CASE statements process. Here is what I would suggest: casewhen DATEDIFF(CURRENT_DATE(),`CD (Start)`) < 90 then '3 Months'when DATEDIFF(CURRENT_DATE(),`CD (Start)`) < 180 then '3-6 Months'when DATEDIFF(CURRENT_DATE(),`CD…

If you edit your dashboard, you can click on Edit Content on each card and select Change Interaction. Then choose Open Card Details in New Tab. You'll have to do it for each of them, but then they will open in a new tab when you click on them.

I would consider using a different type of card for this type of visualization. Have you tried using a Scatter card and using the time as the x-axis?

Try going to the associated dataflow for that dataset and click on history. It is likely that the dataflow failed and that is why you are seeing the exclamation point on the resulting dataset.

In section 1 of your Group By tile, you would want to add your 4 columns (Date, Product, Publication, Channel). In section 2, select your Revenue column and choose Sum and give it a name such as Total Revenue. This should give you the total revenue when those 4 columns are the same.

Thanks @GrantSmith ! This worked great. I did the calculations in MS SQL, which doesn't have the MOD function, but it does a similar which just uses the percent sign. It ended up looking like this for the remaining days calculation. DATEDIFF(DAY,`EndDate`, `StartDate`)%7

I would try the String Operations and use the trim spaces function. There are likely some hidden spaces causing Domo not to see the names as the same. You could also quickly do this in a beast mode to see if that fixes it. Just use the TRIM() function to remove the spaces and then drag the new beast mode field into your…

You need to use your DATEDIFF evaluation in your case statement and not value1 since that is just a date. It would look like this: (CASEWHEN DATEDIFF (CURRENT_DATE(),`Value1`) <180 THEN 1WHEN DATEDIFF (CURRENT_DATE(),`Value1`) <365 THEN 2WHEN DATEDIFF (CURRENT_DATE(),`Value1`) <729 THEN 3WHEN DATEDIFF…

The issue is your AND statement in each sequence. You would need to re-state the DATEDIFF formula after the AND again. You might consider re-writing it in reverse order and it would eliminate the need to have the AND statement because CASE statements exit after finding a match to the condition. (CASEWHEN DATEDIFF…

Ordering the data in the table should not be necessary unless you just find it easier to look at it when you are in the data center and looking at the data of a dataset. Having said that, you could use the Rank & Window tile to order one dataset before the other if you really wanted it stacked in a certain way. Here is a…

If you make a beastmode that just has SUM('yourcolumn') and put that in the text value, it should sum up the values for you when no filter is selected.Otherwise, the textbox card is set to just grab the first value in the dataset.

It looks as though your issue lies in the first case statement not having a condition. What do you want your SUM / COUNT to equal to in order to use `Live` ? That part appears to be missing. Just before "then `Live`" you should have a greater than, or less than or equal to and a number. Hope that makes sense.

You might look into using a flex table to visualize this. It does MoM and YoY with colored percent change indicators really nicely. Just change your Date Filter to group by month or year to get the look that you want. Here is a link to the KB article.…

I think you are going to have better luck if you use the custom chart feature. You can upload any layout that you like as an svg file and then Domo will make it a heat map for you. Here is a video of how I did it on a human body. https://www.domo.com/help-center/videos/watch/Rj3iipg17hw This KB article was also very…

Can you describe more how you are wanting it to look? It bases the sizes off of the value field and the sorting property. You can manipulate it by creating a beast mode, but the end result would need to go in the value field. You can then make use of the different macros in the label settings and hover text settings to…

If you change their role to Participant, which is one of the five built-in roles, they will not have access to the admin center. Any other higher role (Editor, Privileged, or Admin) will have access to parts of the admin center. If the other capabilities that go along with the Participant role are too restricting, you…

Once you created the beast mode in the card, did you tell the card to use it in its specific date filter? I may not have been clear that you need to make sure each card is actually using the newly created common date field.

The name of your date fields need to be the same in all of your cards and your date filter in order for it to properly apply to all the cards. You can make this work by creating a beast mode with a common name such as "storyboard date" (or whatever works for you). The beast mode field only needs to contain the date field…

I would suggest you look into the Dynamic Textbox card to accomplish this. It could be powered by a Domo Webform or an Excel file that you or the controller updates. The dataset would have a date column and then a notes column and the notes column would go in the category field of the Dynamic Textbox card. The date column…

You could create a beast mode field that would group them into bi-weekly groups. You could do something like the following: CONCAT(MONTHNAME(`Date`), (CASE WHEN DAY(`Date`) <= 15 THEN '1st - 15th' ELSE '16th - EOM' END)) This would give you results, such as July 1st-15th, July 16th-EOM, etc... You would then just drag this…

In the General section of the Chart Properties, choose Sync Values. This will align the scales on the left and right side of the graph.

I would consider using a bullet chart because it has a Target Value field that is helpful to use in a case like this. You can create a beast mode field called target and put in a value of .20 and then drag this into the target value field. You might need to choose the aggregation type of Average, depending on your data.…

The treemap doesn't really lend itself to doing that type of colorization. In addition to the HTML table, you might look into the Shape Chart, which is found under gauges. You would need to create a card for each app_name, but you could create a story page, or a collection and have them small and right next to each other.…

Those are the multi-value cards found in the gauges category in the chart types. To align it the way they are, go to the General -> Layout and choose Domo Summary 1 or Domo Summary 2. Here's a link to the KB article that breaks down all the different properties.…

@jaeW_at_Onyx is correct that your temperature must be a string value and needs to be converted to numeric. You can do this very easily in Magic ETL by adding a Set Column Type tile to your ETL. Also, you can simplify your CASE statement since CASE statements exit out of the function once it finds a matching criteria. This…

You can export all of your jobs to JSON files and then import them back in on your new computer. Just click on the 3 dots icon in Workbench and go to Export on your old computer. Select all the jobs and choose Export Jobs. Save it somewhere where you can access from your new computer (network of flash drive) and then go to…

Another date function you can use in Redshift is Extract. I use it and it looks like this: extract(year from "dateofevent") DateofEventYear, extract(day from "dateofevent") DayofEvent, I am able to use the date_part function as @jaeW_at_Onyx suggests, so I'm not sure what might be going on with that function in your…