MarkSnodgrass Coach

I would use the split_part function in a formula tile. It will look for the comma and split accordingly. Last Name SPLIT_PART(`employeename`, ',' ,1) First Name and anything else SPLIT_PART(`employeename`, ',' , 2)

If you have added the DomoStats Datasets and Dataflows App you should have a dataset called DomoStats - Dataset and Dataflow History. This has row counts for datasets in it.

If you are trying to get the date that is just after the "_ to _" you can use this in the formula tile to get it: DATE(REPLACE(LEFT(split_part(`metricdate`,'_to_',2),10),'_','/')) If you are trying to get the date that is before the " _ to _ " that will be slightly different.

I would delete and recreate to ensure they are created properly.

I was able to recreate your problem now that you describe that you are doing it when using the dataset view option in Analyzer. That view in Analyzer is new, and I believe you found a bug. I would submit a ticket to support@domo.com and explain your bug. They will send it to the engineers to get it fixed. In the meantime,…

Another option would be to create a drill path to a table card rather than to the raw data and do the format option as suggested. This would allow you to keep it as a number in case you need to do any calculations.

When you are in Analyzer and editing the card, click the pencil icon when you hover over the field and choose Format and then choose Display as Number and uncheck the Use Thousands Separator option. This will display your number without any thousand separators.

Yes. If you don't already have the date dimension dataset added to your data center, you can add it by going to the Data Center, click on Connectors, search for Dimension and select the Domo Dimensions connector and then choose calendar.csv from the list of files. You would then add this dataset to your ETL. You will need…

You can do this in the ETL with a combination of the formula tile to get the first day of the month, a group by tile and a rank and window that uses the lag function. Here are screenshots of what I just did to compare counts to the same month of the previous year: The formula tile just has a field to get the first day of…

Ahh... I understand a little better what is going on. In Magic ETL, you will want to use the Group By tile and then choose Add Formula and try pasting the formula into that. If that doesn't work, I would try breaking things out into separate steps where your formula tile creates the individual components without any…

@Pierce13 when you say Available Inventory is returning nothing, is that through the preview tabs when you are creating the ETL? Or is it after you Save & Run the ETL and the ETL fully runs? The preview window can be a little misleading when testing since it doesn't ingest all of your data if you have a large dataset and…

@Rvannoy the reason it is not calculating all of the numbers is because you are using SUM(DISTINCT()). Just use SUM, so it would look like this: SUM(CASE WHEN `CustomerName` LIKE'%VICTUS%' THEN .08 WHEN `CustomerName` LIKE'%WENPHIL%' THEN .15 WHEN `CustomerName` LIKE'%WISYNCO GROUP LIMITED%' THEN .20 WHEN `CustomerName`…

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…