Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can anyone please help me on this its little urgent. Thanks in advance!