Connexica logo

Advanced Developer

This course is designed to give users an understanding of how to rapidly create complex reports and dashboards using CXAIR’s advanced calculation, charting and filtering capabilities.

Duration: 1day

Who Should Attend?

IT Professionals, Analysts and Business Users who have prior experience in developing reports and dashboards in CXAIR who wish to extend their knowledge by learning advanced techniques and features.


Upon completion of this course, attendees will be able to:

Advanced Features Essentials

  • Core Concepts
  • Crosstab Refresher
  • Calculation Syntax
  • Row and Column Totals
  • Saved Queries
  • Advanced Charting
  • Multi-Index Page Reports

Advanced Reporting

  • Row and Column Totals
  • Cell Calculations
  • When to Use These Totals
  • Linking Totals
  • DrillThru Calculation/li>
  • Placeholder Queries

Report Formatting

  • Dynamic Labelling
  • Hiding Report Levels
  • Using Hidden Measures

Advanced Calculations

  • CASE and IF Statements
  • Date Calculation Syntaxes
  • Conditional Statements
  • Formfields

Hints and Tips

  • Best Practices
  • Naming Conventions
  • Example Crosstabs
  • Example VENN Diagrams
  • Example Flow Reports
  • Example Dashboards
  • Mobile Design Considerations

Advanced Pages

  • Break Fields
  • Layers
  • Text / HTML Editor
  • Multi-Index Reports