Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I have two time column and I am calculating second using the following syntax, in the bar chart.
=Interval(End_Time - Start_Time,'ss')
I am getting the proper time in second in the chart in numeric format, now I want to print second text in the chart such as
30 sec , instead of 30 .
in the number tab if I change format setting from expression default to interval and put ss second , I did not get the result.
Could you please help me how to get it.
Thank you,
Ashis
Try this?
Dual(Interval(Works,'ss') & ' sec', Interval(Works,'ss'))
Hi Ashis,
Check this. If your problem is still please upload a sample.
Rgds,
Tharindu
Hi Tresesco,
As suggested , I used the following syntax and results are coming like 0.0057060185281443 which is wrong.
=dual(Interval(End_Time - Start_Time,'ss') & ' Sec',Interval(End_Time - Start_Time,'ss'))
is anything I am missing.
As suggested , I used the following syntax and results are coming like 0.0057060185281443 which is wrong.
=dual(Interval(End_Time - Start_Time,'ss') & ' Sec',Interval(End_Time - Start_Time,'ss'))
Is anything I am missing.
Hi,
You are taking as calculated dimension, where as I am calculating it in the expression . I am using different dimensions in my chart. I need to calculate it in expression only and in the chart need to show as 20 sec or 30 sec instead of 20 or 30.
Thank you for your reply.
What you are showing that is correct synthetically. Share me the image using 2 formulas in straight table
see the attached screen shot.
Can you try this? Or i would need application to test
=dual(Interval(End_Time - Start_Time,'hh:mm:ss')*60*60 & ' Sec',Interval(End_Time - Start_Time,'ss'))
This should be 493 sec / 192 sec
same result.