Best Of
Re: Adding Missing dates between start and end date for each category
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 first day of each month from the calendar dataset, you can filter before the join to where day = 1.
Here's an example of what the ETL would look like.
Re: Domo API sample
That dataset ID doesn't exist in your instance so it's throwing an error. You can create a simple testing dataset using the WebForm connector and putting in some sample data if you want to test it before using real production data. You can get the new dataset ID from the URL when you're viewing the dataset details.
Re: Domo API sample
This is the webforms connector I was referring to:
https://domohelp.domo.com/hc/en-us/articles/360043436813-Webforms-Connector. Just search for WebForm in the connectors dialog box.
Re: Pivot table issues
Hi @user031170
There's a 25k row limit on most card types except for Histograms and Box Plots (100k limit). See https://domohelp.domo.com/hc/en-us/articles/360042924214-Card-Building-FAQs
Have you tried using a Sumo Table to do your pivot? Those have a higher row limitation and may allow you to chart your data properly.
Re: Is there a way to check if a field has more characters than a specific amount?
Hi @JoeR_PSIT
You can use the LENGTH function to get the number of characters in a string
CASE WHEN `Serial Number` IS NULL OR LENGTH(`Serial Number`) > 7 THEN 'Error' ELSE 'OK' END
Re: Api fails for filters
@sunny for your card is the public embed link correct? 404 means it can’t find anything at your URL. Are you able to take that URL and access it from a browser? Did you confirm the embed ID is the same as the Domo Everywhere configuration settings on the card?
Re: Summary Number Format in Notebook Card
@Madz_A I'd also recommend logging an idea in the idea exchange to allow the removal of the dotted line on the notebook cards.
Re: Is Magic ETL 2.0 able to handle more complex SQL injections?
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 summing and then use the group by to sum it up and then potentially another formula tile to do the division.
Re: Admin question: New hire was added to Domo as "social" role, but not recognized as a user
I would delete and recreate to ensure they are created properly.


