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

Reply
Highlighted
Yellow Belt

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.

 

Highlighted
Black Belt

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

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 like any users posts that helped you and accept the ones who solved your issue.**
Announcements
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.