Test collection on External indicators fails with the error: "The result query doesn't contain `value`". Issue External Indicators can be configured in Performance Analytics. Please see this documentation for an overview. After setting up an external indicator for any of supported JDBC drivers, the "Test Collection" can fail with the following error: Error MessageErrors found.Collecting for indicator and breakdowns on <DATE> failedThe result query doesn't contain `value`ReleaseAll supported releasesCauseThis could be because the SQL statement provided is incorrect.ResolutionFollow the below instructions to properly construct the indicator SQL statement: For the MySql driver The SQL statement and Import set table defined in the data source are not used by Performance AnalyticsThe SQL statement on the Indicator form should be as follows - SELECT COUNT(*) AS value FROM <table_name> WHERE DATE(<date_field>) >= DATE(<current_date>). The current date should be in the format YYYMMDD For SQL server The data source should have the SQL statement that selects all the records from the given table - SELECT * FROM <table_name>The SQL statement on the indicator form should be as follows - SELECT COUNT(*) AS value FROM <table_name> WHERE try_convert(date,<date_field>) >= try_convert(date,'<current_date>'). The current date should be in the format YYYMMDDThe Indicator query provided in the documentation using the DATE function is specific to MySql and this function needs to be replaced with try_convert.