Best Of
Re: Help with Beast Mode Formula
I followed your suggestion and converted to a table, used the ticket date for the first column and then put columns for A, B, C, (A+B+C), and the full formula, set all of those to SUM, and the calculations all worked. I was even able to get the summary number to be correct over the selected date range.
Here's a kick in the head: the Powers That Be want it to be a single number so I converted the card back and prepared to let you know it was still broken when, lo and behold, it worked! I saved it and slowly backed away, so now everyone should be happy (except for me: why did this work?!?).
jimsteph
Re: Getting no data in calculation in my beast mode.
I would not use the -1 as that is going to just change it from July 31st to July 30th and is not what you want. I would use this to get the previous month:
LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 1 month))
Also, in your NULLIF function, your 2nd parameter is just inserting a blank. That will be problematic as a denominator. I would rethink what you want your denominator to be for this equation.
Re: Drill down into table
You can create a custom drill down. Follow the images below for the steps:
In your custom drill view create a table card with the fields you listed.
Re: Parameter passing to a URL
You can kind of do this with the pfilter parameter added to the URL, but you'll need to code the link yourself and as far as I know this will not work with variables, or at least I couldn't get it to work with them. Not sure if this is what you're looking for.
Re: Parameter passing to a URL
Hi Ganesh, this is currently possible using pfilters. Here is some documentation on how to use them:
Re: Is it possible to calculate ROAS and WoW change in the same beast mode formula?
Hi @ccc123 ,
Here's my video on how to do rates:
and here's my video on time comparisons:
Just for you or anyone who wants to see for future reference