如何在Business Objects Web Intelligence中获取并动态展示最大最小病房

Hey there! Let's figure out how to dynamically display the max and min value wards in your Web Intelligence 4.2 report exactly as you need it. Here are two reliable methods to achieve that:

This approach is great if you want to keep things flexible and use a single block to show both wards.

• Step 1: First, create variables to capture your global max and min values
  • For the maximum value: Make a variable named Max Ward Value with this formula (replace [Your Value Measure] with your actual numeric field):

    =Max([Your Value Measure]) In Report
    

  • For the minimum value: Create a variable named Min Ward Value using:

    =Min([Your Value Measure]) In Report
    

• Step 2: Make a flag to identify which wards to show
  • Create a variable called Display Ward? with this logic:

    =If([Your Value Measure] = [Max Ward Value] Or [Your Value Measure] = [Min Ward Value]; "Yes"; "No")
    

• Step 3: Apply the filter to your report block
  • Drag the Display Ward? variable into your report filter panel, then set it to equal Yes. This will automatically hide all wards except the ones with max and min values.
• Step 4: Tweak the formatting
  • Add labels like "Maximum Ward" and "Minimum Ward" next to each entry (you can use text boxes or create concatenated variables like ="Maximum Ward: " + [Ward Name] if you want it all in one cell).

If you prefer separate blocks or just want to pull the ward names directly without filtering a full table, this method works perfectly.

• Option A: Use ranked blocks
  • For the maximum ward: Duplicate your existing table, right-click the value column → Rank → choose Top and enter 1. This will only show the ward with the highest value.
  • For the minimum ward: Make another duplicate, right-click the value column → Rank → choose Bottom and enter 1. Now you have two small blocks showing exactly what you need—arrange them side by side or stack them to match your desired layout.
• Option B: Pull ward names directly into text variables
  • Create a variable for the max ward name:

    =[Ward Name] Where([Your Value Measure] = Max([Your Value Measure]) In Report)
    

  • Create a variable for the min ward name:

    =[Ward Name] Where([Your Value Measure] = Min([Your Value Measure]) In Report)
    

  • Drop these variables into your report, then add static text labels like "Maximum Ward:" and "Minimum Ward:" next to them to get your exact desired format.

Quick Notes to Avoid Issues #

• If your report uses sections, replace In Report in the formulas with In [Your Section Dimension] to calculate max/min per section instead of the entire report.
• If multiple wards have the same max/min value, both methods will show all tied wards. To pick just one, add an extra condition—for example, =[Ward Name] Where([Your Value Measure] = Max([Your Value Measure]) In Report And [Ward Name] = Min([Ward Name])) to grab the alphabetically first tied ward.

内容的提问来源于stack exchange，提问作者Abraham