Time - Filtering

I need to filter the chart based on Time using Native Time Filter(Hierarchy Filter) In New UX . For This chart, I have published the view in UX having Time in Columns, Line Items as Rows and applied Hierarchy Filter of Time in Context Selector.

The Problem here is when I select month using Time Selection , the chart is showing the 3 months in the particular quarter since quarterly totals has been enabled for the model. But What I need is when I select a month using Native Selector, the chart should show all the months in that particular Year

Is there any way that we can control Hierarchy filter since I cannot remove quarterly totals from the models or I cannot move on to line item filtering for this chart?

I would love to hear , if there is any workaround for this?

Thanks
Pujitha

Accepted answers

Misbah

@PujithaB

In that case keep the selectors on cards. Year Selector in Chart Card and Month Selector in Grid Card

Misbah

All comments

Misbah

@PujithaB

So the intention is to populate all the months of that particular year which gets selected in the context selector.

I fail to understand why is the month being selected in the Context Selector, instead you can have Only Years in the context selectors and Anaplan will take care of the rest if the Sync is enabled

Misbah

PujithaB

@Misbah

Thankyou for the reply,

There is one more grid in the same page which needs to be filtered by Month to populate monthly values only Whereas chart on the same pages has to show all the months in a year of the selected Month . So, I need both months and Years in the selection

Misbah

@PujithaB

In that case keep the selectors on cards. Year Selector in Chart Card and Month Selector in Grid Card

Misbah

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…