Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using following expression for creating a mini bar chart in the table for my duration field which is in the format hh:mm:ss
repeat('█',
rangemax(rangemin( sum(duration_field), 10),0)
)
but I getting sum as 0, due to which the bar is not appearing.
kindly help.
Did you check to make sure that Sum(duration_field) is a number between 0 and 10?
Under text object i took sum(duration_field) and change its format to number, and I am getting sum as 14. and in duration format sum is coming as 340:32:33 in text object , but when I am using sum function along with rangemax and min in the table, there under TOTALS the sum is coming as 0, because of which graph are not appearing .
i have a table with 2 field as
duration_field duration with bar(function used here as shown above)
total 340:32:33 total 0
00:00:00
00:00:18 -
and so on....
against 00:00:18, i need to represent this particular time in the form of mini graph
You should get a repeat of 10. Your syntax looks OK. Try the expression
=rangemax(rangemin( sum(duration_field), 10),0)
in the table in question.