MarkSnodgrass Coach

Here is a screenshot of a recursive dataflow that I have set up and I don't have to manipulate each time. Basically, I am using the select columns tile to only have the ID column from my recursive dataset because that is what I am using to join on. I rename it at the join clause and filter where it is null. My append tile…

What aggregation is the field using? Click on the pencil icon next to the field in the card and choose Sum for aggregation.

In your 2nd statement, don't put your quotes around your numbers, that will make them strings. Try this instead: (CASE WHEN `CustomerName` LIKE'%AGRODEX INTERNATIONAL SAS%' THEN .14 wHEN `CustomerName` LIKE'%ALTURISA GUATEMALA%' THEN .14 WHEN `CustomerName` LIKE'%ANGLISS HONG KONG%' THEN 3 WHEN `CustomerName` LIKE'%BEN…

The October 2021 release allows for setting user-specific landing pages. This KB articles explains it and may be helpful for you. https://domohelp.domo.com/hc/en-us/articles/4409575159191

If you are using Domo Workbench 5.1, they have the option of partition support, which can help when dealing with large datasets. Here's the KB article about it. https://domohelp.domo.com/hc/en-us/articles/360062446514-Workbench-5-1-Partition-Support If you are using another type of connector, appending is the most common…

I would create a beast mode to do this comparison: CASE WHEN MONTH(columnA) = MONTH(columnB) and YEAR(columnA) = YEAR(columnB) THEN 1 ELSE 0 END Then drag this field into your card and choose Sum for aggregation along with columnA and you should get your totals of when they are the same.

"Mr. Window Function" @GrantSmith has a nice outline of rolling averages here: https://dojo.domo.com/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages#latest and yours looks pretty much like his 3 day rolling average example. Are there gaps in the data that are causing the issue? Did the formula validate…

To help with the dataset conversion, you can go to the data center and then click on the dataset that the cards are tied to and then click on the cards tab and choose "switch cards to a different dataset" and select the dataset you want to move them to. This will move all of those cards to that dataset along with the beast…

@micheleb just out of curiosity, did you try a beast mode like this: DATE(yourdatefield) I don't have a sample dataset to try it on, but wondered if that throws an error, or if it standardizes the data for you.

Do you have non-date data in this field? If not, when you are in the ETL you can select that input dataset and on the configuration tab, change the data type from text to Date (assuming that it is currently text). Domo should auto-format your dates to normalize this data for you. If this doesn't work for you, let me know…

@mhouston I'm using the dynamic textbox card in my example, not the notebook card. It has color options available.

@Canioagain One way that I handle this is to use the period over period card and set the date range to This Month and graph by Month and compare to 1 Month Ago. Then, to keep the previous month to only showing its total to the same amount as where the current month is at (i.e. compare through the 17th for each month) I…

The October 2021 release allows for setting user-specific landing pages. This KB articles explains it and may be helpful for you. https://domohelp.domo.com/hc/en-us/articles/4409575159191

Have you tried manually running it? I believe that forces it to re-activate. I have some disabled datasets and the instructions say to manually run it to re-activate it.

@Saketh this would just be a simple average since you aren't putting a weight on anything.

Your beast mode will never return Success as currently constructed because it evaluates the data one row at a time. Therefore, Name will never equal 4 different things in one row. Depending on what card type you want to use, you might try doing the following: Add Name to your filters and select your 4 dataflows Add Last…

@Saketh since you are already aggregating it, you just need to ignore the aggregation field and click on Show Formatting Options and then choose percentage for the Display As format. You will then see your summary number as a percentage.

To your thought about heatmaps, I do like to use those and there are two different heatmap options: Heat Map under Other Charts and Heatmap Table under Tables and Textboxes. With the Heat Map under Other Charts, you can put the Month in Category 1 and the region in Category 2 and the count of case id's in the values…

That's a bummer it doesn't show the next level down. To get this to display in a pivot table, you need to ask your CSM to enable window functions in beast modes, if it isn't already enabled. It is not enabled by default. Then you can create this beast mode with this formula to get the percent of total for each month by…

Also, you may want to click on Transpose under General and choose graph by month in the date range filter to get your months as columns if your data isn't already structured for that format.

There are some window functions that can probably do this for you, but pivot tables can be tricky with the window functions. I would start by trying the mega table first. In the chart properties, under subtotal rows, you can enable the option to show percent of total. Then collapsing the items in the mega table, should…

Pretty sure you can't do what you want to do with a pivot table. However, you can customize a flex table to those values calculated. Here's a link to the KB article to show you how to customize it. https://domohelp.domo.com/hc/en-us/articles/360043429073-Flex-Table

@hqu I believe I have come up with a solution for you. It involves creating a MySQL dataflow and creating a function to calculate the next workday and then using the function in your call to your dataset. Here's what to do Create a MySQL dataflow and add in your dataset and the Domo Calendar dataset. Click Add a Transform…

@hqu I would consider adding in the Domo Dimensions calendar dataset into your ETL. It has a list of all dates across a given range and has columns for IsWeekend and IsHoliday, which you could use to help with your counting. If you haven't used it for before, you can find it by going to connectors and search for Domo…

There is this beast mode function that is available, but it requires two dates, so may not suit your needs, but thought it is at least worth pointing out. DATE_WORKING_DIFF(expr1,expr2) Returns the number of days between the dates expr1 and expr2, excluding weekends (Saturdays and Sundays). The result is negative if expr1…

If it is a standalone card, I don't believe there is a way to change the background. If it is part of a dashboard, you can change the background by editing the dashboard and then click on Edit Content for the card and choose change background.

You could use the Rank & Window tile in Magic ETL to rank your entries. Once they are all ranked, you could use a group by tile to get the max value value of the rank and then join it back to your ranked entries and then use a formula tile to determine what percentage it is. Then include/exclude on that percentage value.

You should have the formula tile available to you now that Magic ETL 2.0 is live. You can then do this in a formula tile to remove the $ and convert it to a decimal: CAST(REPLACE(`fieldname`,'$','') as decimal)

You can actually do this in the beast mode and setting your date range filter to group by month of submission date as it sounds like you don't care which month the approval occurred in, just the fact that it was approved. You can get the approvals count by doing a beast mode like this: SUM(CASE WHEN `ApprovalDate` IS NOT…

I find it is easiest to do this in Magic ETL utilizing the Rank & Window tile. Choose the Lag function and then choose order date asc and partition by your account number and order number. This will put the previous order date (when there is one) next to the next order. You can then use the formula tile and the datediff…