Applying time filter in page selector || count, sum etc. features in insight grid of worksheet.

Hi, Please help me out in following:
1) My module has time filter to show monthly value of desired year
Additional to it, I also need to keep the time as a page selector in the top right of UX page . Can I apply similar time Filter to this time selector as well: can I restrict this time selector to show only the desired range?

2) In main grid of worksheet, we can see Count, Min., Max. and others.
But additional insight grid didn't shows this feature (count, Min., Max. and others). Can this feature be enabled in additional insight grid also, If yes, then how?

Thanks in advance 🙂

Anaplan1_111182.jpg

Anaplan2_111182.jpg

Accepted answers

All comments

abhay.kanik

@PrabudhaTiwari

For the first case -

Create a system module Time selector without any dimension which 2 line items start time and end time which will be time period formatted, Create another module with time dimension and a Boolean line item Filter.

time selector.PNG

Use the formula -

IF ISBLANK(Time selector.Start) AND ISBLANK(Time selector.End) THEN TRUE ELSE IF ITEM(Time) >= Time selector.Start AND ISBLANK(Time selector.End) THEN TRUE ELSE IF Time selector.End >= ITEM(Time) AND ISBLANK(Time selector.Start) THEN TRUE ELSE IF ITEM(Time) >= Time selector.Start AND Time selector.End >= ITEM(Time) THEN TRUE ELSE FALSE

time filter.PNG

There are 4 parts to this formula,

If both selectors blank then all the months will be true,

if start time is selected then all the months after that will be true

if only end time is selected then only months prior to that will be true

if both are selected i.e. start time and end time then then months between those will be true .

Publish the line items from the system module on your dashboard i.e. start time and end time and use the filter line item from the other module to filter time in your data module. filter view.PNG Month data.PNG

Second Case -

Create 3 line items in your data module as Data Sum, Data Avg and count . Keep summary method of Data sum a sum, and Average for Data Avg. Put formula as 1 in count. you will automatically get the count, avg and sum of the hierarchy.

Data Avg.PNG

Publish it on UX , It will look like this

UX view.PNG

Thanks

Abhay

PrabudhaTiwari

Thanks Abhay, I will try this solution

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…