Best Of
Re: Salesforce Advance Connector - Browse Object Tile vs Browse in Bulk Tile
The REST API would be optimized for real-time, small queries. You request a dataset and SalesForce returns the results immediately. Probably has request limits and daily quotes. Use case would be for syncing a single object like pull all accounts or leads daily. For dashboards that don't require a bunch of historial data. i.e. "Give me today's updates."
The Bulk API would be optmized for large scale data extractions. It would create a job, process the request asynchronously, and return the data in chunks. This would handle big datasets (millions) more efficiently than the REST API. You won't get the data instantly because it runs the job to fetch the results. The use case would be for getting history for many years. Like event logs.
Re: Digital Chatter Challenge Winners 🎉
Great news!
I'm happy to be able to participate in this event from Japan.
DOMO ARIGATO,Thank you @AnnaYardley and DOMO .
NRT
Re: New Navigation: Default View by User Group
A Company level Navigation list would also be useful. Specifically, a set of default items that would exist for all new users. Editable after they log in, but it would reduce confusion if the user doesn't have certain access and provide focus when first logging in. It would also allow for custom links to company websites to be added, such as to company IT support.
Marsha
Re: Timezones
You can use the CONVERT_TZ function to convert one timezone to another. You just pass in the field you're wanting to convert, the timezone the data is in and then the timezone you wish to convert to.
CONVERT_TZ(`Timestamp`, 'UTC', 'US/Central')
Re: YOY with Series
I don't think your going to find a simple solution. I think you have to get creative vs using Domo's YOY.
When I do year over year comparisons, I normally use formulas for creating dynamic values: CY, PY, and P2Y (Current Year, Previous Year, and Previous 2 Year).
For P2Y Year to Date, I'll use something like this:
sum(
case when YEAR(`date`) = YEAR(DATE_SUB(CURRENT_DATE(), INTERVAL 2 YEAR))
and `date` <= DATE_SUB(CURRENT_DATE(), INTERVAL 2 YEAR)
then `amount` else 0 end
)
The detail of the formula depends upon what I need to break out. Such as your instrument buckets. And if you need months, you create them dynamic or hard code such as AND MONTH(`date`)=1 for January.
Re: Can Net Income calculation be created in dataflow?
A BeastMode approach would be to change your FinData to be negative for expenses and positive for revenue. Then you could use the table's built in Total row, which has the advantage of being dynamic with filtering.
CASE
WHEN Account Type = 'Revenue' THEN FinData
ELSE -1 * FinData
END
August Community Recap 📚
August was an exciting time in the Community, lots happening. Read up on the major highlights and and monthly stats below.
August Domo Drop release 📡
The highlight of August was the many product enhancements! ICYMI, find all Product release summaries HERE. And the official release notes HERE. Also, this Formula editor updates post from Andrea Henderson (Magic ETL product manager) got lots of love.
Digital Chatter Challenge
The Digital Chatter Challenge was a huge hit! Many of you sparked conversations beyond our Community Forums. Winners and prizes will be announced here by EOW. Stay tuned!
Most Active Discussions in August
These conversations sparked the most engagement—be sure to check them out and chime in with a reaction or comment:
@Ankur, @verytiredgirl, and @USWJA great questions. They've resonated with other community members too. Thank you @ArborRose, @DavidChurchman, and @pauljames,for your answers! rest of the community too. 50+ views on all of these posts.
**FYI – with the recent updates to the Forums, questions automatically filter out all responses to only display the accepted answers. To see the entire conversation, tab over to the "All replies."
Leaderboard Top 3
@ArborRose in 1st place again! Welcome back to the top @GrantSmith and @MichelleH. Thank you for being stellar Coaches. A gift card from Domo will be in your inbox soon.
- @ArborRose, 303 points
- @GrantSmith, 108 points
- @MichelleH, 72 points
Top Idea
This idea from @zacpolin has gotten some great traction. Give it an upvote if you agree, or add additional insight with a comment.
Enable AI chat only on specific dashboards/apps
August Community Member of the Month
@MichelleH has been a Community Coach for a few years now. She's consistently helpful and active, but really showed up this month and answered several questions. It's also worth mentioning, Michelle has 9k reputation points! That's nearly 10x Coach rank. Thank you for being one of Domo's best!
Help me thank and congratulate @MichelleH in the comments below.
Re: Ending a workflow when in parallel logic
Thanks Dan.
I've tested that option and it works as per my requirements, so that's another problem solved!
Re: Is it possible to create case when for ALL?
I believe what @pauljames is saying is that in beast mode each row only evaluates to one value. You can't return "Facebook" and "All" for the same row. Using the formula provided, if the user selects nothing, that effectively means "All".
Re: Jira Cloud Connector - How to Load Data Using the "Issue Query" Report
Just confirmed they are working for me as well! Thank you for letting me know!
