• Introduction
• Prerequisites
  • DigDash Enterprise version (2025R1 or later)
  • Authorisation group "End-user for BI Self-service
• Retrieve the source file
• Step 1: Connect to the Dashboard Editor
  • Login to DigDash Enterprise
    • Login to the home page
    • Home page overview
  • Connect to the Dashboard Editor
    • Accessing the Dashboard Wizard
• Step 2: Loading data and editing the data model
  • Loading data
    • Selecting the file
    • Loading the file
  • Editing the data model
    • Data preview
    • Configuring the data model
• Stage 3: Creating the customised dashboard: the first graphs
  • Creating the graphs
    • Creating the Trend in Absenteeism graph
    • Creating the Number of days of absenteeism by department graph
    • Creating the Causes of Absenteeism graph
    • Creating a chart Absenteeism rate by department
  • Naming the dashboard
  • Choosing the layout
• Step 5: Finalising the Absenteeism dashboard page
  • Back to the Dashboard Editor
  • Finalising the page
    • Adding filters
    • Renaming graphs
    • Modifying graphs that have already been created
• Step 6: Creating a second Payroll dashboard page
  • Adding a new page and choosing a layout
  • Creating new charts
    • How the editor works to create new graphs
    • Creating the graph Payroll trends by department over the last year
    • Creating the Evolution of payroll graph
    • Creating the Payroll by Department graph
  • Adding filters
• Step 7: Viewing the dashboard
• Congratulations!
  • Going further

Introduction

This tutorial introduces you to the Dashboard Creation Wizard.

The Dashboard Creation Wizard, included in the Dashboard Editor, allows you to create a dashboard from your data file intuitively, without any intermediate steps.

This tutorial uses a human resources dataset from a company in the Paris region, containing information on staff and data such as salaries, absenteeism, etc.

We will carry out all the steps from loading the data to creating the graphs and integrating them into the dashboard pages.

Before we do that, however, we'll check that the prerequisites for this tutorial have been met.

Prerequisites

In order to complete this tutorial, you will need to :

• have installed DigDash Enterprise version 2025R1 or later;
• be a member of the "End-user for Self-Service BI" authorisation group;

These requirements are detailed below.

DigDash Enterprise version (2025R1 or later)

To be able to follow this tutorial, you need to be using version 2025R1 or later of DigDash Enterprise.

To find out which version you are currently using:

1. Log in to the DigDash Enterprise home page as described in the section Login to DigDash Enterprise section of this tutorial.
2. Explore the central area at the bottom of the page: the version of the installation currently in use is displayed at the bottom.
   
3. If you do not have a sufficiently recent version of DigDash Enterprise, contact your administrator or your DigDash contact. You can also consult the Upgrade guide.

If you do not have DigDash Enterprise and need to install it yourself, please contact your administrator or your DigDash contact. You can also consult the Installation guide. Then go to the Connection section of this tutorial.

Authorisation group "End-user for BI Self-service

In order to use the Dashboard Creation Wizard functionality, your DigDash Enterprise user account must be a member of the"End User for BI Self-service" authorisation group.

If you do not have administrative rights, or if in doubt, contact your DigDash Enterprise administrator.

Retrieve the source file

In order to complete this tutorial, you must first retrieve the source data file: the Excel file RH_dataset_didacticiel.xlsx.
Please click on the file name to download it.

Step 1: Connect to the Dashboard Editor

Once you have checked the prerequisites in the previous section, you can connect to the Dashboard Editor.

It is from this editor that we will launch the Dashboard Creation Wizard.

In this section, we will log in to DigDash Enterprise for the first time and take a brief tour of the home page before accessing and exploring the Dashboard Editor.

Login to DigDash Enterprise

Login to the home page

1. First of all, make sure you have the internet address of the DigDash Enterprise installation as well as your user name and password.
   • Your DigDash Enterprise administrator must have given you this information beforehand.
   • If in doubt, please contact your DigDash Enterprise administrator.
2. Using your web browser, go to the address you have been given: the DigDash Enterprise home page will be displayed.

Home page overview

Once you have completed the previous connection stage, the following home page will be displayed in your browser.

This home page contains a main menu giving access to the various components of DigDash Enterprise as well as an insert giving access to various items such as documentation or the software version.

The numbered items are the ones we are interested in for this tutorial. They are detailed in the table below:

As you will have noticed, the main menu also provides access to the Configuration and Studio components. These provide advanced functionality and configuration elements that are not covered in this tutorial.

Connect to the Dashboard Editor

1. From the home page, click the Dashboard Editor button: a login page opens.
   
2. Enter your user name and password, then click the Log in button: the Dashboard Editor window appears.
   
    

Accessing the Dashboard Wizard

To access the Dashboard Wizard, click the Dashboard Wizard   on the menu bar. The wizard is displayed.

Step 2: Loading data and editing the data model

Now we have logged to DigDash Enterprise for the first time and familiarised ourselves with the home page and the dashboard editor, we're going to discover the Dashboard Creation Wizard.

First, we will load the data. Next, we'll edit the data model to configure new measures and make sure we have the right model for our first graphs.

Loading data

Selecting the file

To move through the wizard and create our charts, you have three choices when you open the wizard.

1. Click the first button Select a file.
2. In the Selecting a data source box, choose From a file on your computer and then click Choose a file...
   A window for your operating system will open.
3. Browse your folders to the folder where you saved the RH_dataset_didacticiel.xlsx file ;
4. Select the file and click Open.

Loading the file

A green progress bar will appear to indicate that the file has been correctly and completely downloaded.

A Download completed message confirms that the file has been successfully uploaded.

1. Click the Next button.

Editing the data model

Once the file has been downloaded, the data preview screen appears.

This step will enable us to put our data model in order so that we can build our first charts as effectively as possible.

Data preview

On the screen Analysis results of your data, click the Edit data model at the bottom right to switch to the edit mode.

In the Data selection section, there are options for:

• choose the Excel spreadsheet to be used
• choose the first row as the column header ;
• disable empty columns ;
• ignore a number of header rows.

Here, with our file, everything is already pre-configured thanks to the analysis carried out during loading by DigDash Enterprise to propose an optimal pre-configuration.

Now click the second tab, Configure the data model.

Configuring the data model

In this second tab, we will configure the data model, i.e. :

• give it a name ;
• check that the columns are correctly distributed between dimensions and measurements;
• if necessary, modify this pre-assignment;
• add calculated measurements;
• change the display labels for certain measurements or dimensions.

Naming the data model

In order to clearly identify the data model, which will make it easier to re-use in the future, we are going to name this data model "HR data".

By default, the data model takes the name of the Excel file. To rename it :

1. Enter the desired text in the first field Datamodel name.

Checking dimension and measurement assignments

Below the name of the data model is a list of the columns in the file, indicating for each column :

• its index (starting at 0)
• name (taken from the identified column header)
• the type :
  • dimension
  • geographical dimension
  • time dimension
  • measurement
• and the display name (or displayed value)

Here we are going to check that the type assigned to each column in the file is correct, and modify it if necessary. To do this, let's look at the list of columns:

• In column 7, we can see that the Postal Code is identified as a measure and not as a dimension.
  • This is because the Postal code is a series of numbers, and is therefore identified as a number and therefore a measure by DigDash Enterprise.
  • To correct this, we can select Dimension from the Type drop-down list on the right-hand panel corresponding to the settings in the Postal Code column.
    
• In column 8, we see that Satisfaction is identified as a dimension. However, this is a measure which evaluates employee satisfaction from 0 to 10.
  • This time we can select Measure from the Type drop-down list in the column parameters panel to correct this.

Adding calculated measures

Calculated measures allow you to create the measures you want from measures in the file.

The wizard offers three types of calculated measurement:

• general functions: these are standard functions:
  • calculation of a percentage of progress
  • calculating a percentage of the total
  • calculating a percentage of a measure
  • calculating a rank
• transformers : these functions can be used to create a measure that returns the value of the measure:
  • of the day - 1
  • of the week - 1
  • month - 1
  • of the year - 1
• formula : this calculated measurement lets you apply your own arithmetic formulas to the available measurements.

Together, we'll look at how to create one or more measures of each of these three types. These measures can then be integrated like all the other measures and dimensions in the graphs in the next step.
Here we are going to add measures calculated in relation to absenteeism and payroll.

Formula type measure: Absenteeism rate

Here we are going to create a measure calculating the absenteeism rate. This calculated action will use the following formula:
Number of days of absence in a month for an employee divided by 30 (30 being considered here as the number of days in a month).
To create this action:

1. Click on the Add a calculated measure button located above the parameters panel.
   

2. In the drop-down list which appears, click Formula...
3. The Formula Editor window appears.

4. Enter the name of the new calculated measure in the first field: Absenteeism rate.

To compose your formula, you need to add the measures and dimensions involved and perform the desired arithmetic operation in the Formula Script section. You can add measures and dimensions by selecting them from the drop-down lists for each category.

5. In our case, click Insert Measure in Formula.
6. Then select the measure Days Absent: the measure is added in the text box below.
7. Before adding the other measure, complete it by writing: " / (30 *) ".
8. Then insert the measure Number of rows.
9. Finish by closing the brackets.

The final formula should be as follows:

11. Finally, you can indicate the format in which this calculated formula will be displayed: choose the Percent format here.

12. Finish creating this measure by clicking OK.

The calculated Absenteeism rate measure that has just been created is displayed at the end of the column list.

Measure with Transformers type: Absenteeism rate for the previous month

Here we are going to create the calculated measure that returns the absenteeism rate for the previous month, based on the calculated measure  "Absenteeism rate" that we have just created.

1. Click the Add a calculated measure button above the parameters panel.
2. In the drop-down list that appears, click Transformers and then on Month - 1.

3. In the Month - 1 window which then appears, enter the name of the new calculated measure in the first field: Absenteeism rate for the previous month.
4. In the Source Measure drop-down list, choose the measure to which the transformer should be applied to obtain the previous month's value for this source measure.
   • Here, choose the measure calculated just recently: Absenteeism rate.

5. Finish creating this measure by clicking Ok.

The calculated measure Absenteeism rate for the previous month that has just been created is displayed at the end of the list of columns.
 

Measure with the general function type (percentage progression) : Evolution of the absenteeism rate

Here we are going to create the calculated measure that returns the evolution between the previous month absenteeism rate and the current rate, based on the first two calculated measures that we have just created.

1. Click the Add a calculated measure button above the parameters panel.
2. In the drop-down list that appears, click on General Functions and then % Progression.
3. In the % Progression window which then appears, enter the name of the new calculated measure in the first field: Rate of change in absenteeism rate.

To calculate a progression type measure, we need to indicate the first measure from which we will measure the evolution with the second measure. We will therefore insert the "oldest" measure in time in the first measure and the most recent in the second.

1. In the First measure drop-down list, choose Absenteeism rate for the previous month.
2. In the Second measurement drop-down list, choose Absenteeism rate.
3. Finally, in the Format drop-down list, leave Percentage selected by default.

4. Finish creating this measure by clicking OK.

The calculated measure Rate of change in absenteeism rate just created is displayed at the end of the list of columns.

Transformer type measure: Payroll for the previous year

We are now going to create the calculated measure returning the total payroll for the previous year, based on the measure that already exists: Annual salary.

1. Click the Add a calculated measure button above the parameters panel.
2. In the drop-down list which appears, click on Transformers and then on Year - 1.
3. In the Formula Editor window which then appears, enter the name of the new calculated measure in the first field: Payroll for the previous year.
4. In the Source measure drop-down list, choose the measure to which the transformer should be applied to obtain the previous month's value for this source measure.
   • Here, choose the measure: Annual Salary.
     

5. Finish creating this measure by clicking Ok.

The calculated measure that has just been created is displayed at the end of the list of columns.

General function measure (percentage increase) : Evolution of payroll

We are now going to create a measure to calculate the change in the total payroll between one year and year -1, using the existing measure Annual Salary and the newly created calculated measure Payroll for the previous year.

1. Click on the Add a calculated measure button above the parameters panel.
2. In the drop-down list that appears, click on General functions and then on % Progression.
3. In the % Progression window which then appears, enter the name of the new calculated measure in the first field: Evolution of payroll.

To calculate a progression type measure, we need to indicate the first measure from which we will measure the change with the second measure. We will therefore insert the "oldest" measure in time in the first measure and the most recent in the second.

1. In the First measure drop-down list, choose Payroll for the previous year.
2. In the Second measure drop-down list, choose Annual salary.
3. Finally, in the Format drop-down list, leave Percentage selected by default.

4. Finish creating this measure by clicking OK.

The calculated measure, Evolution of payroll, which has just been created, is displayed at the end of the list of columns.

We have now finished adding calculated measures.

Modifying display labels

As the final stage in configuring our data model, we will now look at how to rename the column identifiers.

These identifiers, taken from the columns in the Excel file, may not be very representative of your business area, or very meaningful, etc. It is therefore entirely possible to rename them so that they can be displayed clearly in the graphs.

In the example we are following in this tutorial, we see that the measure in column #10 is called "Annual Salary", which is inconsistent with the other measures recently created bearing the name "Wage bill".

We will therefore first rename the name "Annual salary" in column 10 to "Wage bill":

1. Move the mouse over the line in column 10"Annual salary": the line is coloured grey and a More... button appears.

2. Click More...
3. In the pop-up menu that appears, click Edit value displayed.

The field containing the value displayed can now be modified.

2. Enter Payroll.
3. Click anywhere outside the field to complete the entry.

We can do the same to rename Department Code (ISO) to Department Code :

Validate

We have now completed the steps of loading the data and configuring the data model.

You can now click on the blue button at the bottom of the list of columns: Validate configuration.

You will then return to the Analysis results page for your data.

Stage 3: Creating the customised dashboard: the first graphs

Once we've loaded the data and edited the data model, we'll move on to creating the graphs we'll use to build our first company absenteeism dashboard .

We can insert these graphs into the dashboard using an intelligent layout proposed by the Dashboard Creation Wizard.

To proceed with the creation of the dashboard, click Continue from the Analysis results page of your data.

The Build your own dashboard page then appears.

In this section, the Wizard is divided into two vertical sections:

• on the left is the chart configuration section: this is where you can configure the charts you want, before adding them to the list of charts to be inserted in the dashboard page you are creating.
• on the right is the list of charts selected for display on the dashboard page.

General operation

The charts to be displayed on the dashboard page are prepared as follows:

1. Choosing a chart from the custom charts or charts offered by DigDash Enterprise;
2. Configure dimensions and measurements;
3. Add it to the list of charts on the dashboard page being created.

This process must be repeated as many times as necessary to add a chart to the dashboard.

Creating the graphs

First, we are going to create and add four graphs relating to absenteeism in the company:

• Trend in absenteeism rate
• Number of days of absenteeism per department
• Causes of absenteeism
• Map: number of days of absenteeism by department

Creating the Trend in Absenteeism graph

In this first graph, we are going to create a Lines graph showing theevolution of the absenteeism rate over time.

This graph is already almost ready, because DigDash Enterprise's intelligence has detected that it could be used in an interesting way. That's why it's included in the Recommendations, which will enable us to configure it even more quickly!

To do this

1. In the Chart type drop-down list, select Recommendations.
2. From the available charts, click on Trend analysis.
   In the data selection box that appears, the dimension is automatically set to Date.
3. Select Absenteeism rate from the list of measures.

4. Click on the Add to dashboard button.
   The Trend (Date) Absenteeism Rate graph is then added to the Dashboard section. You can view it, rename it and even configure it in more detail in the next step!

Creating the Number of days of absenteeism by department graph

For this second graph, we're going to create a histogram showing the number of days of absenteeism per department.

To do this

1. In the Graph type drop-down list, select Comparison.
2. From the available charts, click on Columns to select a columnar representation.
   A data selection box is displayed below.
3. In the Choose a dimension drop-down list, select Service.
4. In the Choose a measure drop-down list, select Days of absenteeism.

5. Click on the Add to Dashboard button.
   The Days Absenteeism by Department graph is then added to the Dashboard section. You can view it, rename it and even configure it in more detail in the next step!

Creating the Causes of Absenteeism graph

We're now going to build a pie chart representing the distribution of causes of absenteeism.

To do this

1. From the Graph type drop-down list, select Comparison.
2. From the available charts, click on Sectors to select a pie chart.
   A data selection box is displayed below.
3. In the Choose a dimension drop-down list, select Reason for absenteeism.
4. From the Choose a Measure drop-down list, select Days Absent.

5. Click on the Add to Dashboard button.
   The Causes of Absenteeism by Department graph is then added to the Dashboard section. You can view it, rename it and even configure it in more detail in the next step!

Creating a chart Absenteeism rate by department

We're now going to create a map showing the absenteeism rate by department. This chart is already almost ready, because DigDash Enterprise's intelligence has detected that it could meet an interesting use case. This is why it is included in the Recommendations, which will enable us to configure it even more quickly!

To do this

1. In the Chart type drop-down list, select Recommendations.
2. From the available charts, click on Geographical Analysis.
3. In the data selection box that appears, select Department Code from the list of dimensions.
4. Then select Absenteeism rate from the list of measures.

4. Click on the Add to dashboard button.
   The Number of days of absenteeism by department graph is then added to the Dashboard section. You can view it, rename it and even configure it in more detail in the next step!

Naming the dashboard

Before continuing, don't forget to name the dashboard.

At the very top of the page, in the Dashboard name field, you can enter the name of the new page being created.
Enter Absenteeism here .

Choosing the layout

We have just created 4 graphs, which will be the graphs of the Absenteeism dashboard.

DigDash Enterprise offers several layouts for arranging these graphs on a page. These layouts automatically arrange the charts on the page, to save you time.

At the bottom of the list of charts to be inserted into the page you are creating, notice"Layout selected: Automatic".

By clicking on the button, a drop-down list appears with several layout choices.
At the very top, the first choice is Automatic : DigDash Enterprise will take care of all the layout logic.
At the bottom of this first choice, you can adjust the automated layout according to your preferences.

Note the different symbols in the layout zones: they correspond to the content that will be added automatically:

• graphic
• dimensions for filtering
• filtered elements

1. Select the Graphics + filters layout on the left.
2. Close the drop-down list using the cross at the top right.
3. The selected layout is then updated with: Graphics + Filters on the left.

After this last step, we'll leave the Wizard and return to theDashboard Editor to fine-tune the dashboard.

Click Finish and build the dashboard at the bottom right of the Dashboard Creation Wizard window :

• The DashboardCreation Wizard closes.
• The data model is saved.
• The Absenteeism dashboard page is displayed in theDashboard Editor with the 4 graphs we have just created.

Step 5: Finalising the Absenteeism dashboard page

Once we've loaded the data, edited the data model and configured the graphs we want to see in our first corporate absenteeism dashboard, we've reached the end of the road! We've just returned to the Dashboard Editor, and the 4 configured graphs are already displayed on our 'Absenteeism' page.

So this part of the tutorial will show us how to fine-tune the page we've just created. In particular, we'll see :

• how to add dimensions as filters ;
• how to modify graphics that have already been created;
• how to rename and access the properties of graphics.

This part will also be an opportunity to familiarise ourselves further with the editor.

Back to the Dashboard Editor

In the previous section, we configured the first charts.

They are now arranged on your first dashboard page, which you are now viewing in the editor.

Let's look at a few things by following the numbered elements above:

1. The page created belongs to your personal role and has the name you chose in the previous step: Absenteeism page belonging here to the personal role John.
2. The Filtered Items section has been automatically added: this space will allow you to list the dimensions that have been filtered (and the members to which these filters apply).
3. The Information Flow (Existing Graphs) section has been opened:
   • this section contains all the charts we created in the previous step;
   • Note that the role (or portfolio) open is your personal role; later, you will be able to open another portfolio for your organisation;
   • in the event that you accidentally delete one of the graphs inserted on the page, you can reposition it on the page from this space by simply dragging and dropping it to the desired area on the page;
   • Note also that the 4 graphs on the current dashboard are all grouped together in a category with the same name as the page created.
4. At any time, you can view the dashboard in its final state by clicking on the Access the dashboard button .
   This switch to viewing also allows you to save the changes you have made in the editor.

Let's now move on to finalising this first page dedicated to absenteeism.

Finalising the page

Adding filters

Any self-respecting dashboard should be able to offer its users the option of filtering on its dimensions. That's what we're going to do now. We're going to add the "Date", "Department" and "Gender" dimensions as filters.

To do this:

1. In the left-hand column of the page you are editing, notice the three rectangles inviting you to"Drag and Drop Dimension".
   It is in these three zones that we are going to insert our three dimensions.
2. Click on the Dimension link in the first rectangle: the Filters/Variables section opens in the left-hand banner with the list of Dimensions.
3. Drag and drop the Date dimension onto the first rectangle: the date filter elements will then be displayed there.
4. Repeat the operation for the Department dimension and the Gender dimension, using the other 2 rectangles.
   

Note that the Date dimension displays its members in day/month/year format.
To switch to year format :

1. Hover the mouse over this Date dimension.
2. Click on the cogwheel  which appears.
3. Select Settings in the pop-up menu, then Properties: the Date panel then opens in the Properties section on the right of the dashboard.

4. In the Hierarchy drop-down list, select Date.
5. In the Level drop-down list, select Year.
6. Further down, in the View Type drop-down list , select Vertical List.

7. Click on OK.

Renaming graphs

As you will no doubt have noticed, automatically constructed graphs have automatically generated names which are sometimes difficult to understand.

In this section, we are going to rename the graphs so that they have a more meaningful name.

To do this

1. Hover the mouse over the graph Trend (Date) Absenteeism rate.
2. Click on the cogwheel  which appears in the top right-hand corner.
3. Click Rename in the context menu.
4. In the Rename dialog box that appears, enter the new name: Trend in absenteeism rate.
5. Click OK to confirm.

You can also open the Rename box by double-clicking on the title of the graph.

Do the same to rename :

• Days Absenteeism by Department to Number of Days Absenteeism by Department
• Absenteeism days by reason for absenteeism in Causes of absenteeism
• Absenteeism Rate by Department Code to Absenteeism Rate by Department

Modifying graphs that have already been created

Now that your page is starting to take shape, that it contains filters and that its graphs have meaningful names, it is important that the graphs are free of inconsistencies and comply with rules that may be specific to your company or the way your department operates.

That's why we offer you the option of making in-depth changes to existing graphs, always from the editor.

Here, we will look at how to :

• change the level of the Date dimension of the Evolution of absenteeism rate graph to display dates at quarter level ;
• add sorting on the measure for the Number of days of absenteeism by department histogram;
• change the colours of the Absenteeism Rate by Department chart.

General operation

First of all, let's explain how modifying graphs already created in the editor works in general:

• When you hover the mouse over the graph area, a graph icon appears. appears in the top right-hand corner.
• Click on it to open the graph editing area.
• In this editing area :
  • the central area shows a preview of the changes you have made ;
  • the left-hand column shows a number of elements and options, including the dimensions and measurements which can be added to or substituted for each graph;
  • When you hover over this left-hand column, a configuration zone appears above the central preview area:
    • This is where you can add measurements and dimensions by dragging and dropping from the left-hand column;
    • This is also where you can modify the configuration of the dimensions and measurements already in place;
• Once you have completed your modifications, you can save them by clicking on the Save button  button at the top right.

Trend in absenteeism rate: display dates in quarterly format

In this first chart, we're going to enter edit mode to display the dates in the online chart in quarter format.

To do this

1. Hover over the Absenteeism rate by date graph area in the editor page .
2. Click on the graph icon  which appears: the editing area for this graph is displayed.
3. In the left-hand column, in the Dimensions section, click on Date...
4. Locate the hierarchy/level pair Month Year / Quarter
5. Drag and drop this hierarchy/level pair onto the Abscissa axis.
6. Save your changes using the Save icon in the top right-hand corner
   The dates in the graph are now displayed in quarter format!

Number of days of absenteeism by department: sort by measure

In this second graph, we're going to enter graph modification mode to define a sort by measure.

To filter on the Days Absenteeism measure :

1. Hover over the Number of days of absenteeism by department graph area in the editor page.
2. Click on the graph icon  which appears: the modification area for this graph is then displayed.
3. In the configuration area, right-click on Column.
4. In the pop-up menu that appears, click on Change Sorting : the Add Sorting dialog box appears

5. In the Sort drop-down list, select Sort descending on measure.
6. In the Measure drop-down list, keep the Days of absenteeism selection.

6. Click OK: The columns are now sorted from the highest to the lowest number of days of absenteeism.

7. Save the changes using the Save button in the top right-hand corner. .

Absenteeism rate by department: changing the colours used

Here we are going to enter the graph modification mode in order to change the colours used in the mapping. As it stands, the default colours do not allow you to differentiate between the different rates at first glance.

1. Hover over the Absenteeism rate by department graph area in the editor page.

2. Click on the graph icon  which appears: the editing area for this graph is displayed.

3. In the left-hand area, click on Style..., then on Colours . .. 
   The Select colour palette box appears.
   By default, the "Flat Design" colour palette is selected.

4. Select the Flat Design 04 palette.
5. Click OK : the colours are modified for better viewing.

6. Then save the changes using the Save button.  button at the top right.

Step 6: Creating a second Payroll dashboard page

Having created the first page of our absenteeism dashboard, we're now going to create a second page dedicated to payroll.

We'll be looking at

• how to add a new page ;
• how to create new graphs from the data source added and modelled in the previous sections; and
• and how to insert and configure these new graphs in the new page.

Adding a new page and choosing a layout

As we saw earlier, the Absenteeism page belongs to your personal role, with your user name. We're going to add a second page, still in this personal role. During creation, we will choose a layout for our new page.

1. Click on the + symbol to the right of the Absenteeism page.

1. The Add a page box appears.
2. Enter the name of the page: Payroll.
3. We are now going to choose how the page is displayed: click on Templates... 
   ➡ The Choose template window appears.
4. For greater consistency with the previous page, we're going to choose the same layout: click on Charts + filters on the left.

6. Confirm the creation of the new page by clicking OK again in the Add a page box.

The new Payroll page now appears.

Creating new charts

The new Payroll page has now been created! We're now going to configure the new graphs.

How the editor works to create new graphs

On the left-hand side of our pages, the Information flows (Existing graphs) section is open and shows the information flows that already exist.

Let's open the panel below Creating new graphs by clicking on it. The chart configuration tool is similar to the one we used earlier in the wizard.

Note that the Historical HR Data data model is automatically selected. It is from this data model that we will create our new graphs on the wage bill.

Creating the graph Payroll trends by department over the last year

This first chart, in the form of a table, will show changes in the total wage bill by department. We will then apply a filter to show changes in each department over the last year only.

Configuration

1. In the Create new charts section, select the Chart type option if required and locate the Tables sub-section.
2. Select Cross table and drag and drop to the first rectangle Drag and drop Chart at top left.

The Create a new chart box appears.

3. Enter the name of the chart: Evolution of payroll by department.

In this table, we are going to represent, for each department, the payroll for the previous year, the payroll for the current year and the rate of change between these two years. We will therefore need one dimension and three measures to configure this table.

4. In the Choose a dimension drop-down list, tick the Service dimension.
5. In the Choose a measure drop-down list, tick the measures:
   • Previous year's payroll
   • Total payroll
   • Rate of change in payroll

6. Click Add Chart to confirm: the Payroll trends by department table is added to the dashboard page.

Filtering

We are now going to filter this chart so that it takes into account the last year of our dataset. The filter we create here will be exclusive to this chart and will not be propagated to the other charts.

1. Position the mouse cursor over the chart.
2. Click on the cogwheel which appears at the top right of the graph.
3. In the pop-up menu that appears, click on Settings then Properties: the Payroll trends by department panel then opens in the Properties section on the right of the dashboard.
4. Below Properties, click on the Filters tab.
   In this tab, the dimensions that can be filtered are displayed: there are currently no filters configured.
5. Click on the All filter corresponding to the Date dimension.

The Filter: Date dialog box appears, allowing you to configure the filter.

6. From the Filter Type drop-down list, select Predefined.

7. In the second Context drop-down list, select Max date of data.
8. In the last Member drop-down list, select Year.

9. Click OK to confirm: the new graph is added to the dashboard page.

Creating the Evolution of payroll graph

We are now going to create a second graph, in the form of a curve, which will represent the evolution of the total payroll over the years. To do this

1. In the Create new charts section, select Recommendations.
2. From the list of suggested charts, select  and drag and drop to the second rectangle Drag and drop Graph at top right. The Create a new graph box appears.
3. Enter the name of the chart: Evolution of payroll.
4. In the Choose a dimension drop-down list, tick the Service dimension.
5. In the Choose a measure drop-down list, tick the measures.
6. The dimension is automatically set to Date.
7. In the Measure drop-down list, tick Payroll.

6. Click on Add graph : the new Evolution of payroll graph is added to the dashboard page.

Creating the Payroll by Department graph

We are now going to create a third chart, this time in sectors, which will represent the breakdown of payroll by department.

1. In the Create new charts section, select Chart type.
2. Locate the Comparison sub-section .
3. Selec t  and drag and drop to the third rectangle Drag and drop Graph at bottom left.
    The Create a new graph box appears.
4. Enter the name of the graph: Payroll by department.
5. In the Choose a dimension drop-down list, tick Department.
6. In the Choose a measure drop-down list, tick Payroll.

7. Click on Add graph : the new Payroll by department graph is added to the dashboard page.

Creating the Payroll by department and gender graph

Finally, we're going to create a fourth chart, a histogram, which will show the breakdown of payroll by department while also allowing the gender distinction to be represented.

Configuration

1. In the Create new charts section, select Chart type.
2. Locate the Comparison sub-section .
3. Selec t  and drag and drop to the fourth rectangle Drag and drop Graph at bottom right.
    The Create a new graph box appears.
4. Enter the name of the graph: Payroll by department and type.
5. In the Choose a dimension drop-down list, tick Gender then Department.
6. In the Choose a measure drop-down list, tick Payroll.

7. Click on Add graph : the new Payroll by department and gender graph is added to the dashboard page.

Application of a meaningful colour palette

To make the chart more readable, we're going to apply a more meaningful colour palette to the data. To do this

1. Position the mouse cursor over the graph.

2. Click on the graph icon  which appears at the top right: the editing area for this graph is displayed.

3. In the left-hand area, click on Style..., then on Colours . .. : the Select colour palette box appears.
4. Select the Color Gender colour palette .

The colours in the palette are applied automatically and a warning message is displayed.

7. Save by clicking on the Save button button in the top right-hand corner: the graph editing area closes.

Adding filters

Our page is almost ready. All that remains, as we did for the previous page, is to add the dimensions to enable us to filter in view mode.

To do this:

1. In the left-hand column of the page you are editing, notice the three rectangles inviting you to"Drag and Drop Dimension".
   It is in these three areas that we are going to insert our three dimensions.
2. Click on the Dimension link in the first rectangle: the Filters/Variables section opens in the left-hand banner with the list of Dimensions.
3. Drag and drop the Date dimension onto the first rectangle: the date filter elements will then be displayed there.
4. Repeat the operation for the Department dimension and the Gender dimension, using the other 2 rectangles.
   

Note that the Date dimension displays its members in day/month/year format.
We're going to switch to year format:

1. Hover the mouse over this Date dimension.
2. Click on the cogwheel  which appears.
3. Select Properties in the pop-up menu, then Settings: the Date panel then opens in the Properties section on the right of the dashboard.
4. In the Hierarchy drop-down list, select Date.
5. In the Level drop-down list, select Year.
6. Further down, in the View Type drop-down list , select Horizontal list.

7. Click on OK.

Step 7: Viewing the dashboard

You can now view the final result of your work!

To do this, as you saw before, click on the Access the dashboard button .  button at the top right of the window.

You can now navigate your 2 Absenteeism and Payroll dashboard pages and test the use of the filters.

Congratulations!

From our Excel file, we were able to create a real dashboard using the DigDash Enterprise Dashboard Creation Wizard.

We saw how to :

• load a file ;
• edit the data configuration and create a data model;
• configure charts based on this data model;
• configure dashboard pages to add filters;
• modify the default view generated by going into more detail in the parameters.

Going further

You can go even further!

With the Studio, DigDash Enterprise lets you go into more detail about configuring your data models, connect to your databases or join or combine several data sources.

Don't hesitate to get in touch with your DigDash Enterprise administrator or your DigDash referral contact to discuss this!