Skip to main content

Dear community,

 

This is a quick one. I have a Boolean metric with one dimension (Employee). The metric shows a list of employees with the tick box marked.

I am struggling to generate a KPI that show me the number of employees in the list. What’s the best way to approach this outcome?

Many thanks in advance :D

 

Metric: if(Transaction List. Bolean property'/by firstnonblank: Same Transaction List.Employee Name],
true)

 

I obtain a list like

 

Hi Guillermo,

 

Two ways:

You can do a BY COUNT on the boolean metric:

MetriccBY COUNT:your other metric of dimension]

 

You can create in your table, at the same dimensionality of your boolean, a number metric that does IF(Boolean,1) and then you can use that in your formula; CounterMetriciBy SUM:your dimensions]

You can also do the count directly in your formula:

If(boolean,1)1BY SUM:your dimensions]

 

 

 

Reply


Ask your question here!

Terms & ConditionsCookie settings