KPI Target Days met

[ZigaD]

Hi

have a small Q for your. need to do KPI, where need to be calculated how many invoices was issued below X days. all invoices below or same as X days are on target.
My data are only to parametrs A as date of order and B date of issue day.

thank you for you assistance

[Kushal_Chawda · Accepted solution]

Create a day field in script

LOAD *,Date_of_isse - Date_of_order as Days

FROM Data.qvd(qvd);

Then you can create KPI using  below expression

=Count({<Days ={"<30"}>} InvoiceNo)

[ZigaD]

Hi

got this error

[Kushal_Chawda]

Which error?

[ZigaD]

pardon this one

[Kushal_Chawda]

Hi,

I had just given an example. You should use your actual data source  instead of what I have used.

[ZigaD]

i did and also change column names to yours but still the same outcome

in data model view i can see data and i can also use it in analaysis screen

[ZigaD]

hi

found solution with only your formula.

=Count({<NetDays={"<=2"}>} InvoiceNo)

where i add one more column in excel with function NetWorkingDays

appriciate your help on this topic

[Kushal_Chawda]

Please mark the appropriate answer as correct So that others can refer for the same problem