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

JAbhi · 2024-11-25T06:46:31+00:00

There was an error rendering this rich post.

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?

Accepted answers

AjayM

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!

AjayM

Hi @JAbhi ,

To your first question where you wanted to control/filter the 'to' months based on 'from' months selection, I don't have a solution when the selection lineitems are of native time format. You need to create custom time dimension (a list with months as items) in order to achieve this. Check filtered picklists, which will be helpful once you have custom time list.

To the second question, either you can use TIMESUM function, which is performant heavy, but suits the usecase here. Or, you can also use a set of staging lineitems (that are time dimensioned), where the formulas use filter conditions as per my original solution. And then create another set of lineitems without timedimension, and refer original lineitems with SELECT on time.all periods. For this to work, all periods summary must be ON at model calendar level (or time ranges level if you are using timeranges in the calculation module).

Cheers!

All comments

AjayM

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

JAbhi

Thanks @AjayM, one more follow up on this one, Right now, if i select "From Date" as Sep 24, in "End Date" i get option to select months even earlier than sep 24, which is not very user friendly.
I tried putting a filter on that part as well to show options in end date on based of from date, but didn't found the solution.

JAbhi

Also, is it feasible if instead of individual months based on filter, i can show the overall calculation during that time period.
@AjayM

AjayM

Hi @JAbhi ,

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…