2.4.8 Create Detailed Demand Review

Options
mstanisic
mstanisic Member, ALL USERS Posts: 5 Contributor

Hi Team,

 

May I have your support with a query I had raised and to which I have not had a response yet. 

 

This is my original query.

 

When pivoting time, I lose the weekly views and can only see the month's numbers, may I confirm how I can retain the weekly views whilst moving the months into the pages section. 

 

I was advised to do the below:

 

  1. All you need is a line item dimensioned by time (time formatted - month),  a line item dimensioned by time (boolean) and a line item which you will use as a user filter (month). User will select month via this filter. And it will drive the boolean to match the month.
  2. Month Li formula will have ITEM(TIME).
  3. Boolean formula: Month Li = Filter
  4. Then apply module with a filter by Filter Li

My first question is whether this has to be done in the SYS01 time module? What boolean formula am I to apply exactly, I'm not sure how to do this, is  it a separate line item?

 

Thank you 

Matthias

Comments

  • matthewreffold
    matthewreffold Member, ALL USERS Posts: 3 Occasional Contributor

    Is there a way to do this in the New UX? @KirillKuznetsov 

  • matthewreffold
    matthewreffold Member, ALL USERS Posts: 3 Occasional Contributor

    Yep that worked! Added dummy module with time as a selector, enabled time filtering on other modules and then deleted dummy module. The Time selector remains at the top of the page! Thanks

  • matthewreffold
    matthewreffold Member, ALL USERS Posts: 3 Occasional Contributor

    Yep. Page Selector remains.