Give a functionality to select month range(from & To) in UX

I have a module that is calculation P1 Sales%, P2 Sales%, P3 Sales% as line items and the calculation of P3 Sales% is dependent on P1 & P2.

For dimensions of this module i have two lists as selectors & History is being kept as Columns & for rows i have line items.

On UX i want to provide user functionality where he/she can select From Month & To Month and then data will be displayed according to that.


Has anyone worked on a similar scenario?

Answers

  • AjayM
    edited 6:56AM

    Preferably, create a user dimensioned input module without any other dimensions, and 'select from' & 'select to' lineitems (both timeperiod formatted).

    In another module that is dimensioned by users and 'history', define filtering rule, based on selections done on the input module (Ex: isnotblank(inp module.select from) and isnotblank(inp module.select to) and item(time)>= inp module.'select from' and item(time)<=inp module.'select to').

    Apply this filter on UX, and also publish from and to lineitems as field cards.

    Cheers!