Best Of
Re: August 2023 Community Forum Highlights
Congratulations everyone! Thanks for making this an awesome community.
Re: August 2023 Community Forum Highlights
Awesome work @DavidChurchman and everyone else highlighted in this post. We are SO GRATEFUL for all you are doing to make the Domo Community amazing. Thank you!
Re: How to subtract sales tax from certain rows for sales revenue dashboard?
Hi Leon,
You would create a new beastmode using the following:
CASE WHEN `StatusId` = 60 THEN `TotalPrice` - `EstimatedTax` ELSE `TotalPrice` END
Here is a reference for questions around Beast Modes:
Re: Is there a way to reference a segment in a BeastMode?
@kofagerburg you might consider using the comparative fill gauge to show this difference. It has the ability to compare the difference between two different fields, which is what you are wanting to do. Here's the KB article for it.
https://domohelp.domo.com/hc/en-us/articles/360042924414-Comparative-Fill-Gauge
Re: Distinct Count of Donations and Distinct Count of Donors with those Distinct Count of Donations
One other approach would be to have a few common, preselected date ranges that will be used and then you can use Magic ETL to produce the groupings based on those date ranges. Users wouldn't be able to select any date range, but they'd at least have some options.