MarkSnodgrass Coach

Do you have anything in the sorting section of the chart properties? When your x-axis is not a date, Domo usually needs something in the sorting section to ensure that the x-axis is sorted in the way that you would want it to.

You can't add it to the data table, but you could add it to the tooltip fields and then show tooltip field 1 with the data label sttings or hover text settings.

Great idea!

My first suggestion would be to do the calculation in Magic ETL, but that may not work for you depending on how you want the card to function as far as filtering You might try restructuring your case statement and see if that does the trick. If you can get your objective within your division calculation so that your are…

If you add your objective column to the table card, will that show that there is a month "repeating" because there is a different objective type?

@jmathers Yes, you can do this very easily. First, to restrict faculty to only seeing their students, you would need to set up the appropriate Personalized Data Permissions (PDP) policies. Once that is in place, you can use the table card to show only people with a passing grade, or you could use color rules to highlight…

Check to see if you have any fields in the Sorting section of the Analyzer. That will throw of how Domo can aggregate the data in the card. Also, check the Date Range Filter and what it is grouping by.

It does seem like a support ticket is in order. Mega tables are limited to 100 columns so you are pushing they edge. It is likely that they didn't test on edge cases with whatever recent enhancements they may have done.

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:…