Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Multiple metrics for a single object
Metrics for two groups
Ratios and percentages
Global vs. specific metrics
Summary
14. Summary

Instruction

It's time to wrap things up! Let's review the concepts we've covered in this part:

  1. We can calculate multiple metrics for a given business object using multiple aggregate functions in a single query.
  2. We can use COUNT(CASE WHEN ...) multiple times in a single query to count objects in multiple groups.
  3. When calculating percentages, remember to cast one of the counts to the float type. You can also use the ROUND() function, like this:
    ROUND(CountShipped / CAST(CountAll AS float) * 100, 2) AS ShippedRatio
    

All right, how about a quiz before we move on?

Exercise

Click Next exercise to continue.