Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
DEAR TEAM ,
SEE ATTACHED.
WE HAVE X AXES IN FORMAT OF (DD/HH:MM) SHOWING 24 HOURS IN A DAY .
AND AS PER CUSTOMER REQUIREMENT THEY NEED TO SEE X AXIS WITH STEP OF 2 HOURS ONLY .
I:E IF DATE IS 30/11/2017 THEN BEGIN FROM 30/00:00 THEN 30/02:00 ..30/04:00.......30/20:00 ...30/22:00....01/00:00
CAN U PLEASE ADVISE HOW CAN WE HANDLE HOPPING OF 2 HOURS IN X ZES WITH FORMAT OF DD/HH:MM ADDED AS DIMENSION FOR X XSIS.
WHENVER WE DO CONTINIOUS IN PRESENTATION CHART GIVES"" NO NUMERIC VALUES ON CHARTS""
PLEASE HELP TO ACHIVE 2 HOURS STEP IN XZES WITH DATETIMEFORMAT OF DD/HH:MM.
maybe like this
time(round(frac(YOUR_FIELD), 1/12) , 'DD/hh:mm') as Min120Interval
Dear Tim,
This is what we tried ad per your suggestion in load script :
LOAD DISTINCT date(DATE,'MM.DD.YY) AS DATE
time(round(frac(DATE), 1/12) , 'DD/hh:mm') AS DateHOUR.
this DATEHOUR IS USED AS DOMENSION .
Howver in GUI LINE CHART IT IS NOW GIVING ONLY 30/00:00 as values
CAN YOU PLEASE ADVISE
you have to use this function on a time field.
time(round(frac(YOUR_TIME_FIELD), 1/12) , 'DD/hh:mm') AS DateHOUR
Try like:
Date(Round(YOUR_FIELD, 1/12) , 'DD/hh:mm') as Every2Hrs