How to build Aggregates with Context Calculations

Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid. Use the Tips & Tricks series to give you a quick way to learn more about all modules of Pyramid and share the ‘secrets’ of the Platform. It is a good preparation to take the Discover 2023 course on the Pyramid Learning Hub. Additionally we will share all the Datasets and Solutions on our Explore Pyramid Server for you to experiment, understand and re-build the Tips&Tricks before you run them in your production environment.

Sometimes not all necessary aggregates have been defined in the underlying Data Model. Pyramid offers rubust context calculations to build these on the fly with a few clicks. In the video we show how to do a count distinct on the Data, share the result and further refine in Formulate. 

In this video we will show you how to build Aggregates with Context Calculations.
 

You can find this example on the Explore Server in the Knowledge Base / Discover Folder.

If you have Questions about this Video, please refer to it in a Question in our Q&A Section.For feedback reach out to: community@pyramidanalytics.com