Best Of
Re: Cant get the percentage of the total!!!
Have you tried using OVER() ?
Here's an example I used for the included screen shot.
SUM(`Extended Price`) / SUM(SUM(`Extended Price`)) OVER()
swagner
Re: Free Domo Upgrades
Hi @Fadem, it's also worth having a look through the list of product features [https://www.domo.com/product/new-features#/] to understand what would be best for your needs.
amehdad
Changing Interactions on Card Drill Paths
It would be great if you could set the interactions on a drill path separate from the main card, so you could have a card drill in place and then have the drill card set interaction filters.
TO_CHAR / Formatting functions in beast modes
There's may times when I need to do a custom summary number that's concatenated with other strings causing me to lose the ability to format the number. So I have to write a long beast mode just to format the number correctly. Like https://dojo.domo.com/discussion/52685/domo-idea-exchange-beast-modes-abbreviated-summary-number#latest or https://dojo.domo.com/discussion/52677/domo-ideas-conference-beast-modes-number-formatting#latest. It'd be great if we had the option to call a function to the the formatting like TO_CHAR from the SQL world to pass in a value and format string to properly format values as a string instead of these long beast modes.
Re: How to delete data of a domo dataset
There's a hidden function on DOMO's dataset. If you add ?_f=dataRepair to the end of a dataset url, new tab called Data Repair will pop up. In there, you can see all the uploaded data versions. If you want to clear the dataset, just delete all the versions.
floramc