MarkSnodgrass Coach

The basic table card supports a limited amount of HTML in it. To do what you want to do, you need to choose the HTML table card type. This is found under Tables and Textboxes in the chart types dropdown list.

If I recall, the exam is a two-part exam. One part is a multiple choice exam that is around 20 questions. You do have to complete it once you start it, but only takes about 30 minutes and they give you a big window to complete. The 2nd part is an "offline exercise" that you will complete and upload your finished product by…

the dataset via e-mail connector does have an update mode of append, but it can be challenging if you are toggling back and forth and not lose what is currently stored. I might suggest a recursive dataflow. Here is the KB article on how to create it in Magic ETL.…

There are a couple examples out there for you that are worth looking at: @jaeW_at_Onyx has a nice video that walks through this: https://www.youtube.com/watch?v=CDKNOmKClms&t=764s @GrantSmith also has a nice write-up on how to do this:…

@r4geqwit I actually was able to recreate your issue in Magic ETL. This does seem like a bug that should reported to Domo Support. However, I was able to develop a workaround by wrapping a date function around both values and then it evaluated correctly. Like this: CASE WHEN DATE(`datereported`) >= DATE('1/1/2022') THEN…

I would double-check that your Application Latest Hired Date is being seen as a date field by Domo and not a text/string field. If it is not being viewed as a date field, the evaluation will be problematic.

This is likely coming from Domo Workbench. You need to go to where Domo Workbench is installed (likely on a company server) and check there for the reason that it isn't running. In Workbench, you can also change the type from Other Provider to Excel.

@micheleb are you applying some additional formatting or something? When I put this in the beast mode editor: SEC_TO_TIME(37900) The card resolves to That seems like what you are going for.

You can use a case statement and datediff to do this: CASE WHEN DATEDIFF(CURRENT_DATE(),`lastpmtdate`) >= 60 THEN '60 or greater' ELSE 'less than 60' END Then just filter to 60 or greater

If your dataset is showing totals for each day, you can do this in Magic ETL with just a few tiles. It would look something like this: Use the formula tile to create a year column and month column Use the group by tile to get totals for each month: Use the Rank & Window tile create an 18-month total calculation by using…

I found these API calls as potential options for you: https://collectapi.com/api/gasPrice/gas-prices-api/stateUsaPrice https://collectapi.com/api/gasPrice/gas-prices-api/usaCitiesList

Agree with @GrantSmith Your sorting and limit properties should look something like this:

It looks like you are missing a comma in the function syntax. It should be: DATE_SUB(`Year/Month` , INTERVAL 12 MONTH)

@eriena It looks like you want to show the totals for each month for the previous year in addition to all the detail. You can with just a few steps in Magic ETL: Use a group by tile to group your totals by month Add a formula tile and use the DATE_SUB() function to create a new column that would have the previous years…

you might try using SUM to do your counting. For example, you can do something like this: SUM(CASE WHEN `column` >= 1 THEN 1 ELSE 0 END) You will want to change the WHEN statement to what would work in your situation, but this might get the results to display the way you want.

@user027926 To fill in blanks on the pivot table, try going to the chart properties -> general and select "Fill Empty Data Cells With 0"

@AnaKS if you are using Workbench, on the configure tab under additional settings, make sure Allow Schema Changes is selected. I would also suggest you click on the preview icon and then go to the schema tab to see what has been updated. You can also try locking column types on the schema tab to see if that helps.

Agree with @GrantSmith . Here is an example where I use tooltip1 to store the count of a field an incorporate it into the hover text

From the KB Article https://domohelp.domo.com/hc/en-us/articles/360043429573-Table-Chart You can have up to 25,000 rows in a Mega table. If you are viewing your dataset in the data center and export to CSV, you may be able to export up to 1m rows.

@Emma the IFNULL function is also useful for this and does the same thing. COALESCE is useful when you need to evaluate multiple fields before replacing with a single value. Here is what yours would look like with the IFNULL function: IFNULL(`Total Stock`,0)+IFNULL(`Total QTY to be delivered`,0)-IFNULL(`Total fcst…

You need to change the equals to greater than and equal to and less than and equal to like this: (CASE WHEN `Ship_Date` >= CURRENT_DATE() - INTERVAL '4' WEEK AND `Ship_Date` <= CURRENT_DATE() + INTERVAL '4' WEEK THEN 'INCLUDE' ELSE 'EXCLUDE' END)

@Anna Yardley If you could add the ability for a user to change a topic to a question after they posted, that would be extremely useful. So often, people start a topic when they intended to start a question and they don't have the ability to mark an answer as accepted. If you can give them the ability to change their post…

I apologize, I'm having a hard time fully grasping what you are trying to do, but I would suggest a filter tile with a formula rule that looks something like this: `salesstartdate` >= `calstartdate` and `salesenddate` <= `calstartdate` This would filter to where the date from the calendar table is between the sales start…

What are you trying to accomplish when you filter?

Ok. In your case, I would suggest a Left Outer Join and make the calendar the left table. This will give you a row for every day and your sales date will have a value when there is a match. You actually won't need that constant field that I described earlier.

@User2021 did you apply any filtering to the calendar dataset prior to joining with your main dataset? Also, make sure your join criteria only includes the key column. Don't add any other columns to your join criteria.

You can accomplish this with the DATEDIFF() function, which calculates the number of days between two dates. Example: DATEDIFF(`DateA`,`DateB`) To count how many are within 30 you would add a CASE statement around this, like this: CASE WHEN DATEDIFF(`DateA`,`DateB`) <= 30 THEN 1 ELSE 0 END

If you go to the Data Center and then click on your dataset and then go to the History tab, you have the ability to delete different updates by clicking on the wrench on the right side.

You are on the right track using the Domo Calendar. What you need to do is an Add Constant tile after each dataset and create a column such as JoinCol and assign a value of 1 to each. Then join the two datasets on that column, using a left join of the calendar so that you get all the dates. If you are just wanting the…

In your card, how do you have the field formatted? If you are leaving it as default it may be rounding it to the nearest whole number. Make sure you click the pencil icon when hovering over the field and choose Format and Display As Number and choose the appropriate decimal places.