cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic Division in a row on Dahsboard

hitendrasingh
Cosmonaut

Hi, I'm looking for a solution on dynamic row division to be performed in top of dashboard in insight. The divided number should change according to filter selected. I have attached the file for reference. 

I want to add a row in the aggregated table where it must take the number from existing rows and divide it according to the requirement. 

hitendrasingh_0-1692626409212.png

Thank you.

2 REPLIES 2

RADSr
Captain
Captain

I think what you want is a presentation variable integrated into your formula column something like:

( col1 + col2 ) / ?PV_divisior    

Or are you looking for a prompt with a pre-defined set of divisors?   

-- IncortaOne@PMsquare.com --

Hi, I am looking for solution on row 6 ( calculated 1 ) result will be in column B6 is division of B4/B5 Or B4/B2 base on the user need.

Is there any way to add calculated row inside the current insight based on the user need.