Displaying Duration as a chart

AppSheet AppSheet Q&A
,
1

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

3X_3_9_39929f0d10b2502847f7e6fec4dc15bbc82072fa.png
3X_3_9_39929f0d10b2502847f7e6fec4dc15bbc82072fa.png362×635 15.4 KB

Any help will be greatly appreciated,
Thank you

2

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

3

3X_3_4_34ccf0ceae65656db02d8b9495deec13de7f05a5.png
3X_3_4_34ccf0ceae65656db02d8b9495deec13de7f05a5.png1563×744 67.8 KB

3X_6_5_651e5a36ac3e0e2e6750364d5812158f91c652b4.png
3X_6_5_651e5a36ac3e0e2e6750364d5812158f91c652b4.png1537×468 53.5 KB

3X_1_6_1632821376f12fe19a1cd58a5a6cfd0fc4f39fea.png
3X_1_6_1632821376f12fe19a1cd58a5a6cfd0fc4f39fea.png919×328 23.4 KB

3X_d_2_d2f27039d0d20c64113bff7ea31fd77a4997f0cf.png
3X_d_2_d2f27039d0d20c64113bff7ea31fd77a4997f0cf.png941×745 34.8 KB

3X_f_e_fe3c7fad8ecfcd391fbdc3b104c4955707ac112b.png
3X_f_e_fe3c7fad8ecfcd391fbdc3b104c4955707ac112b.png1151×748 51.1 KB

Hope these helps @SkrOYC

4

Try Column Series chart

5

3X_4_7_4797e9c6a8c182a220075dbf93d60f67e4a79b5b.png
3X_4_7_4797e9c6a8c182a220075dbf93d60f67e4a79b5b.png1614×769 68.3 KB

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?

6

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

[New Charts in AppSheet applications - in Preview Program](https://community.appsheet.com/t/new-charts-in-appsheet-applications-in-preview-program/43287) Announcements

The following feature has been added to the Preview Program. Feel free to test the feature and report issues or possible improvements in this thread. App Creators can now make use of our new chart editor and the new and improved charts it can create. There are still features to be added before general availability, and the new charts should not be used in production apps until general availability as they may be unstable in the future. We’ve been trying to create a charting experience that all…

1 Like
7

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

8

It is the simplest one

TOTALMINUTES([HOURS])/60
4 Likes
9

This was quite helpful thank you very much <3

1 Like