Histogram/Bar chart - calculate conditions in dimension or expression

[corumba]

Hello,

I'm trying to create a histogram or bar chart from values in a table similar to that one:

Then what I need as answer for the histogram or bar chart is a table like the following table, in which shows the frequencies of the longest time of each ID.

I used an expression like that for the longest time as a value:

IF(TIME = max(aggr(nodistinct MAX({<some set analysis>} TIME),ID)),max(aggr(nodistinct MAX({<some set analysis>}  TIME),ID)) )

However I've some difficulties to recalculate that in a bar chart or histogram to insert the comparison of time to longest time.

Can anyone help with this case please?