Need help forming query on Prometheus using Grafana


I am trying to visualize some stuff on Grafana with data coming in from Prometheus.

My goal is to explore daily aggregated trends across long periods of time (what’s the state of light bulb or sensor in a typical day in the past month? for example)

I would like to create either of the following and would appreciate any suggestions on how to make it work:

  1. using a histogram in some way so that the vertical represents a day and the days are stacked one ontop of the other across date range

  2. query the component on specific time of day across date range (such as 08:00 - 09:00 period across N days) - this would form a single vertical line but not show the entire 24 hours of each day - only my specific hour range

Can anyone clue me in as to if and how this can be done ?