Best Of
Re: Campaigns App Data not rendering
Actually figured it out. It was right there in the FAQ's. Just need to check "Disable strict no data checking" in the settings tab of the campaign. This will allow the campaign to deliver even if one or more cards has all the data filtered out.
Re: New Coach! Happy to have you @RobynLinden
Too sweet, thank you @AnnaYardley! I was indeed at the kickoff session for the Community way back when, and I'm glad this space is thriving today. Always happy to be in good Domo company :)
New Coach! Happy to have you @RobynLinden
Huge Congratulations to our newest Community Coach, @RobynLinden 🎉
Robyn has been a member of the Domo Community since the very beginning (in 2015)! Many of you know her from virtual and in-person events. All of my interactions with Robyn have been very positive and pleasant. We could not be more thrilled to have another Coach on our Community Forums.
Becoming a Coach is not easy – it requires a lot of time dedicated towards helping others and providing solutions. If @RobynLinden has collaborated with you, please congratulate her in the comments below.
Re: Calculating Time difference in Seconds Beast Mode
Thanks, the beast modes are now working.
agolla2
Re: Formula to calculate date of Monday of previous week
Explanation:
DAYOFWEEK(CURRENT_DATE()) = 2 is Monday. If it's Monday, we subtract 7 days to get the previous Monday (e.g., on Monday, 9/30, this will return 9/23).
For any other day (Tuesday through Sunday), we subtract the number of days since last Monday. The DAYOFWEEK(CURRENT_DATE()) + 5 handles this by calculating how far back to go to the previous Monday.
• For example, on Tuesday, DAYOFWEEK(CURRENT_DATE()) = 3, so this will subtract 8 days (returning the Monday of the previous week).
• On Sunday, it will subtract 12 days to go back to the Monday of the previous week.
Re: Formula to calculate date of Monday of previous week
Hello @michaelg25,
You should be able to do it with HTML Build-in Summary number like:
CONCAT('As of ', DATE_SUB(CURRENT_DATE(), INTERVAL (CASE WHEN DAYOFWEEK(CURRENT_DATE()) = 2 THEN 7 ELSE DAYOFWEEK(CURRENT_DATE()) - 2 END) DAY), ' Total amount is ', SUM(1))
Change SUM(1) with any calculation you want to see as a summary.
Re: How can I format my Alert so that it displays the information in vertical text?
You can get this format easily and by default using a dataset alert rather than a card alert:
Re: New Calculated Field isn't saving. Uncertain of next steps to save.
Hello @DeborahAnderson,
I've encountered this as well. After clicking "Create Calculated Field" and then "Save Calculated Field," if I copy text from the formula or name, or switch tabs, I sometimes get a warning about unsaved changes. I typically just ignore it or save again before closing.
Re: How to show series of dates not closely tied to your data point?
There's a calendar card-type, if you just want a list of dates.
But my guess is you're charting some data that has gaps in which dates there is data for, and you'd like those gaps to be maintained or shown with labels in whatever chart/table you're working on. The answer to that is, no, you can't graph data that isn't in your dataset. You need a row with that date and a null value for what you're graphing, plus a value that matches anything you're filtering on. You can get that by joining your data with Domo's calendar dataset. You might search through past community forum posts to find something that best matches your situation, because this is a question that has been asked/answered a fair number of times in different iterations. Here's one with a particularly thorough explanation from @MarkSnodgrass:
Re: Mega-Ultron-Super-Duper Connected Dataset to rule them all
@Data_Devon I would suggest going the append route for this data and adding a Category column to indicate the source of each row (Budget, Financials, etc.). Then you can use beast modes to present the output in a single card like this:
Budget Revenue: sum(case when Category = 'Budget' then Revenue else 0 end)
Actual Revenue: sum(case when Category = 'Financials' then Revenue else 0 end)
Variance:
sum(case when Category = 'Financials' then Revenue else 0 end) -
sum(case when Category = 'Financials' then Revenue else 0 end)
You should also check out @GrantSmith's writeup about how to do period-over-period analysis, which may be helpful for this type of data:
