Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have one requirement. How can we show Strings in Bar Chart Expression. I am having data which shows Duration. I want to Include strings with numbers like 'Days','Hours','Minutes'
if you see the Image at Acer I am getting 13478:7:18 I want to see this ca13478 Days 7 Hours 18 Mins
Below is the expression I am using
=Floor(sum(Duration)/60/8) &':'& Interval(Frac(sum(Duration)/60/8)/3, 'h') & ':' &
Num(SubField(Interval(Frac(sum(Duration)/60/8)/3, 'h:mm'), ':', -1))
For reference you can find attached data & attached qvw. Can any one please help me on this
Thanks and Regards,
Satya
Use dual(). PFA
Hi Tresco,
Thank you for responce. I have tried writing dual but missing some where. Could you please reply with expression you are writing
Thanks and Regards,
Satya
=Dual(
Floor(sum(Duration)/60/8) &' Days '& Interval(Frac(sum(Duration)/60/8)/3, 'h') & ' Hours ' &
Num(SubField(Interval(Frac(sum(Duration)/60/8)/3, 'h:mm'), ':', -1)) & ' Mins ',
Floor(sum(Duration)/60/8) &':'& Interval(Frac(sum(Duration)/60/8)/3, 'h') & ':' &
Num(SubField(Interval(Frac(sum(Duration)/60/8)/3, 'h:mm'), ':', -1))
)
Thank you so much Tresco
You would probably want to close the thread by marking 'correct' answer?