I have two fields:
Text login duration 18:14:42 (18 hours, 14 minutes, 42 seconds)
Numeric login duration 18.25 hours
I have a bar graph for the numeric login duration which shows the numeric login duration for the label. I want to put the text login duration as a label in parenthesis behind the numeric login duration on the bar graph, so it would look something like this:
John Doe 18.25 (18:14:42)
Can someone advise how I would do this?
You can do this by creating a calculated field similar to the following:
left([Numeric login duration], 5) + " (" + left([Text login duration], 8) + ")"
Hope this helps!