MarkSnodgrass Coach 
-
Re: How to make my BeastMode dynamic
@WorldWarHulk My bad. I missed that you are looking at 2 different dates to determine the quarter. It will involve a case statement, it can still be dynamic. This should work for you: CASE /*check to…1 -
Re: How to make my BeastMode dynamic
You can use the QUARTER function and the YEAR function eliminate all of your case statement. You could do this: CONCAT('Q',QUARTER(`dt`),' ',YEAR(`dt`))2 -
Re: How to calculate a ratio like 2:1
You can use the formula tile and the concatenate function to build your ratio string like this: CONCAT(`Usedfield`,':',`Newfield`) This would build your string.2 -
Re: Rank based on 2 metrics?
In your OVER clause, you should be able to add ORDER BY and list current run DESC, total current run DESC so that it will sort by current run first and then total current run after that.5 -
Re: Drill down linking to Salesforce
You can link to any url by creating a table card in your drill path and then construct the proper html tag to build the hyperlink. Here is one example of how to do it: https://dojo.domo.com/main/disc…3
