Forum Discussion
Extracting Hour data values
Hello, I have a table that contains columns like date(including year, month, date, hours), temperature and other columns. I want to analyze the data for specific hours of each day. For example, Temp...
I want to make a visualization using the temperature values of specific hours For example, (from 12:00 - 13:00)for the whole month.
Right, so you would create two columns:
Month = MONTH([Date])
Hour = HOUR([Date])
Then just put both of these in the x-axis and you can drill down.