How can we use Strings in Bar Chart Expression

[SatyaPaleti]

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

[tresesco]

Use dual(). PFA

[SatyaPaleti]

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

[tresesco]

=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))

)

[SatyaPaleti]

Thank you so much Tresco

[tresesco]

You would probably want to close the thread by marking 'correct' answer?