Replace() function not working in Bar Chart

[Aryasmank]

Hi,

I'm using a replace() in a bar chart , but its not working , giving result as "The chart is not displayed because it contains only undefined values."  but same expression is working fine in table.

Expression:  repalce(replace(replace(Interval(Final-initial, 'D@ hh# mm&'),'@','days'),'#','hours'),'&','Minutes')

I want to display the time difference a x days y hours z minutes in bar chart.

Please suggest any suggestion.

Thanks,

Mayank

[Or]

Looks like you're replacing the underlying numeric value with a text interpretation of that value, but a bar chart needs numeric values, not strings, on its value axis. You'll have to keep the numeric value to get a result.

[QFabian]

Hi!, you can take that formula and put it in the script to create a new field for using as dimension.

[Aryasmank]

Hi,

Thanks for response, but I need this as a measure not dimension.