Best Of
Re: Time Format
How are you combining your date and time fields? What format is your time field in?
Re: 400 Error when trying to create a dataset with API on Python
Hi @DKCloud9
Have you tried utilizing pydomo? It's all packaged to neatly do this and is a supported method for communicating with the APIs.
Are you getting an error message back with your 400 code? Have you tried replicating your API request in a tool like Postman to make sure your body, parameters and url are correct?
Re: Previous day values - Following Day Values Restart Calculation Each Month
Since you mentioned Magic ETL you can utilize a Rank and Window function to calculate the LAG for the download field. You can then take the current download count for that day and subtract the lag value to get the difference increase for your day. You'll want to make sure to partition based on the year and month of your date since the count resets each month.
Re: Problem with SQL for WordCloud Chart
Hi @Ainash
Does your dataset have a single column? If that's the case the word_cloud function doesn't work with a single column. You can add a dummy column to allow your dataset to be processed. I've written about this previously here: https://dojo.domo.com/discussion/comment/54744#Comment_54744
Re: Problem with SQL for WordCloud Chart
You and me both @Ainash. Is that the error message you get when selecting 'Run to Here' on your function call to the word_cloud?
Are you able to add a transformation to just select the column you need (plus another or just a bogus value) from your input dataset and utilize that resulting table as your input table to?
Re: Group by Month, sorting by Year with that month
One other thing to note is you can use the name of the month instead of the number via a beast mode:
MONTHNAME(`dt`)
Then use that beast mode in your Category 2 field.
Re: Reg. Expression to replace a list of names with a single character.
Hi @user048760
Are Just names included in your column and you want to blank it out or is there other information in that column that you need to retain except for the name? If it contains just the name and you want to set it to one if it is populated you could utilize a formula tile in Magic 2.0 with this code:
CASE WHEN COALESCE(`Reserved By`,'') <> '' THEN 1 END
Re: Failed parse text 'NULL' from column 'Column Name' as type 'Date'
Can you remove the 'NULL' string in your data before it gets ingested into Domo? Are you able to ingest your data in that column as a string, use a text replace tile to replace the 'NULL' string with the actual null value then use the Set Data Type tile to convert that column to a date or date time?
Re: Rename filter values to "Other"
Hi @user000253
You can use a beast mode to create your custom buckets (Name 1 & Other) and use that as your quick filter.
CASE WHEN `name` = 'Name 1' THEN `name` ELSE 'Other' END
This is assuming your column is called 'name'