Best Of
Re: Count Distinct with Or Case Statement in Beast Mode
I'm not sure this is possible in beast mode, since you want to both count distinct values of a column and also dedupe an already aggregated column? I think you might have to use ETL to create IDs for the guests/spouses so you can count them correctly. That's just my two cents, though, hopefully someone else has an easier solution!
Re: Count Distinct with Or Case Statement in Beast Mode
Did you adjust the beastmode proposed ? or are you still using the exact code… Im asking because I see your Product Name value = 'Washington Summit - Guest/Spouse Registration' instead of just 'Guest/Spouse Registration'
you will need to either match the exact wording or adjust the product name within the beastmode to take only in consideration whats after the dash 'Guest/Spouse Registration' …
this way you will COUNT(DISTINCT .. )everything except for when the product name is the guest registration to do a COUNT(..)
Godiepi
Re: Allow for multiple calendars on Dashboard e.g. Fiscal, Business, Gregorian, Custom
this sort of thing would be a game changer for us. I also reference my other idea which allows you to change the start day of the week for the default calendar.
Jones01
Re: Incorrect subtotals on the cards
@Dev_ Subtotals of ratio calculations can show an unexpected result if the beast mode does not specify the aggregation. So, if your beast mode is Labor Cost / Labor Hrs it is calculating the ratio for each row individually and the subtotal aggregates the results. If you want your subtotal to represent the ratio of the other columns' subtotals, then you will need to aggregate each component individually within your beast mode like this: SUM(Labor Cost) / SUM(Labor Hrs)
Re: Sharing custom themes in App Studio
I'm also seeing this… I see that I can save a Custom Theme from within an AppStudio app, but I'm not seeing my Custom Theme in my options when I create or edit another app.
I don't see anything regarding sharing these Custom Themes with other users in the KB, and have not heard any announcement or talk about this.
Thanks for posting, made me think about another Idea I had, let me know what you think of this:
Sharing custom themes in App Studio
Hey all! I want to share a custom theme I've built with our company's branding for all to use in App Studio, but I don't see the option to do that. Am I missing something or is this feature not available?
scollins
Re: How do you change the field used for the date range on a card?
I feel like it is a bug that it does this and could be worth reporting to Domo. The workaround I have found is that Domo will use the last date field added to your table card as the date range field. So, if the field that you want to use as your date range is not being used, remove it from your table card and then add it back and it should be the one selected.
Hope this helps.
Re: Word cloud in DOMO
I use the calendar because it is an easy way to have a built in incrementing list of numbers (1,2,3,etc.). You could just have an Excel file or a Webform that has a list of numbers, but I thought I would just use what is already available.
Re: Congrats to our newest Community Coach: @JasonAltenburg! 🥳
Way to go @JasonAltenburg ! Well deserved! You have been helping people for a long time and are always very insightful!
Re: Create Nested Beast Mode that nest more than two levels
Hey @Sam_Donabedian, it looks like this is a duplicate of this previous post. Thanks for posting though and sharing your feedback!
