Hello Dojo!
My question is whether we can create a beast mode calculation to index values from multiple audiences. For example, we want to create a beast mode that calculates the quotient of two dataset fields (ex. `Total Devices`/`Total Devices`).
To my understanding, the two dataset fields listed above always come from the same data row. Is there a way pull in a value from a specificied data row?
Ex. (`Total Devices` from ID=11111) / (`Total Devices` from ID=22222)
Lastly, is there a way to make a variable ID selection that allows a user to see calculations that reflect their filtered view?
Ex. If a user selects the filters ID=11111 & ID=xxxxx, the beast mode calculates (`Total Devices` from ID=11111) / (`Total Devices` from ID=xxxxx),
if a user selects the filters ID=11111 & ID=yyyyy, the beast mode calculates (`Total Devices` from ID=11111) / (`Total Devices` from ID=yyyyy.
Any help you can provide would be greatly appreciated.
Thank you,
Alex
4FRONT (team4front.domo.com)