Dmytry Dymshyts

Allow the situation when Condition Era is not built from Condition occurrence where condition_concept_id =0

2

Please edit the measureConditionEraCompleteness checl The number and Percent of persons that does not have condition_era built successfully for all persons in condition_occurrence. It should omit Condition records where condition_concept_id...

The number and percent of records with a value in the QUANTITY field of the DRUG_EXPOSURE table greater than 1095. (threshold 1%) - should be checked only for solid forms

4

Please, see the [rule](https://ohdsi.github.io/CommonDataModel/cdm54.html#DRUG_EXPOSURE): If liquid, quantity stands for the total amount dispensed or ordered of ingredient in the units given by the drug_strength table. If the unit from the...

Units can be null if the ratio or score is measured. Please include NULL m.unit_concept_id in this analysis https://github.com/OHDSI/Achilles/blob/main/inst/sql/sql_server/analyses/1815.sql#L85

Empty avg duration in Visit Occurrence report

1

Empty "avg duration" in Visit Occurrence report, and when looking at the export query https://github.com/OHDSI/Achilles/blob/main/inst/sql/sql_server/export/visit/sqlVisitTreemap.sql it indeed doesn't have the duration as output. Error exists both in main and beta...

### Expected behavior The percentage of covariates to be shown based on the number of patients in subgroup (so the user can see the pattern over time or age or...

Maybe we can add an option to include a 'first per person' mode, then it's correct to say "persons" in the output. or just change the word "persons" to "events".

Optimize concept set doesn't remove redundant excluded concepts

2

### Expected behavior The peak concept was removed from the concept set definition, and concepts used to exclude parts of its hierarchy should be removed by the Optimize functions. ###...

Updated vocabulary isn't reflected in the concept set expression

2

The concept set expression is not refreshed with the vocabulary update, so it's impossible to detect changes if concepts become non-standard or change domains Possible solutions: 1) refresh the concept...

Currently Included Source Codes also picks up concepts that don't exists in concept table, but exists in source_to_concept_map with source_concept_id = 0. Achilles_result_concept_count table used to derive counts of concept...

We are collaborating on the Custom Feature analysis and it would be good to share the write access across the group. Or at least the users should be able to...