Returning the hour with max count(values)

[binamac]

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]

@binamac when you drop HOUR on value section bar chart, just change aggregation to MAX instead of SUM

[binamac · Accepted solution]

@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 😄