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
- Go to a data source page
- Select New > Lens using this data source
- Enter Name, Description, Location
- Click Publish Lens
- The new lens page will open in a new browser tab
Optimize Data for Ask Data
- Hide unnecessary fields. Click on the pencil icon at the top of the Fields panel.
- Customise the Recommended Visualisations list. To link to a visualization, while viewing it, click on the pin icon in the toolbar.
- Add synonyms for field names and values. Hover 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:
Aggregations
- Sum
- Average
- Median
- Count
- Distinct count
- Minimum
- Maximum
Grouping
- By
Sorting
- 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!