KPI Custom Expression

[Marcio Souza]

Hi Everyone,

I'm trying to create a Custom Expression for my KPIs to show the quantity of each attribute on my data table. I have a table with a column called [nvl_complex] that states how complex a task is. I would like to have one KPI for each complexity level rather than relying on the "Title by" allowing me to choose which ones I want to show.

My table is like that:

 

Datatable

 

 

id

value1

value2

nvl_complex

 

 

 

 

1

567

879

 

level 1

 

 

 

2

788

909

level 1

 

 

3

567

986

basic

 

 

4

678

432

level 2

 

 

 

 

 

 

 

 

 

 

 

 

 

I have the following expression: first ( if( [nvl_complex] = "level 1", 1, 0) + count(1) ), but Rather than give me two (2) I'm getting Four(4) that is the total of tuples in my data table. I'm really upset why I didn't get the right value

Thanks in advance.

Marcio

[Marcio Souza]

I have noticed what I was doing wrong. The right expression to achieve the correct value was:

sum ( if( [nvl_complex] = "level 1", 1, 0) )

Cheers,

Marcio