Best Of
Re: can anyone point me to the solution on how to build the following year to date vs previous year?
For MTD and WTD, you can use the dayofmonth() and dayofweek() functions to get the numerical value of the previous day in terms of week or month, and then compare to last year's to make sure the same value is less than or equal.
QTD and YTD can get tricky depending on if you're using a special fiscal year or not. If it's just the straight calendar year, the dayofyear() function should work. If not, you'll have to make some adjustments in the beast mode. Someone else might know how to do QTD in an easy way, but I think you'd have to define each quarter in the beast mode and then adjust the value you get from the dayofyear() function accordingly.
Re: can anyone point me to the solution on how to build the following year to date vs previous year?
You will have to either build out beast modes for each metric, or build them out as formulas in Magic ETL. In essence, you'll be making a bunch of formulas that look like the one below, which would be for sales, previous day, this year:
sum(case when date_field = current_date() - 1 then sales_field end)
Sales, previous day, last year: would be:
sum(case when date_field = sub_date(current_date(), interval 1 year) - 1 then sales_field end)
And the YOY change would be a new beast mode taking the difference between the two formulas. Repeat down the line for each date iteration, adapting the comparison between your date_field and the current_date() function to fit your needs.
Hope this helps!
Re: DomoXCanva Challenge Details
For those that are working on this challenge and want to use a Domo Brick instead of a Custom App, I walk through how to do it in this video:
Re: Domo API to import files to domo
To add the updatemethod=Append argument to your Domo object instantiation in Python, you can include it as a keyword argument like this
domo = Domo(client_id, client_secret, api_host=api_host, updatemethod="Append")
Facebook Ads Advanced Connector - Updated?
Hello Everyone,
Did anyone else happen to notice that the Facebook Ads Advanced Connector added a new dropdown of "Select Status Of Account To Retrieve"? I'm seeing it show up now, and it defaults to all accounts, if if you had one selected previously. This caused some issues on my end, but I can't find any documentation on changes in DOMO or Facebook that would have explained this new drop-down
.
Re: Drill in Place
Yes I think this is a bug. We are having the same issue as well. I am going to open a support case with Domo and I can add this link so they see you are having the same issue!
Re: Weekly Average Graphed by Month
@ColemenWilson Thanks for your help on this! This is exactly what I needed.
ABauman
Domo NetSuite Connector Implementation
When configuring the NetSuite Connector, I receive an error. I validated that the NetSuite User Name and Password are correct, I also reverified that the Role, Script and Deploy ID's are all correct. I'm able to login to NetSuite as the user and run the saved search without any problems.
Error Message: Domo is ready, but the credentials you entered are invalid. Verify your account credentials and try again.
Failed to execute import successfully.
Get rid of filter icons in app studio apps?
I cannot figure this out. In story dashboards you can disable filter and pdp icons from showing over each card impacted. Additionally, I can't figure out how to clear filters from the app.