Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am getting time difference in seconds from data base i need to convert into HH:MM
Thank you bro,
i don't want to show seconds just HH:MM
i use those expressions it is showing like 12:76 ..i dont want to show 76 it should be below 60
Would you be able to share an image of what you have right now? You can try something like this if you have seconds like this 360 and you want to show 00:06
=Interval(Interval#(360, 's'), 'hh:mm')
Sunny thank you
it works i have to add KPI color like more than 2 hours i want to show as red color
can you please help me with KPI color
Should be like this
If(Interval#(FieldName, 's') > MakeTime(2), Red())
i tried
=If(Interval#(AVG(VOYAGE_ARR_TO_CONTAINER_DISCHARGE), 's') > MakeTime(2), Red(),Green())
08:22
showing in Green color it should be red
What value do you get for Avg(VOYAGE_ARR_TO_CONTAINER_DISCHARGE)?
i get seconds between tow dates
Hahahaha what is the value my friend? Is it giving you a value of less than 7200 (60*60*2)