topic Replace() function not working in Bar Chart in App Development

Replace() function not working in Bar Chart

Aryasmank — Tue, 13 Dec 2022 10:15:11 GMT

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

Re: Replace() function not working in Bar Chart

Or — Tue, 13 Dec 2022 11:59:32 GMT

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.

Re: Replace() function not working in Bar Chart

QFabian — Tue, 13 Dec 2022 12:53:17 GMT

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

Re: Replace() function not working in Bar Chart

Aryasmank — Wed, 14 Dec 2022 06:58:22 GMT

Hi,

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