Dynamic Time filter in the new ux

Hi, question please. I am trying to do a chart in the new ux and the time filter should be dynamic in the sense that if I choose Monthly - the chart should show monthly and if I choose in the filter the Quarterly, the chart should show quarterly figures in the chart and same with the Half year and Yearly. The time filter should show in the board so the user can choose the period to be use in the chart. Is there a way I can do that?

Thank you!

Accepted answers

Vinay VaradarajM

Hi @DMManalili ,

You can achieve this with the following steps:

1. A simple input module where the user can select Month/Qtr/Year (which you can publish in a board)

Screenshot 2021-06-02 at 5.31.01 PM.png

2. A system module for Time Filter. The last Lineitem in the screenshot below can be applied as a filter in your Board.

Note that Quarters and Years are selected in the 1st screenshot, which drives the Filter here.

Screenshot 2021-06-02 at 5.31.13 PM.png

Below are the formula details for reference:

Screenshot 2021-06-02 at 5.31.45 PM.png

Hope this helps!

Regards,

vinayvm

All comments

Swarupa_1

@DMManalili

I can think of one way where you can approach the solution with the help of below steps:

1. Create a boolean for time period (like the below screenshot) and publish this in the dashboard.

2. One line which will be driven by the above boolean.

P.S. Months, Quarter and Years are line items.

Hope that would be helpful.

Cheers!

Vinay VaradarajM

Hi @DMManalili ,

You can achieve this with the following steps:

1. A simple input module where the user can select Month/Qtr/Year (which you can publish in a board)

Screenshot 2021-06-02 at 5.31.01 PM.png

2. A system module for Time Filter. The last Lineitem in the screenshot below can be applied as a filter in your Board.

Note that Quarters and Years are selected in the 1st screenshot, which drives the Filter here.

Screenshot 2021-06-02 at 5.31.13 PM.png

Below are the formula details for reference:

Screenshot 2021-06-02 at 5.31.45 PM.png

Hope this helps!

Regards,

vinayvm

DMManalili

thank you!

DMManalili

Thank you!

AWhitworth

This is a nice way of doing it without using subsidiary views with Quarter and Year timescales.

Sachinsourav02

@Swarupa_1 Could you please give me pointers on how to take this forward. I have a requirement where I could potentially need a system like you have shown. where the users can see the table dynamically change between Quarters, Years or Months.

durgaprasad

Hi,

i tried the dynamic filter approach but it was not working working for me can you help me where i did a mistake??

Pratapkumar

Hi Durga,

you need to make the summary "none" for Months line item. Then the formula for Filter will works

harish_bk

Hi Durga Prasad

You should have used Year Value function for Months, Quarters and Years:

IF YEARVALUE('FL01 Filter Selection'.Months) THEN 1 Else 0 so on

Quick Links

Can you help?

Unanswered questions

Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…