Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all.
I am currently hosting a file that is seldom being updated by the user. They wanted to display in a KPI view the count of new record added.
For example:
Records are until August 31 2019. Then I added 1 record on September 2 2019. We wanted to display that there is 1 new record added.
Appreciate your help on this.
Hi,
What I will suggest is, if the old data is coming from QVD file, you can create a flag (a field in the script) with value of 0 & 1.
Where the old records will have value of zero (0) and new record will have value of 1. Then in UI you can have the expression for your KPI as
COUNT( {< %OldNewRecord ={1}>} [%AllData])
If you have timestamp from datasource you might also want to use last reload time as a determinants to determine which records is new and old.
Your script needs to look something like this below.
DataTable:
LOAD fld1, fld2, fld3 ......, 0 AS %OldNewRecord FROM [lib://FolderConnection/myfile.qvd](QVD);
CONCATENATE(DataTable)
LOAD fld1, fld2, fld3 ......, 1 AS %OldNewRecord FROM .....DataSource;
STORE DataTable INTO [lib://FolderConnection/myfile.qvd](QVD);
Hi,
What I will suggest is, if the old data is coming from QVD file, you can create a flag (a field in the script) with value of 0 & 1.
Where the old records will have value of zero (0) and new record will have value of 1. Then in UI you can have the expression for your KPI as
COUNT( {< %OldNewRecord ={1}>} [%AllData])
If you have timestamp from datasource you might also want to use last reload time as a determinants to determine which records is new and old.
Your script needs to look something like this below.
DataTable:
LOAD fld1, fld2, fld3 ......, 0 AS %OldNewRecord FROM [lib://FolderConnection/myfile.qvd](QVD);
CONCATENATE(DataTable)
LOAD fld1, fld2, fld3 ......, 1 AS %OldNewRecord FROM .....DataSource;
STORE DataTable INTO [lib://FolderConnection/myfile.qvd](QVD);