topic Re: KPI Expression checking in App Development

KPI Expression checking

Thu, 28 Apr 2016 06:10:20 GMT

Hi Folks,

Please find the below snippets.

when user selects Temp Filter as "Critical" or "Hot", the first KPI (Type1 Critical/Hot) no need to vary. It will be fixed.

In the below pics it was varying the values.

Please find the below expression, i am using for this KPI.(Type1 Critical/Hot)

=If(Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket)>0,

Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket))

How to static it?

MK_QSL — Thu, 28 Apr 2016 06:22:41 GMT

Sorry but what is your question?

Thu, 28 Apr 2016 06:30:32 GMT

Hi Manish,

I want to show it as Static.

Ex:- If Temp Filter selected as "Critical" - 10 and "Hot"-10

MK_QSL — Thu, 28 Apr 2016 07:46:47 GMT

Try one of this..

=If(Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max({<Temp>}WeekNo)-12)<=$(=Max({<Temp>}WeekNo))"}>}Ticket)>0,

Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max({<Temp>}WeekNo)-12)<=$(=Max({<Temp>}WeekNo))"}>}Ticket))

=If(Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max({1<Temp>}WeekNo)-12)<=$(=Max({1<Temp>}WeekNo))"}>}Ticket)>0,

Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max({1<Temp>}WeekNo)-12)<=$(=Max({1<Temp>}WeekNo))"}>}Ticket))

=If(Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max({1}WeekNo)-12)<=$(=Max({1}WeekNo))"}>}Ticket)>0,

Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max({1}WeekNo)-12)<=$(=Max({1}WeekNo))"}>}Ticket))

Thu, 28 Apr 2016 08:57:18 GMT

Thank you its working fine for Temp Filter.

If i select Type filter as "Type2" - Type1 Critical/Hot KPI is should show the value is '-'.

Can you help with this..

MK_QSL — Thu, 28 Apr 2016 08:59:02 GMT

What is the exact field name?

Which expression works find from above... 1st 2nd or 3rd?

Thu, 28 Apr 2016 09:16:11 GMT

I tried with 1st one, its working fine.

The field name is "Type"

MK_QSL — Thu, 28 Apr 2016 09:18:11 GMT

if possible provide sample data..

or try

=If(Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max({<Temp=,Type>}WeekNo)-12)<=$(=Max({<Temp=,Type>}WeekNo))"}>}Ticket)>0,

Count({1<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max({<Temp=,Type>}WeekNo)-12)<=$(=Max({<Temp=,Type>}WeekNo))"}>}Ticket))