topic Re: Measure in KPI in Dashboards & Analytics Discussions

Measure in KPI

KHK — Mon, 26 Jun 2023 18:41:23 GMT

Hi,

I have created below measure formula in business view using string to count the number of rows of string.

Requirement: count(table.name = "Yes").

Written formula in Business View:

if(

table.name = "Yes",

count(

table.name

)

Case 1:

If i drag this column in Listing table am getting below values. the formula is counting 0 and 1 records, count of records is increasing. I want only condition satisfied records.

Case2:

If drag this formula column in KPI , it is showing zero value. Please let me know i want to show no of records count in KPI for above condition.

Re: Measure in KPI

KHK — Mon, 26 Jun 2023 18:59:03 GMT

I want to use above count of rows column in another formula column to divide the value.

Re: Measure in KPI

anurag — Mon, 26 Jun 2023 19:11:09 GMT

Try this formula:

sum(

if ( table.name = "Yes", 1, 0)

)

Re: Measure in KPI

KHK — Wed, 28 Jun 2023 05:49:57 GMT

Thank you for your Help.