A filtering example: To see payments made by a company for a certain drug in the state of NY:
Note that the system processed 11 million records in 21 milliseconds, as shown in the header message. The name of the company and the product has been blanked out in the screenshot for privacy, but you are free to try out different options for both fields.
An aggregation example: To see total payments grouped by state, payment category, and payment nature for a specific company and product, select the options for the fields Aggregate Data and Calculate Metrics. Please note that the name of the company and the product have been hidden in the screenshot for privacy reasons only.
Note the message at the top that states:
Log message indicating query and application performance
This indicates the speed with which the underlying kdb+ database processed the data. In this case, it filtered and aggregated 11 million records in 22 milliseconds for the given options.
