Grouping by Hour
Answered
I am currently making dashboard that need to show number of incidents in a day sorted trough hours.
I made it with all the information that I needed but it does not group hourly even when I change my format to Time.
The field is DateTime field.
Am I missing something ?
The same question
Also, if you do have Aggregation for all other columns then you want to make sure that "Sat" is actually returning grouped data. The formatting feature does not actually change the value of "Sat", it only changes what the end use sees. For example, if 7:15 am is the value for one row and 7:31 am for another, those two rows will not be grouped even though you format it to display 07. In this case you will need a calculated field with either freehand SQL
Or use a predefined function:Also, if you do have Aggregation for all other columns then you want to make sure that "Sat" is actually returning grouped data. The formatting feature does not actually change the value of "Sat", it only changes what the end use sees. For example, if 7:15 am is the value for one row and 7:31 am for another, those two rows will not be grouped even though you format it to display 07. In this case you will need a calculated field with either freehand SQL
Or use a predefined function:Are all of your columns aggregated? Each column needs to be in order for the column "Sat" to be grouped. If you can look at the derived SQL you should be able to see what is being grouped. There should only be "Sat". If not then you need to choose an Aggregation like so for all columns but "Sat":
Are all of your columns aggregated? Each column needs to be in order for the column "Sat" to be grouped. If you can look at the derived SQL you should be able to see what is being grouped. There should only be "Sat". If not then you need to choose an Aggregation like so for all columns but "Sat":
Also, if you do have Aggregation for all other columns then you want to make sure that "Sat" is actually returning grouped data. The formatting feature does not actually change the value of "Sat", it only changes what the end use sees. For example, if 7:15 am is the value for one row and 7:31 am for another, those two rows will not be grouped even though you format it to display 07. In this case you will need a calculated field with either freehand SQL
Or use a predefined function:Also, if you do have Aggregation for all other columns then you want to make sure that "Sat" is actually returning grouped data. The formatting feature does not actually change the value of "Sat", it only changes what the end use sees. For example, if 7:15 am is the value for one row and 7:31 am for another, those two rows will not be grouped even though you format it to display 07. In this case you will need a calculated field with either freehand SQL
Or use a predefined function:Replies have been locked on this page!