All vs. Any - Analytics Cookbook Recipe

Content

 

 

 

 

 

 

"All vs. Any" Reporting

 

 

 

 

Using Multiple Joins to the Same Table to Report on Different Metrics within the Table

 

 

 

 

 

 

 

 

 

Author: Simon Kilgarriff

 

 

 

 

Difficulty rating:  (Intermediate)

 

 

 

 

Target persona: This scenario could be applied by many target personas based on the report you are trying to create. 

 

 

 

 

Ingredients:

 

 

 

 

7 Tables (cloud_results, cloud_search2results, cloud_searches, channel_accounts, incidents,

                    transactions, transactions2)

 

 

 

 

5 Inner / 1 Double Joins 

 

 

 

 

2 Columns using formulas (1 min(); 1 date_diff() with a nested min() ) 

 

 

 

 

4 Filters

 

 

 

 

1 Rollup

 

 

 

 

Overall description/purpose: 

 

 

 

 

The main goal of this report recipe is to demonstrate how to use multiple joins on the same table.

 

 

 

 

Anyone wanting to look for several AND actions on the same table could use the technique demonstrated in this report recipe to look at the same table several times to compare data/results.