Forum Discussion
Returning the hour with max count(values)
Hi!
I am trying to get the hour for each day where I have the max ammount of, say, occurrences.
So, I have a row for each occurrence, containing the day, time and type of the occurrence.
I want to show it in a bar graphic with lines "the hour with the max occurrences" for each type.
For example, I have this table:
DAY - HOUR
1 - 8
1 - 8
1 - 9
2 - 8
2 - 10
2 - 10
I want to show in my graph, for each day the amount of occurrences in bars, and a line of the hour where I had the most occurrences.
Day 1 would be the hour 8, while the day 2 would be the hour 10.
I tried with maxx, summarize, calculate, but with no success.
How can I do it?
parry2k I think you misunderstood my problem. I don't want the maximum hour, I want the hour (this can be any hour of the day) with the maximum occurrences. I guess that I will solve this only with a measure, or a couple of them.
Edit1: Maybe if there was an aggregation of mode (statistics) it would work. Speaking of mode, I will try this.
Edit2: Edit1 didn't work :(
Edit3: this works great :D
2 Replies
- binamacFrequent Visitor
parry2k I think you misunderstood my problem. I don't want the maximum hour, I want the hour (this can be any hour of the day) with the maximum occurrences. I guess that I will solve this only with a measure, or a couple of them.
Edit1: Maybe if there was an aggregation of mode (statistics) it would work. Speaking of mode, I will try this.
Edit2: Edit1 didn't work :(
Edit3: this works great :D