Skip to Content
0
Sep 10, 2014 at 03:50 PM

Restrict data for Graph based on prompt

19 Views

I have a below requirement to build the graph in Webi

User selects a input control for Year or Region

If the selection is Year

Then data should display for all the years and all the regions, where year in x axis and revenue as data (Pic 2)

If the selection is Region

Then data should display for latest year and all the regions, where Region in x axis and revenue in Data (Pic 1) in the same graph

I am able to achieve the first one but when a region is selected how to filter the graph only for latest year ( created variable to get the latest year)

Is it possible to apply filter on graph based on a variable.

Attachments

Pic.jpg (30.8 kB)