Hi everyone! I have a question regarding charts. I have a bunch of records and I would like to graph them.
I have a date field as the X-axis, which displays fine, and a time field as a Y-axis, which does not. From what I've tried so far, seems like the Y-axis only displays numbers. So the time field that I have set to as the Y-axis, displays the time in seconds. I tried to round that to time, but the closest I've gotten is 1040 (as 10:24am for example). I've tried having the time field as a calculation and displayed as text, but it still does not display correctly. Can someone help me out with this?