MarkSnodgrass Coach

If you have a list of all divisions than you can create a Magic ETL dataflow to do a left join to your form data and then filter where the form division name is null. This would give you a list of divisions that haven't completed it.

@loganherzog Does your card have some data in it that might be problematic? Is this a pivot table card? Or just a mega table card? I would try recreating the card and see if the issue still occurs. Sometimes a card's properties get corrupted and I just end up re-creating the card. If you still encounter the issue after…

@MichaelClark since it is top down, the .05 will stop at .06 and would not evaluate any lines below it. Happy to help!

Case statements work from the top down and exit out as soon as they find a match, so if you put your statement in a logical order such as evaluating from smallest to largest, you can properly work through the different scenarios. In your scenario, I'm guessing you want "Good" to be less than .06, "warning" to be less than…

In the chart properties, go to Data Label Settings. In the text box, click the + sign and choose Percent of Category.

MySQL has a DATE_SUB function that would work for this. Try this for your where clause: WHERE `date` > DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)

@Jessica Sorry, I thought you wanted to export the Workbench logs that are stored on the computer running workbench and upload them to Domo to analyze them. That is what I explaining how to do.

I have many summary numbers that are using currency and they are only show $xxx. I looked around in the company settings, but I don't see anything that would relate to specifying the type of currency being used. Have you tried a different browser just to make sure it isn't a browser plug-in that is doing this and not…

I think this looks like something Domo Support will need to look into for you. I would start with them.

I think you will need to remove them at the dataset level and then add them back individually to cards that should have them. If you go to the dataset in the data center, you can click on the three dots and click on Chart Color Rules. This should which rules are tied to the dataset. You will want only want to have rules in…

Agree with this suggestion. Up vote isn't working for me right now.

@dacorson Currently, Magic ETL does not provide this directly. You can get around this by adding a constant before your join and then filtering after your join. This is how I solved it when I need to use a BETWEEN operator on my join but you can't do that directly in Magic ETL. You can see an example of how it was done in…

Do you have the time zone as part of the datetime data? (i.e. EST, PST, CST, etc,) If so, you can build a case statement to put it in UTC time (or standardized to any time zone that you want). You can use the SUBTIME function to subtract the necessary hours. Here is a list of time zone abbreviations to be looking for.

Domo assumes that all times coming in are converted to UTC. Depending on where you are looking at your data, it will show it in UTC time or in the time zone set in your Company Settings. If you are uploading your CSV file via Domo Workbench, you can use the transformation settings to move all datetime values to UTC when it…

It would be helpful to see the convert statement that you are using and more clarification as to which ETL tool you are using in Domo (Magic ETL, MySQL, Redshift, etc.) If I had to guess, your this Gross charge column is of type text. You can use the REPLACE function to remove the $ from your data and then try to convert…

You can do a calculated field and then use Left and Length to remove the last 2 characters. Would look like this: LEFT('field',LEN('field')-2)

Domo does have a Sankey chart you can use. You will find under Other Charts in the chart types. Here's information on how to power it.

You might need to provide some sample rows of your data. I took your final beast mode: (CASE WHEN (IFNULL(`qty found`,0)) = 0 THEN 0 ELSE (SUM(IFNULL(`qty sold instock`,0))/SUM(IFNULL(`qty found`,0))) END) And put together some sample rows with the same columns that look like this and beast mode calc worked.

According to this KB article, https://domohelp.domo.com/hc/en-us/articles/360057021074-OneDrive-Writeback-Connector it seems like it is contingent on Microsoft's API.

I'm not sure there is a limitation in the sql you can construct other than it is using mysql 5.6 and I've read about a limitation of 1 million rows. I agree that expanded documentation in this area would be helpful.

I'm pretty sure you will need to determine your max value in Magic ETL first by using the group by tile and then join it back to the main dataset so that you have the date that the max value occurred on for that type.

On the computer where my workbench is installed, I see all the log files are stored in C:\ProgramData\Domo\Workbench\Logs and there is a new log file for each date. Uploading each log file would be quite tedious, but I did find a way via command prompt to combine multiple text files into one. The full walkthrough is here:…

@joshpropp It is a feature that has been suggested in the ideas exchange and has received a lot of up votes. You can help up vote it here: Unfortunately, it has not been implemented yet.

@kivlind no problem! If this worked for you, please mark the answer as accepted so that it can help others in the community.

As long as the column name that your clicking on exists in the other dataset, it will filter for you. That means if you click on country name, for example, country name would need to be in the other dataset. You also need to turn on interaction filter on your page filter for the card to card filtering to work. I would also…

If you are using the mega table card, you can use \\n to force a new line. Example: CONCAT('Name','\\n','Address') If you are using the HTML table card, you can use <br />, which the HTML tag for line break: CONCAT('Name','<br />','Address')

@swagner great use of regex by @GrantSmith as usual. Just to see if I could, I came up with a way to do it in Beast Mode: SPLIT_PART(`String`,'-',LENGTH(`String`) - LENGTH(REPLACE(`String`,'-','')) + 1) To dynamically determine the number of dashes in the string, you can utilize the LENGTH and REPLACE functions. I am…

@GrantSmith I knew you were going to suggest regex! 😂

If you want to pull 3 different files from somewhere, you have to build three different connections, one for each file. This is the case for any connection type, SharePoint, sftp, Workbench. Each file needs its own connection.

@swagner Assuming you have always 3 dashes in there (as shown in your examples) you can use SPLIT_PART to get the string after the 3rd dash, which is the 4th part. SPLIT_PART(`String`,'-',4) Hope this helps.