2 Replies Latest reply on Nov 9, 2018 1:28 AM by Rajesh Kota

# Determine maximum of average values

Hello everyone,

I have multiple stations in my view. i.e from Station 1 to Station 5 and i have related cycle time along with the date filter.

I am taking average cycle time of individual station and showing in a dashboard.

Now i need to compare all the remaining stations (2,3,4,5) with station 1 and if the avg.cycle time is higher than station 1, then i should highlight it by changing the digit color and dynamically place the symbol beside the station title as well.

Is there any workaround available for the above requirement? I have attached TWBX workbook.

Any help would be appreciated.

• ###### 1. Re: Determine maximum of average values

2)Create a calculation like below to identify which station is having max avg cycle time

AVG([Cycle Time]) = MAX({MAX({ FIXED [Station Name]: AVG([Cycle Time])})})

above calculation gives you True/False (True where you have max avg cycle time) sheet 4 in this case.

use this calculation in colour to represent the max one like shown below.

You can use this calculation to place that red image as well in each sheet (5 sheets with that image one for each main sheet - use this calculation as filter only to display that image where the condition is matched)

• ###### 2. Re: Determine maximum of average values

Thank you Hima Vardhan.