Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a table in which I have a field as duration_mc which is in the format hh:mm:ss.
I need to represent this time in the form of mini bar against each value of time.
currently I am getting same bar for all the time values, the length of the bar is not increasing as per the value of time.
Below is the snapshot attached.
here as we can see the bar length for o seconds as well as 18 seconds is same, which needs to be different.
What changes i should apply to the expression in order to achieve this.
Kindly help.
Thanks
Hi Jayati,
Try this:
Repeat('▮',round(sum(duration_mc)/max(total sum(duraction_mc)))*10)
Jordy
Climber
Hi, I tried this expression , but I am not getting any bar chart ,it is coming as null.
Below is the snapshot
I forgot the aggr(). Use this one:
Repeat('▮',round(sum(duration_mc)/max(total aggr(sum(duration_mc),duration_mc))*10))
Jordy
Climber