Dashboard - Auto Generation
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Dashboard - Auto Generation

  • Dark
    Light
  • PDF

Article summary

Various options are available for auto-generating dashboards:

Connected Reports
Connected Reports also support a form of "mass profiling", however they create Compound Result Sets rather than Dashboards.


Mass Profiling Dashboard

A mass profiling dashboard is a dashboard that repeats the same profile report multiple times, changing a single parameter of interest with each iteration.  The following reports support mass profiling:

For each of these report types it is possible to iteratively change one of the following at a time:

  • dimension - changed by dropping a field template onto the result grid
  • dataset- changed by dropping a dataset collection onto the result grid
CAUTION
Depending on the number of items in the dataset collection or field template, the mass profiler may take several minutes to produce the dashboard.


Iterating by Dataset

Iterating by dataset repeats the starting profile for each dataset in a collection, applying each dataset as a base filter. So for example, take a simple profile of marital status:

Perhaps there is a need to see this profile split out by age band.   

To do this a dataset collection of the age bands of interest is created:


The dataset collection is then dropped onto the profile report. 

Select either

  • 2 column dashboard
  • 3 column dashboard


A dashboard is created, iterating through the datasets in the collection:


Iterating by Dimension

Iterating by dimension repeats the starting profile for each field in field template, applying each field as a dimension. So for example, take an index profile of customer-recency-decile with target filter of first transaction before 2020-0101:


Create a template of dimensions to profile (make sure they are Discrete Fieldfields)


Drop the field template onto the index profile and a dashboard will be produced with an index profile for each dimension in the field template.


Limits

  • A maximum of 24 iterations can be added to a single dashboard.
  • A maximum of 64 iterations can be processed in a single calculation - if more than 24 iterations are specified, multiple dashboards will be produced
  • Mass Profiling dashboards cannot be auto-generated in script from a dataset collection or template - as part of the script development process, automate the production of the dashboards, and then add the dashboards to the script.


Table Auto Dashboard

When first looking at data, especially unfamiliar data, it can be helpful to see a quick summary visualisation of a table and it's fields and columns.

Processing Time
NOTE: Depending on the number of records and fields in the table it can take several minutes to auto-dashboard a table




Right-click and open as copy any individual visualisations of interest:


Open as Dashboard

Available for the multi-field statistics report.

  1. Add fields to Setup grid.
  2. Select "open as dashboard" from the toolbar
  3. A new dashboard will be created, adding each field as a separate statistics report.





Add the original mutli-field stats report to the dashboard to add a summary slot to the final dashboard (optional)





Was this article helpful?

What's Next