You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
User: "James McBride"
James McBride

Oracle ACE Associate
Customer


United States

User: "Julien Dubouis"
Julien Dubouis

Oracle ACE Associate
Customer


France

User: "Madhavi Godbole"
Madhavi Godbole

Oracle ACE Associate
Customer


United States

User: "Mandeep Gupta"
Mandeep Gupta

Oracle ACE Associate
Customer


India

User: "Kumari Mairina"
Kumari Mairina

Oracle ACE Associate
Customer


India

User: "Matt Nease"
Matt Nease

Oracle ACE Associate
Partner


United States

User: "Matthew Hancock"
Matthew Hancock

Oracle ACE Associate
Partner


United Kingdom

User: "Mehmet Erisen"
Mehmet Erisen

Oracle ACE Associate
Customer & Partner


United States

User: "Michael Gibby "
Michael Gibby

Oracle ACE Associate
Partner


United States

User: "Nizam Mogal"
Nizam Mogal

Oracle ACE Associate
Customer & Partner


United Kingdom

User: "Nivya Mathire"
Nivya Mathire

Oracle ACE Associate
Customer


United Arab Emirates

User: "Nada Bashar"
Nada Bashar

Oracle ACE Associate
Partner


Egypt

User: "Nageshwaran S"
Nageshwaran S

Oracle ACE Associate
Partner


India

User: "Nathan Morgan"
Nathan Morgan

Oracle ACE Associate
Customer


United Kingdom

User: "Parag Hiremath"
Parag Hiremath

Oracle ACE Associate
Customer & Partner


India

User: "Piotr Sito"
Piotr Sito

Oracle ACE Associate
Partner


Poland

User: "Rafatullah Baba Saheb"
Rafatullah Baba Saheb

Oracle ACE Associate
Customer & Partner


India

User: "Rajesh Vadlamani"
Rajesh Vadlamani

Oracle ACE Associate
Customer


United States

User: "Rakesh Belgam"
Rakesh Belgam

Oracle ACE Associate
Partner


United States

User: "Satyabrata Nanda"
Satyabrata Nanda

Oracle ACE Associate
Customer


India

User: "Sherif Bashar"
Sherif Bashar

Oracle ACE Associate
Partner


Egypt

User: "Shabbir M Tahasildar"
Shabbir M Tahasildar

Oracle ACE Associate
Customer & Partner


India

User: "Satish Kumar"
Satish Kumar

Oracle ACE Associate
Customer & Partner


India

User: "Shameer Kappil"
Shameer Kappil

Oracle ACE Associate
Partner


Malaysia

All vs. Any - Analytics Cookbook Recipe

edited Apr 29, 2020 5:12PM in Reporting & Analytics for B2C Service 1 comment

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!