How to access a particular column value in beast mode calculation?

salience.JPG

I want to calculate Salience =  This Year/ Total ( 500,000 / 980,000 )

and based on filters Total value will be dynamic

is it possible to access 980,000 to access in beast mode? Please tell me how to write a beast mode for this.

 

Comments

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟤

    Unfortunately, you can't do totals like this in beast mode. You will need to do this in SQL or Magic ETL. It would be a nice enhancement if beast mode could eventually grab these totals as it is a common question.

This discussion has been closed.