Re: Displaying Duration as a chart

Thilina · 11-16-2021 04:02 AM

Hi all,

So I have a Virtual Column that calculates the duration between 2 DateTime Columns, basically [endtime]-[starttime], my problem is the requirement is to display this duration in a chart, preferably a histogram, but I am unable to do so as histrogram’s Y axis is only count am I doing something wrong is there no other way, what should I do about this, the requirement specifically calls for graphical representation of the durations (so they can quickly pick out records with high durations and look into it)

This is what I get

Any help will be greatly appreciated,
Thank you

SkrOYC

Post the table schema as well as a screenshot from the chart’s config

Thilina

Hope these helps @SkrOYC

SkrOYC

Try Column Series chart

Thilina

Then this is the result, honestly chart view has been the bane of my existence could never get it to do what I wanted @SkrOYC

Duration is blank, is this due to duration being calculated in a Virtual Column?

SkrOYC

Personally, I translate duration to a decimal (01:30:00 to 1,5 for example) in order to see it on a chart.
Also, charting is not so good on AppSheet.
It’s replacement is on development.
You could give it a try

Thilina

Please do tell what kind of expression you use to turn a duration to a decimal? this could prove useful in the future thank you anyways for trying

SkrOYC

It is the simplest one

TOTALMINUTES([HOURS])/60

Thilina

This was quite helpful thank you very much ❤️