Skip to Content
0
Jun 02, 2020 at 07:02 PM

Dynamic Maximum Axis Ranges in Webi

265 Views Last edit Jun 02, 2020 at 04:25 PM 2 rev

HI,

I'm using Web Intelligence Rich Client.

I have 3 Line graphs filtered by an Input Control of 5 sales people: (for example)1-5

Category Axis: Month

Value Axis: Sales

Divided by 3 separate graphs for regions A B and C

Problem: I created a fixed Value Variable ("=[vMaxLineGraph]") for each graphs's Value Axis's Maximum Value. So that tall 3 Graphs display the same Axis height.

When I filter on each Sales person in the Input Control, the Maximum value stays the same when filtering on other sales people, which causes the line graph to drop significantly when the sales figures is alot lower than Sales person 1. Cant see trends.

Question: What formula is useful to set a Maximum value Axis Range for each sales person selected so that the line graphs (A-C) displays the maximum value axis range for each Sales person?

Attachments

grmur.png (31.3 kB)