ACA Reporting & Analytics 2 — Questions and Answers
Question 1: In Appian, what does a KPI tile on a dashboard typically display?
- A single aggregated metric such as count, sum, or average (Correct answer)
- A full list of process instances
- A gantt chart of task durations
- A network diagram of system connections
Correct answer: A single aggregated metric such as count, sum, or average
KPI tiles present a single, high-level metric that gives stakeholders an at-a-glance view of operational performance.
Question 2: Which Appian function would you use to count the number of records matching a specific filter condition?
- a!queryRecordType() with aggregation fields set to COUNT (Correct answer)
- a!recordCount()
- count(a!queryEntity())
- a!aggregateRecords()
Correct answer: a!queryRecordType() with aggregation fields set to COUNT
a!queryRecordType() with aggregation configured to COUNT is the standard Appian approach for counting filtered records.
Question 3: What is the purpose of the 'startIndex' parameter in Appian query functions like a!queryRecordType()?
- To enable pagination by specifying the first record to return in a result set (Correct answer)
- To set the primary sort column index
- To define the starting row number in a database table
- To initialize a counter variable in a loop
Correct answer: To enable pagination by specifying the first record to return in a result set
startIndex in Appian query functions controls where in the result set to begin returning records, enabling paginated data display.
Question 4: In Appian reports, what is the role of a 'data series' in a bar or column chart?
- It defines a grouping of data to be plotted as a distinct set of bars with a shared color (Correct answer)
- It specifies the SQL query powering the chart
- It controls the chart's border and padding styles
- It maps user roles to visible chart columns
Correct answer: It defines a grouping of data to be plotted as a distinct set of bars with a shared color
A data series in Appian charts groups related data points that are visualized together, often color-coded, for easy comparison.
Question 5: Which Appian component is best for embedding a live report or chart inside a process task interface?
- a!gaugeField() or a!barChartField() embedded in the interface (Correct answer)
- A standalone Report object linked via URL
- A PDF export of the report
- A process variable storing chart image data
Correct answer: a!gaugeField() or a!barChartField() embedded in the interface
Appian's chart components (bar, line, pie, gauge) can be embedded directly into interfaces to display live data within task forms.
Question 6: What is the maximum number of records returned by default in a single a!queryRecordType() call in Appian?
- 10,000 (Correct answer)
- 100
- 1,000,000
- 500
Correct answer: 10,000
Appian caps a!queryRecordType() results at 10,000 rows per call to protect platform performance.
ACA Reporting & Analytics 2
In Appian, what does a KPI tile on a dashboard typically display?