In order to make your life simpler and easier, we prepared many query examples, using SQL, our API-based SQL endpoint and the API-based JSON endpoint, for querying data on all our types of columns.
Know how many unique entities (how many primary keys) you have in a particular dimension satisfy the query conditions.
Know the number of times some data was inserted for an event column in a particular dimension.
Generate insights from the data stored at SlicingDice by calculating metrics (Average, Sum, Min, Max, etc.) and crossing data from different columns to generate pivot tables.
Know what are the most common values for a specific column and how many times was the value inserted.
Check whether the given entity IDs exist in a dimension.
Know how many unique entities you have in a particular set of dimensions (or in the whole database).
Differently from analytics-focused queries, data extraction methods allow you to retrieve data stored on SlicingDice. Below you can find all data extraction queries currently supported by SlicingDice.
Allows you to retrieve the values from columns for all entities or the entities that satisfy the query conditions.
Almost the same behavior of the Result query, but Score query allows you to retrieve values while receiving the entities' relative importance given a set of conditions.