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

user064197
user064197
in Card Building

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.

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
This discussion has been closed.

Categories