Hourly displaying of data

  1. How can we display all the hours of a day with their values in visualisation.

There's a very detailed guide on creating this visualization in an older discuss post that might be just what you're looking for! The advice and guidance in that post was given by one of our visualizations developers and I'd struggle to give better advice than that! You'll need to use a different visualization though, using the Time Series Visual Builder (abbreviated as TSVB).

Note that using TSVB is a bit of a learning curve but it is a very powerful visualization builder. There's more info on using it here