Can't apply a filter to time in Worksheet

TheresaR · 2024-06-07T19:47:09+00:00

There was an error rendering this rich post.

I am trying to apply a filter on the time dimension in a worksheet, and am unable to do this like I can in classic…either as an end-user or page builder. Is this an issue? On purpose?

I'm trying to filter out zero value (across all time) line items:

…but when I select the FY24 column and the filter funnel there are no available options to filter.

However in classic this filter is applied with no issue:

Accepted answers

TristanS

@theresa.reid just to ensure there's no confusion. So you're following the steps as per video below which is just a video of Tiffany's earlier response. Cause it works for me.

TheresaR

@TristanS thank you for the video! I got stuck on doing it "the old way" and getting it to work for an end user, this indeed allows me to apply it to a custom view instead of having to use the saved view. Thank you again!

All comments

Tiffany.Rice

Hi Theresa, from the card configuration menu you can add filters to "Custom Views". If the card is leveraging a saved view, then the filter should be added in the module saved view once updated/saved it will be reflected on the page.

TheresaR

In card configuration I get the same result, no ability to add this filter on a custom view. I was able to surface a module view with the filter, but because of the need to ALM module views we generally try to only use custom UX views for our apps.

Dikshant

NUX filters function differently compared to classic dashboards. Based on your screenshot, I question whether this filter is logically necessary, as filters cannot be applied to line items (at least, I haven't used and known of). This filter appears to unintentionally filter which filtered out all the data. It seems to be the filter that gets automatically applied when you open the saved view.

Dikshant

In NUX, filters can be applied to rows and columns. Unlike classic dashboards, NUX does not display separate tabs for different dimensions. Therefore, you need to look at the pivoting of the module to determine which dimension is in the rows and which is in the columns.

TristanS

@theresa.reid just to ensure there's no confusion. So you're following the steps as per video below which is just a video of Tiffany's earlier response. Cause it works for me.

TheresaR

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
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…