We have created a detailed report using Online report designer but when we are trying to filter the report based on calculated column, it is not giving any results
Reproducing the Issue
Login to The instance
Go to Analytics
Open The report > Edit Query
Go to Manage Filters
Apply a calculated column as filter
Due to following reason the calculated columns will not work.
Currently it is a limited functionality and is not supported in the following
-If a calculated column contains an Adhoc column of type timestamp
-If an AGE function is involved
-If a calc column is having a conditional statement
-No support for LMS calc columns
-Calculated column is based on another calculated column.
This is an expected behaviour.
KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem