on 2024 Nov 26 9:39 AM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.