7 Replies Latest reply on Jun 20, 2016 6:30 AM by Michael Hesser

    Dynamic Axis Range for Line Graphs on different pages

    Goutam B

      Hi,

       

      I'm trying to view the sales figures for each Country on a separate page. For this I've dragged the "Country" Dimension under "Pages". This works fine.

       

      Now I have a "Sales" with "Order Date" Line graph for each Page/Country. However, while moving through pages, the range of Sales axis remains same, irrespective of the actual value of sales on that page.

       

      Is there a way to dynamically change the range of Sales axis based on a specified condition.

      e.g. Say for USA the Max Sales value is $10,000 and for Mexico it is $100 across the whole year. Then the Page for USA should have the axis range between 0-$10,000 and for Mexico page between 0-$100