When you take out your data from the database you need convert the DATE to a NUMBER format, there will be multiple ways on how to achieve the conversion. One way of doing it is to parse the values HH:MM:SS like the below:
!:SET &LAG_VALUE_IN_TIME# = "HH:MM:SS"
:DEFINE &LAG_VALUE_IN_TIME_ARRAY#,STRING, 3
:FILL &LAG_VALUE_IN_TIME_ARRAY#[] = STR_SPLIT(&LAG_VALUE_IN_TIME#,":")
!:DEFINE
:SET &LAG_VALUE_IN_HH# = &LAG_VALUE_IN_TIME_ARRAY#[1]
: PRINT LAG VALUE IN HOURS: &LAG_VALUE_IN_HH#
:SET &LAG_VALUE_IN_MM# = &LAG_VALUE_IN_TIME_ARRAY#[2]
: PRINT LAG VALUE IN MINUTES: &LAG_VALUE_IN_MM#
:SET &LAG_VALUE_IN_SS# = &LAG_VALUE_IN_TIME_ARRAY#[3]
: PRINT LAG VALUE IN SECONDS: &LAG_VALUE_IN_SS#
!COMPUTE LAG TIME IN MINUTES
!
:SET &LAG_VALUE_IN_DAY# = &LAG_VALUE_IN_DAY# * 24 * 60
:SET &LAG_VALUE_IN_HH# = &LAG_VALUE_IN_HH# * 60
:SET &DASHBOARD_LAG_VALUE# = &LAG_VALUE_IN_DAY#+ &LAG_VALUE_IN_HH# + &LAG_VALUE_IN_SS#
:SET &DASHBOARD_LAG_VALUE# = FORMAT(&DASHBOARD_LAG_VALUE#, "0000")
: PRINT DASHBOARD LAG VALUE: &DASHBOARD_LAG_VALUE#
Above is an example to depict the LAG Time (Actual and Allowed) values.
Original Message:
Sent: 06-30-2020 04:56 AM
From: Benedikt Weiler
Subject: Analytics Dashboard
Dear all,
currently i try to create a Dashboard which should show me the End time of a specific JOBP/TASK.
I'll take the data out of the Database and put it into a VARA.
If i create a Dashboard -> Analytics -> Vara To Chart and i choose the above mentioned VARA, nothing is displayed. I don't understand why.
On the x-axis i want to have the execution Date and on the y-axis i want to have the End Time.
Is it because of the format of the time? if yes, what do i have to change to get it done?
Hopefully someone is able to help
Thanks in advance.
regards,
Ben