Best Of
Re: domo.ds_rename not found
You can update the schema (specifically the dataset name) using the update method and updating the schema. There's an example in pydomo: https://github.com/domoinc/domo-python-sdk/blob/dacdee87d9e798f4c83f270b38c8ea2b1b6c7923/examples/dataset.py#L32
Re: Problems with Workbench, ODBC, MySQL and the data specialist exam
Hi, just thought I would update this case. I figured out what the problem was.... There was a missing step in the instructions, Domo should have mentioned that the in the Database Query Editor you needed to insert the following SQL command = SELECT * FROM Transactions. I managed to figure this out as the message was saying there was a blank field and I went through all of the fields to figure out this was the missing information.
Thanks
Ian
Re: Previous, Current, and Next Quarter Date Range in a chart
Hi @gsharma ,
A bit confused so looking for clarification. In your first paragraph you are saying you want to see previous, current and next quarter, but in the second you don't want to do the fitler on those 3 because it would limit the chart to only those 3. I'm not understanding because it sounds opposite of what you want....looking for more clarification to help.
Thanks,
John Le
You're only one dashboard away.
More video solutions at: https://www.dashboarddudes.com/pantry
Re: Domo Publish Enhancements
#1 would also be a problem for us. We will have 50+ subscribers and having to unsubscribe/resubscribe for all of them would be a real problem.
Re: Convert all dates to last day of year
Not sure if it was a typo or not... but you have some commas in strange places. Try this:
STR_TO_DATE(CONCAT(`YEAR`,'-12-31'),'%Y-%m-%d')
Re: Excluding weekends from a prior day card
You can create a beast mode that you would add to your filters to filter out weekends from your dataset. Your beast mode would look like this:
CASE WHEN DAYNAME(`date`) IN ('Sunday','Saturday') THEN 'Exclude'
ELSE 'Include'
END
You would then add this to your filter and filter to Include.
Re: One of my bar charts won't display properly in the dashboard.
This appears to be a bug. I'd recommend reaching out to support and submit your issue.
Re: Equivalent of IFERROR(VLOOKUP,IF(RIGHT(- in Magic ETL
@aldwinB From what I can see, your Excel formula is looking for 'AB' at the end of the Category field, but your ETL formula is looking for it at the end of `Product Group name`. That may be contributing to why you don't see the same results.
Also, the correct syntax for checking for nulls is Category IS null, not Category = null.
