How to Filter Data Based on a Time Range?

Need help
1

hello to all!

i am making an app that tracks certain transactions that users take. i would like to store those transactions on a grid, that’ll show me the transactions with a range of time of it happening.

for example, i would want a grid chart that showed me the transactions that took plcace from, say, 7-9AM, 9-11AM, etc etc

i’ve already got the time and date store when the transactions are made, but how can i get it so that a chart shows me only those that happen within a certain span of time?

thanks ahead :smile:

2

hi, this should be easy but for me it does not work. can someone else confirm or show their method:

grafik
grafik1118×737 56.2 KB

it seems grouped by only works for days but not fractions of a day like hours. 2 hours should be around 0.08 of a day but the chart shows the same as 1 per day.

grafik
grafik829×440 31.6 KB

I used the chart element plugin.

in theory you should be able to do what i did for transactions instead of for users.