Help CenterComparing Insights
Comparing two insights allows users to identify commonalities and differences across datasets, helping to uncover meaningful patterns. This can be useful when analysing players, games, countries, or any other data points that appear in more than one insight. By comparing insights, users can answer questions such as:
- Which players exist in multiple customer segments?
- Which games appear in both high- and low-performing lists?
- Which acquisition sources are common across different time periods?
Using the # Shortcut for Insight Comparison
To compare insights efficiently, use the # shortcut in the query area, which provides a list of available insights and their attributes. When an attribute is selected, the query is focused on that attribute, allowing for direct comparisons between different insights.
The format for referencing an insight’s attribute is:
<Insight Name>.<Attribute Name>
Example Usage
Identifying Common Games Between Two Insights
If a user wants to find games that appear in two different insights, they can write:
Show games that are in insight1.attribute1 and are also in insight2.attribute1.
This query will return only the games that are present in both insights.
Understanding Attribute Matching
It is important to ensure that the attributes being compared are logically equivalent. The attribute names do not need to be identical, but they must represent the same type of data. For example:
- Comparing
playerIDfrom Insight 1 withplayerIDfrom Insight 2 will work correctly. - Comparing
playerIDfrom Insight 1 withgameNamefrom Insight 2 will not return any results, as these attributes do not represent the same datapoint.
By following this approach, users can effectively compare datasets, discover trends, and generate actionable insights using multiple result sets.
Other examples
Display a list of games in both insights:
Display a list of customers in one insight but not in another:
A combination query which selects customers who are not active this month and are also in my top 100 casino VIPs:
