KPI

[vikey]

How to find out the KPI value as per the below query:

SELECT COUNT(*) FROM "XYZ" WHERE Joining Status = ('Not Joined') AND BATCH_ID = (select max(BATCHID) from "ABC") ;

Script:

LOAD

BATCH_ID,

CREATE_TIMESTAMP;

FROM "abc”;

LOAD

BATCHID,

                Emp id,

                Joining Status,

FROM “xyz”;

Sample data :

ABC table:

Batch_ID	Create_TimeStamp
1	20-JAN-22 03.45.44.000000000 PM
2	03-FEB-22 01.54.29.000000000 PM

xyz table:

BatchID	emp id	status
1	460	Joined
1	461	not Joined
2	462	not Joined
2	463	yet to join
2	464	not Joined
1	465	yet to join

[vikey]

HI Sebb,

in one table it is BATCH_ID and in other it is BATCHID, but they are same, where BATCHiD Is like a foreign key.

 and yes i am looking for the same as you shared in pie chart, if possible can i  have the expression for  Pie chart  please. and can i get the condition for BATCHID= 'USER SELECTED FROM BATCHID from ABC table.

[SBDataspark]

Hi Vikey,

Maybe the attached QVD can help you.

Kind regards,

Sebb

[vikey]

Thank you, one more help, i want to create filter chart based on Create_TimeStamp, in that by default  it should show the max(Create_TimeStamp) with other Create_TimeStamp values as a dropvalue, based on the selection timestamp dashboard values has to change.

I had attached the QVF for your reference.