Voice Affinity Logo

Query Pro

  • Favourites
    Loading...
  • History
    Loading...
  • Examples
    Loading...
  • Help
    Data Set Overview Hints and Tips Demo Videos
  • Clear Screen
Google Assistant
When you use Google Assistant (signed in as the above account), your questions will appear in this web application.
Follow Up
Your request was interpreted as a follow-up question/command. This means that it will take properties from the previous request. If you think this should be a stand-alone request then you can run the request in isolation here.

Ask a question:

Keyboard

Type a question in the box at the bottom and hit return.

Voice

Launch the app in Google Assistant "Ok Google, Ask Query Pro ..."

Examples

Click on 'Examples' in the menu above and choose a sample question.

Report showing revenue by year

Reportable Values

  • How much revenue last year?
  • How much profit did we make?
  • How many units of wine did we sell? [unit sales]
  • How many customers bought beer?

Axis Selection

Date/Time: Year, Quarter, Month, Date

Store: Store Country, Store State, Store City, Store Name & Store Type

Product: Product Family, Product Category, Product Subcategory, Product Name

Customer: Country, State, City, Name & Gender & Age

  • Which <axis selection> had the most <reportable value>?
  • Which store made most profit?

Commands

  • Show <reportable value> by <axis selection>
  • Show unit sales by month
  • Add revenue
  • Group by product family
  • Drilldown on food
A report showing a comparison of wine and beer sales by month

Comparison

  • Show a comparison of wine and beer sales by month
  • Do we sell more wine than beer?
  • What proportion of drinks sales is wine?
  • Do we sell much wine compared to other drinks?

"How much revenue last year?"

Are report showing how much revenue last year
Previous Next
           
        
Ask