topic Dynamic Division in a row on Dahsboard in Dashboards & Analytics Discussions

Dynamic Division in a row on Dahsboard

hitendrasingh — Mon, 21 Aug 2023 14:00:29 GMT

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.

Thank you.

Re: Dynamic Division in a row on Dahsboard

RADSr — Mon, 21 Aug 2023 14:06:19 GMT

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?

Re: Dynamic Division in a row on Dahsboard

hitendrasingh — Tue, 22 Aug 2023 07:08:14 GMT

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.