I have a slider_object to control the Display of values in my Chart:
The Chart has several time-related dimensions (month, calweek, date, hour) and by using the slider, the user can choose to look at only the time_intervals where the Expression in the Chart is over a certain treshold.
The slider_object has a variable max_value: The max value is, dependent on the currently active Dimension (month, cw, day or hour), the max value there is to Display. The steps are automatic, always starting at 0.
Just to check the results, I would like to know now which is the Dimension_point (time_interval) where that max_value was found - how can I do that?
My formula for the max_value is >> max(aggr(sum(Counterfield), Month)) << -> This works and Returns me the max value of the Expression within the Limits of my Dimension "Month" - now I'd like to know the month where the formula found this max_value - how to do that? I'm at a loss here.
I don't get it - I have done some work on Scripting_level in the meantime and just now I'm back to the GUI.
I can calculate the max value in my Chart and set it for my slider and I can identify which month it has been found in using your formula. But I cannot do the same for the min value - I can calculate that, too, but I cannot identify the month that was found in.
