How to perform group by query in FHIR

1

Hi, How can I fetch list of observations for patient group by Observation code

2

There is no “group by” functionality in FHIR. You can sort by Observation code, but all queries return existing resources, not summaries like “count” or “average” or anything like that. If you want statistics, you could look at the Observation $stats operation

3

@Talwinder.singh www.keyark.com provides a cloud based NoSQL ad hoc analytics platform. You can import your FHIR data, and use the KeySQL query language to do COUNTS, GROUP BY etc the same as with regular SQL. Visit their web site for a trial account. Note that it is not HIPAA compliant at this time.

4

Thanks lloyd for your response