cancel
Showing results for 
Search instead for 
Did you mean: 

custom filter not working

MikeC
Explorer
0 Kudos
126

Hi

Hoping someone can help please. I've created a custom formula below in the Calculation Editor as a Calculated Dimension. This checks to see if a course has been used in the last 365 days and if it has put a 1 in the field and if not put a 0. This works perfectly so no issues with this part. I am able to add this up to see how many courses have been used within a year. But for some reason I am unable to use this as a filter on the page. So from a cross-tab list of all the courses I want to filter on those courses used within a year. I have a simple bar chart showing this volume. I set it as a Linked Analysis to filter all widgets on the page. But it simply doesn't do anything when I click on it. Am I doing anything wrong or can you not use a custom formula as a filter? 

IF([#Most Recent Activity]<=365,1,0)

Thanks

View Entire Topic
Sumitkumarjha
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Mike,

The filter you have added is it a page filter?
Can you make sure that the filter is applied to/connected to the required widgets you want the filter to work on.

Please see Work with the Linked Widgets Diagram (Optimized) | SAP Help Portal
This will help in seeing if the filter is connected to the required widgets

BR
Sumit