We have created a Detailed Reporting Live Data query using Online report designer but when we are trying to filter the report based on calculated column, it is not giving any results
SAP SuccessFactors Workforce Analytics
Reproducing the Issue
- Login to The instance
- Go to Analytics Online Report Desinger
- Open The report > Edit Query
- Go to Manage Filters
- Apply a calculated column as filter
Limited support for calculated columns of certain data types.
Currently the following Calculated Column definitions are not supported.
- If a calculated column contains an Adhoc column of type timestamp
- If an AGE function is involved
- If it uses Conditional If/Then/Else statements
- If the source is Learning or LMS domain
- If the Calculated column is based on another calculated column.
This will be an enhancement.
cannot filter on calculated columns, blank results for calculated columns, date calculated columns, filter operators not working , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem