Jump to content


Fabrizio Varchetta

Recommended Posts

I have a kpi depending on a property setting (check-box/dropdown list). Then in the check-box list i have two different value: a, b (corresponding to the values in column propertycolumn).

Depending on this value i want to calculate a kpi value in this way: SUM of the amaunt with propertycolumn = DocumentProperty("property1") (a or b) / sum of the total amount (propertycolumn = a + propertycolumn =b).


If i do: Data -> Limit data using expression [property1 column]=DocumentProperty("property1") i can sum only on the filterd values. I.e

If i remove Limit data using expression i have two different KPIs (but i want only one kpi depending on the checkbox selected value).



property1 Amaunt

a 150

b 130

b 110

a 210



Drop-down list: a or b

Link to comment
Share on other sites

I could do it via a calculated column. Say you have the iris dataset and you want to show the KPI for the sum of Sepal_Length depending on the value of Species (setosa, versicolor or virginica).

You could define a new calculated column like this (where selspecies is your drop-down document property):


case when [species]='${selspecies}' then [sepal_Length] end

then define the KPI as:

Sum([sepal_Length_filtered]) / Sum([sepal_Length])

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...