Forum Discussion

binamac's avatar
binamac
Frequent Visitor
7 years ago
Solved

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

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

     

    • binamac's avatar
      binamac
      Frequent 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