Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikey
Contributor II
Contributor II

Calendar Range

I need to create a calendar  data range picker chart to display data based on most recent Timestamp, of each day.

In Date picker, each day it should pick most recent timestamp and display the other record also. 

Extract,migrated,transform, load should be of KPI chart. I had attached sample dashboard display for reference.

BATCH_DATE BATCHID MIGRATED TRANSFORMS LOADS EXTRACT INSERT_TIMESTAMP
04/20/2022 321 463 - 3 - 2022-04-20 15:26:30.26302630
04/20/2022 401 449 - 2 917 2022-04-20 15:26:30.26302630
04/19/2022 281 1128 - 1 - 2022-04-19 17:17:26.17261726
04/19/2022 361 1019 - 2 2150 2022-04-19 17:17:26.17261726
04/19/2022 261 - - 1129 - 2022-04-19 14:16:18.16181618
04/19/2022 341 - - 1021 2150 2022-04-19 14:16:18.16181618

 

1. for date picker by default it show the sum of  all most recent timestamp of the day,

ex: 463+1128 = 1591

2. if we select other days, it should display the sum of most recent timestamp of that particular day.

3. For example: on 04/19, we have 4 records with  different timestamp, but by default it should show only recent timestamp of the day

4. 04/20, there is no data present, so it should display as zero for all KPi's

Labels (1)
  • SaaS

1 Reply
vikey
Contributor II
Contributor II
Author

Can anyone please help me on this its little urgent. Thanks in advance!