Ask Data in Plutora Analytics

The integration of Ask Data within Plutora Analytics aims to simplify data querying and empower users to derive actionable insights effortlessly. This feature generates automated data visualizations, eliminating the need for manual field selection or extensive knowledge of your data’s structure.

Before querying a data source with Ask Data, you need to create a lens that specifies the subset of data fields the lens uses. You can access an Ask Data Lens here:

  • On the All Lenses page at the top level of your site.
  • On the Ask Data tab for a data source for which lenses have been created.
  • In an Ask Data object on a dashboard.

“Ask Data lenses can be created only for data sources published separately to a site. Lenses can’t be created for data sources embedded in workbooks or those with a virtual connection.”

Create and configure a lens page

Each lens has a separate page where you can query Ask Data and authors can configure lens fields, synonyms, and suggested questions.

Create a new lens page via a data source page

  1. Go to a data source page
  2. Select New > Lens using this data source
  3. Enter Name, Description, Location
  4. Click Publish Lens
  5. The new lens page will open in a new browser tab

Optimize Data for Ask Data

  1. Hide unnecessary fieldsClick on the pencil icon at the top of the Fields panel.
  2. Customise the Recommended Visualisations listTo link to a visualization, while viewing it, click on the pin icon in the toolbar.
  3. Add synonyms for field names and valuesHover over individual fields and click on the pencil icon. People may not use the same terminology found in your data source, so data source owners can add synonyms for specific data field names and values.

Build queries by entering text

Type in the box reading Search fields or values to create a visualisation. as you type, Ask Data searches data fields, functions, and string values and displays in a dropdown list.
Click items in the list to add them to your current entry, shown above the search box.

Modifying a query

Modifying a query by searching for fields and analytical functions:
  • A: Current entry.
  • B: Current filters.
  • C: Search box.
  • D: Returned fields.
  • E: Returned analytical functions.
  • F: Returned field values.
You can also add suggested phrases to your query by clicking them.

Analytical Functions

Explore essential analytical functions including aggregations, grouping, sorting, numerical filters, and limits for streamlined data analysis:


  • Sum
  • Average
  • Median
  • Count
  • Distinct count
  • Minimum
  • Maximum


  • By


  • Ascending
  • Descending
  • Alphabetical

Numerical Filters

  • At least
  • At most
  • Between

Numerical Limits

  • Top
  • Bottom

Query Examples

For Release Manager

Release Owners sorted by number of Releases:

  • [distinct count] [Release ID] [by] [Release Owner Name]
Count Releases by month over time:
  • [distinct count] [Release ID] [by] [month]
Average duration of Release by Type in days:
  • [average] [Phase Gate Duration Days] [by] [Release Type]
Distribution of Release Status:
  • [distinct count] [Release ID] [by] [Release Status]

For Environment Manager

Coming soon!

For Deployment Manager

Coming soon!

Related Articles


Be the first to find out about new features. Subscribe to the Release Notes email.

Was this article helpful?

Thanks for your answer!