Automated Filter (Board v10.1.2)

unknown

Hi Board Community,

I have a screen which shows weekly results in a graph. The graph is always showing the past 6 weeks.
This timeframe is updated manually by using a Filter Cube on the Week in the layout selection:

I am wondering if it is possible to automate this step in anyway so that the manual process can be ignored.

Moreover, the graph is showing the top 5 projects, in this case I also use a manual filter and select the top 5 projects of the current week and use this filter in the screen layout filter. Ideally I want to get rid of this manual step as well. I tried to use the filter in the data view but somehow it doesn't work.

This is the layout

Thanks

Mathias

------------------------------
Mathias Flintrop
Senior Financial Controller
Smaato Inc
Germany
------------------------------

unknown

Hi Mathias,

With your filter cube dimensioned by week you can achieve your result dynamically. 

If the number of rolling previous weeks is static (i.e. always 6 previous weeks), you can build a procedure in the following way:

1. Clear cube step on the filter cube (this is to clear the filter before repopulating it every week)
2. Dataflow step where filter cube = 1, then reset all selection step
3. 6 procedure groups with the following steps within each group:

Group 1: Current Week
    a. Dynamic selection on current week
    b. Go to dataflow group
Group 2: Previous Week
    a. Dynamic selection on current week with -1 offset
    b. Go to dataflow group
Group 3: Previous Week -1
    a. Dynamic selection on current week with -2 offset
    b. Go to dataflow group

etc. 

You can then add this procedure as part of a scheduled daily/nightly update procedure.

Hope this helps.

Thanks
Paris

------------------------------
Paris Waranimman
Consultant
Board Community
United States
------------------------------
-------------------------------------------