Last modified by baudard on 2022/04/11 09:45
Show last authors
1 {{info}}
2 ⏱ This tutorial is intended to be completed independently **in two hours**.
3 {{/info}}
4
5
6 {{ddtoc/}}
7
8 ----
9
10 = Introduction =
11
12 During this tutorial, we will discover the **Dashboard Creation Wizard**.
13
14 Included in the dashboard editor, this feature allows you to quickly create your charts from your data file, without any intermediate step.
15
16 From an example dataset of the human resources of a company in Ile de France (the France's capital administrative region), we will carry out all the stages from the loading of the data to the creation of the graphs and their integration into the dashboard pages.
17
18 {{info}}
19 The screenshots for this tutorial were generated using the Chrome browser.
20
21 Depending on your browser, some presentations may differ slightly.
22 {{/info}}
23
24 = Prerequisite =
25
26 In order to be able to perform this tutorial, it is required to:
27
28 * have an installation of DigDash Enterprise of version 2020R2 or more recent;
29 * be part as a user of the "End User for Self-Service BI" authorization group;
30
31 This part discusses this two prerequisites.
32
33 == Prerequisite 1 : DigDash Enterprise (2020R2 ou plus récent) ==
34
35 (% class="wikigeneratedid" id="HInstallation" %)
36 **Installation**
37
38 * In case you need to perform the installation yourself, contact your administrator or your contact, and follow this tutorial to perform the installation. Then go to the Connection part of this tutorial.
39 * If you already have a link to connect to a DigDash Enterprise installation, as well as connection identifiers, go directly to the Connection part of this tutorial.
40
41 (% class="wikigeneratedid" id="HVersion" %)
42 **Version**
43
44 * To be able to follow this tutorial, it is necessary to use a version 2020R2 or more recent of DigDash Enterprise ;
45 * To find out which version you are currently accessing, go to the address given to you by your DigDash administrator ;
46 * In the page that appears, at the bottom left, in the white area, you can find out which version of the installation is in use.
47
48 (% style="text-align:center" %)
49 [[image:en_verifier_version.gif]]
50
51 == Prerequisite 2 : authorizations group "End User for Self-service BI" ==
52
53 * To be able to use the Dashboard Creation Wizard functionality, your DigDash Enterprise user account must be part of the** "End User for Self-service BI"** authorization group.
54 * If you do not have administration rights, or in case of doubt, contact your DigDash Enterprise administrator.
55
56 = Connection to the dashboard editor =
57
58 Once the prerequisites of the previous part have been verified, we can now proceed to the connection to the Dashboard Editor.
59
60 It is from this editor that we will launch the Dashboard Creation Wizard.
61
62 This part will allow us to connect for the first time to DigDash Enterprise and to briefly tour the home page that you will access, before accessing and discovering the Dashboard Editor
63
64 == Connection to DigDash Enterprise ==
65
66 === Connection to home page ===
67
68 (% class="wikigeneratedid" id="HConnexiondanslecasd27uneinstallationenlocalsurvotreordinateur" %)
69 **Connection in the case of a local installation on your computer**
70
71 * First, make sure your DigDash Enterprise installation is already started.
72 ** If it's not the case :
73 *** go to the DigDash Enterprise installation directory on your computer.
74 *** double click on the start_tomcat.bat file to run it.
75 *** double-click on the home_page.bat file to run it: your default browser will open the DigDash Enterprise home page.
76 ** You can also directly follow the following link from your browser: [[http:~~/~~/localhost:8080/>>http://localhost:8080/]]
77
78 (% class="wikigeneratedid" id="HConnexiondanslecasd27uneinstallationenlignemiseE0disposition" %)
79 **Connection in the case of an online installation**
80
81 * First, make sure you have the Internet address of the DigDash Enterprise installation as well as your username and password.
82 ** This information must have been provided to you previously by your DigDash Enterprise administrator.
83 ** In case of any doubt, do not hesitate to contact your DigDash Enterprise administrator
84 * Go, using your internet browser, to the address given to you.
85
86 === Home page tour ===
87
88 * Once the previous connection step has been completed, you will see the following page appear in your browser:
89
90 (% style="text-align:center" %)
91 [[image:en_admin_console.png]]
92
93 (% class="wikigeneratedid" id="HAideaccessibledepuislapaged27accueil" %)
94 **Help accessible from the home page**
95
96 * A documentation section is present in the white triangular insert at the bottom left;
97 * Within this insert, you will be able to find the various documentations if necessary.
98
99 (% style="text-align:center" %)
100 [[image:en_adminconsole_encart_documentation.gif]]
101
102 (% class="wikigeneratedid" id="HMenudelaconsoled27administration" %)
103 **Home page menu**
104
105 (% class="wikigeneratedid" id="HDashBoard" %)
106 //DashBoard//
107
108 (% style="text-align:center" %)
109 [[image:bouton_dashboard.png]]
110
111 * This menu item allows you to access dashboards already completed by you or your team.
112 * It is from this menu that you will be able to view the dashboard built in the wizard.
113
114 (% class="wikigeneratedid" id="HEditeurdetableauxdebord" %)
115 //Dashboard Editor//
116
117 (% style="text-align:center" %)
118 [[image:en_bouton_editor.png]]
119
120 * This menu item takes you to the dashboard edit.
121 * In this tutorial, we will mainly focus on this part of DigDash Enterprise
122
123 (% class="wikigeneratedid" id="HAutresE9lE9mentsdumenu" %)
124 //Other menu items//
125
126 * As you will have noticed, the home page contains three other menus: Configuration, Desktop Studio and Web Studio;
127 * These menus cover advanced configuration features and items that are not covered in this tutorial.
128
129 == Access to the dashboard editor ==
130
131 === Connection to the editor ===
132
133 * From the home page click on the "Dashboard editor" button ;
134 * A login page then opens;
135 * Enter your username and password.
136
137 (% style="text-align:center" %)
138 [[image:en_dashboardEditor_connexion.gif]]
139
140 (% class="wikigeneratedid" id="HDE9couvertedel27E9diteur" %)
141 **Editor tour**
142
143 (% class="wikigeneratedid" id="HBarresupE9rieure" %)
144 //Top bar//
145
146 The top bar of the dashboard editor presents several features and options :
147
148 * a help menu
149 * the dashboard creation wizard
150 * switching to consultation mode of the dashboard being edited
151 * a menu that can be deployed from the username with several advanced options
152
153 (% style="text-align:center" %)
154 [[image:en_dashboardEditor_bandeauSuperieu.gif||alt="en_dashboardEditor_bandeauSuperieur.gif"]]
155
156 (% class="wikigeneratedid" id="HRF4lesetpages" %)
157 //Roles and pages//
158
159 * In the central space are presented the dashboard pages;
160 * When you log in for the first time, a page called "My Dashboard" is automatically created;
161 * The list of roles is presented above the list of pages;
162
163 (% style="text-align:center" %)
164 [[image:en_dashboardEditor_rolesEtPages.gif]]
165
166 {{info}}
167 Roles are a collection of data sources and charts attached to these sources.
168
169 * Each user has a personal role, created automatically in DigDash Enterprise;
170 ** It is in this role that each user can create their graphics;
171 ** **It is also in this role that the data source and the graphics generated in the wizard will be positioned;**
172 * In addition to this personal role, your organization may have common roles, useful for collaborative work and for sharing dashboards between multiple team members.
173 {{/info}}
174
175 * Each page of the dashboard is associated with a role:
176 ** thus, the "My Dashboard" page belongs to the "Luke" role;
177 ** this role is personal: it bears the name of the user, and only him has access to it;
178
179 (% class="wikigeneratedid" id="HAccE8sE0l27Assistant" %)
180 //Access to the wizard//
181
182 * From the dashboard editor, in the top banner, click the icon [[image:dashboard-editor-assistant.svg||queryString="width=22&height=22" height="22" width="22"]] ;
183 * The wizard window then opens ;
184
185 = Loading data and editing the data model =
186
187 After making the first connection to DigDash Enterprise and familiarizing ourselves with the home page and the dashboard editor, we will now learn about the Dashboard Creation Wizard.
188
189 The first step will be to load the data. Secondly, we will edit the model in order to configure new measures and make sure we have the correct model to make our first graphs.
190
191 {{info}}
192 **💡 Good to know **: In the Wizard interface, dark blue items are displayed to guide you.
193 In these sections, the texts in light blue can be hovered to display contextual help.
194
195 (% style="text-align:center" %)
196 [[image:contextual_info.png||alt="Example of contextual help inside the Wizard"]]
197 {{/info}}
198
199 {{warning}}
200 In the context of this tutorial we will rely on a [[file available here>>attach:RH_dataset_tutorial_EN.xlsx]] : **RH_dataset_tutorial_EN.xlsx**;
201
202 * This Excel file contains a dummy data set of the human resources of a company located in Ile de France;
203 * This dataset is historized by month, and also presents geographic data;
204 {{/warning}}
205
206 == Loading data ==
207
208 === File selection ===
209
210 * To move through the Wizard and create our charts, we have two choices:
211 ** use a demonstration source;
212 ** or use a local file;
213 * These two choices are offered to us when the wizard opens;
214 * Click on **Select a file from your computer;**
215 * A window from your operating system will then open;
216 * Browse your folders to the folder where you saved the **RH_dataset_tutorial_EN.xlsx** file;
217 * Select this file and click Open ;
218
219 (% style="text-align:center" %)
220 [[image:en_load_dataset_excel.gif]]
221
222 === Loading file ===
223
224 * The progress bar, in green, is completed to indicate the correct and complete loading of the uploaded file;
225 * A **Loading completed** message confirms the successful loading;
226 * Then click on the blue button at the bottom: **Next**
227
228 {{info}}
229 **💡 **​​​​​​**Good to know **: if your Excel file contains several pages, the wizard will automatically ask you from which page you want to work
230
231 Here, our file for this tutorial contains only one page, so this choice is not offered by the Assistant.
232 {{/info}}
233
234 === Editing the data model ===
235
236 * After loading the file, a new screen appears;
237 * Click **Edit data source**;
238
239 This step will allow us to put our data model in order to better build our first charts.
240
241 (% style="text-align:center" %)
242 [[image:en_goto_edit_DM.gif]]
243
244 === Data preview ===
245
246 * The screen that appears is divided into two tabs: the first allows you to preview the data
247 * In this tab, you can modify the sheet to be used in the Excel workbook.
248 * Options also allow:
249 ** to choose the first line as the header;
250 ** disable empty columns;
251 ** and ignore a number of header lines.
252 * Here, with our file, everything is already preconfigured due to the analysis carried out during the loading by DigDash Enterprise to offer you an optimal preconfiguration.
253 * Now click on the second tab **Configure the data model**
254
255 (% style="text-align:center" %)
256 [[image:en_goto_edit_DM_tab2.gif]]
257
258 === Configuration of data model ===
259
260 {{error}}
261 ❗​​ ​ **Warning**: it is **essential to follow this step**. Changes can no longer be made after validation of the configuration.
262 {{/error}}
263
264 * In this second tab, we will configure the data model, that is to say:
265 ** give it a name;
266 ** check that the columns are well distributed between dimensions and measures;
267 ** if necessary modify this pre-assignment;
268 ** add calculated measures;
269 ** change the display labels for certain measures or dimensions.
270
271 {{info}}
272 **💡 **​​​​​​**Good to know **:
273
274 * A **dimension** is composed of a finite set of members possibly organized according to one or more hierarchies. 
275 In the wizard, **a dimension is symbolized by this blue cube : [[image:dimension.svg||height="22" width="22"]]**
276 * A **measure** is a quantity to represent that can be calculated.
277 In the wizard, **a measure is symbolized by this blue circle** ** : [[image:measure.svg||height="22" width="22"]]**
278 {{/info}}
279
280 (% class="wikigeneratedid" id="HNommagedumodE8lededonnE9es" %)
281 **Naming the data model**
282
283 * In order to clearly identify the data model, which will promote its future reuse, we will name this data model "**HR datas**";
284 * By default, the data model takes the name of the Excel file
285 * To rename it, enter the desired text in the first field corresponding to **Datamodel's name**.
286
287 (% style="text-align:center" %)
288 [[image:en_rename_DM.gif]]
289
290 (% class="wikigeneratedid" id="HVE9rificationdesassignationdimensionsetmesures" %)
291 **Verification of dimension and measure assignments**
292
293 * Below the name of the data model, a list shows the columns of the file and indicates for each column:
294 ** its index (starting at 0)
295 ** the name (from the identified column header)
296 ** the type :
297 *** dimension
298 *** geographic dimension
299 *** time dimension
300 *** measured
301 ** and the display caption (or displayed value)
302
303 {{info}}
304 **💡 **​​​​​​**Good to know **: a measure calculating the number of rows is automatically created: this is the **Row Count** measure (index 13).
305 {{/info}}
306
307 * Let's go through the list of columns:
308 ** in column 7, we observe that the Postal Code is identified as a measure and not as a dimension
309 *** this is explained by the fact that the Postal Code is a sequence of numbers, and is therefore identified as a number and therefore a measure by DigDash Enterprise
310 *** to correct this oddity, we can select Dimension in the drop-down list associated with this colum
311
312 [[image:en_Edit_DM_change_measure_to_dimension.gif]]
313
314 * in column 8, we see that Satisfaction is identified as a dimension. However, this is a measure assessing employee satisfaction from 0 to 10
315 ** this time we can select Measure in the drop-down list associated with the column to correct this
316
317 [[image:en_Edit_DM_change_dimension_to_measure.gif]]
318
319
320 (% class="wikigeneratedid" id="HAjoutdemesurescalculE9es" %)
321 **Adding calculated measures**
322
323 * Calculated measures allow you to create the measures you want from the measures and the dimensions yet included in the file.
324 * In the wizard, three types of calculated measures are proposed:
325 ** **general functions**: these are classic functions:
326 *** calculating a percentage of progress
327 *** calculating a percentage of the total
328 *** calculating a percentage of a measure
329 *** calculating a rank
330 ** **transformers**: these functions are used to create a measure returning the value of the measure:
331 *** of the day - 1
332 *** of the week - 1
333 *** of the month - 1
334 *** of the year - 1
335 ** **formula**: this calculated measure allows you to apply your own arithmetic formulas on the available measures.
336 * We will see together how to create one or more measures of each of these three types
337 * These measures can then be integrated like all the other measures and dimensions in the graphs in the next step.
338
339 (% class="wikigeneratedid" id="HTauxd27absentE9isme28formule29" %)
340 **//Absenteeism rate (formula)//**
341
342 Here we are going to create the measure calculating the absenteeism rate.
343
344 This calculated measure will use the following formula: //Number of days of absence over a month for an employee divided by 30 //(30 being considered here as the number of days over a month).
345
346 * At the bottom of the column list, click on the **Add a calculated measure** button;
347 * A context menu appears ;
348 * Click on **Formula ...**;
349 * The **Formula Editor** window is displayed;
350
351 (% style="text-align:center" %)
352 [[image:en_Edit_DM_ajout_measure_formule.gif]]
353
354 * First, indicate the name of the new calculated measure being created in the first field: **Absenteeism rate**;
355
356 (% style="text-align:center" %)
357 [[image:en_Edit_DM_ajout_measure_formule_name_measure.gif]]
358
359 * To compose your formula, you must add the measures and dimensions involved and perform the desired arithmetic operation in the** Formula Script** part:
360 ** You can add measures and dimensions by selecting them from the drop-down lists corresponding to each of the categories;
361 *** In our case, click on **Insert Measure In Formula**
362 *** Then choose the **Absenteeism days** measure
363 *** The measurement is added in the text box below.
364 *** Before adding the other measure, complete by writing: **"/ (30 ***"
365 *** Then insert the measure **Number of lines**
366 *** **Finish by closing the parenthesis**
367 ** The final formula should be as follows:
368
369 {{code cssClass="notranslate"}}
370 'Absenteeism days(sum)'/(30 * 'Row Count(sum)')
371 {{/code}}
372
373
374 (% style="text-align:center" %)
375 [[image:en_Edit_DM_ajout_measure_formule_write_formula.gif]]
376
377 * Finally you can indicate the format in which this calculated formula will be displayed.
378 ** Here, choose the format **Pourcentage (Percentage)**.
379
380 (% style="text-align:center" %)
381 [[image:en_Edit_DM_ajout_measure_formule_change_format.gif||alt="Edit_DM_ajout_measure_formule_change_format.gif"]]
382
383 * Complete the creation of this measurement by clicking on **Ok**
384 * The newly created calculated measure** Absenteeism Rate** is displayed at the end of the column list.
385
386 (% style="text-align:center" %)
387 [[image:en_Edit_DM_ajout_measure_formule_valider_measure.gif||alt="Edit_DM_ajout_measure_formule_valider_measure.gif"]]
388
389 (% class="wikigeneratedid" id="HTauxd27absentE9ismedumoisprE9cE9dent28transformateurm-129" %)
390 //**Absenteeism rate of previous month (transformer m-1)**//
391
392 Here we are going to create the calculated measure returning the absenteeism rate for the previous month, based on the calculated measure "Absenteeism rate" that we have just created.
393
394 * At the bottom of the columns' list, click on **Add a calculated measure**  ;
395 * A context menu appears ;
396 * Click on** Transformers **then on **Month- 1** ;
397 * The window **Month - 1** appears then ;
398
399 (% style="text-align:center" %)
400 [[image:en_Edit_DM_ajout_measure_transformateur.gif||alt="Edit_DM_ajout_measure_transformateur.gif"]]
401
402 * First, enter the name of the new calculated measure being created in the first field: **Absenteeism rate (previous month)** ;
403 * Int he drop-down list **Source Measure**, choose the measure to which you want to apply the transformer to obtain the value of the previous month of this source measure. 
404 ** Here, choose the recently created calculated measure : **Absenteeism rate**
405
406 (% style="text-align:center" %)
407 [[image:en_Edit_DM_ajout_measure_transformateur_create.gif||alt="Edit_DM_ajout_measure_transformateur_create.gif"]]
408
409 * Complete the creation of this measure by clicking on **Ok** ;
410 * The newly created calculated measure **Taux d'absentéisme du mois précédent **is displayed at the end of the list of columns.
411
412 (% style="text-align:center" %)
413 [[image:en_Edit_DM_ajout_measure_transformateur_validation.gif||alt="Edit_DM_ajout_measure_transformateur_validation.gif"]]
414
415 (% class="wikigeneratedid" id="HTauxd27E9volutiondutauxd27absentE9isme28gE9nE9raledeprogression29" %)
416 //**Evolution rate of absenteeism (general function : progression)**//
417
418 Here we are going to create the calculated measure returning the evolution between the previous absenteeism rate and the current rate by relying on the first two calculated measures that we have just created.
419
420 * In the bottom of the columns' list, click on **Add a calculated measure** ;
421 * A context menu appears ;
422 * Click on **General functions **then on **% Progression** ;
423 * The window **% Progression** appears ;
424
425 (% style="text-align:center" %)
426 [[image:en_Edit_DM_ajout_measure_progression.gif||alt="Edit_DM_ajout_measure_progression.gif"]]
427
428 * First, enter the name of the new calculated measure being created in the first field: **Evolution rate of absenteeism** ;
429 * To calculate a progression type measurement, we must indicate the first measure from which we will measure the evolution with the second measure. We will therefore insert the temporally "oldest" measure in the first measure and the most recent in the second.
430 ** Here, on the drop-down list **First measure**, choose **Absenteeism rate (previous month)** ;
431 ** Then, on the drop-down list **Second measure**, choose **Absenteeism rate** ;
432 * Complete the creation of this calculated measure by clicking on **Ok** ;
433 * The newly created calculated measure **Evolution rate of absenteeism** is displayed at the end of the columns' list.
434
435 (% style="text-align:center" %)
436 [[image:en_Edit_DM_ajout_measure_progression_creation.gif||alt="Edit_DM_ajout_measure_progression_creation.gif"]]
437
438 (% class="wikigeneratedid" id="HMassesalarialedel27annE9eprE9cE9dente28transformateurn-129" %)
439 //**Payroll of previous year (transformer y-1)**//
440
441 Now, we are going to create a calculated measure returning the payroll of the previous year, relying on a already existing measure : **Annual salary**.
442
443 * In the bottom of the columns' list, click on **Add a calculated measure** ;
444 * A context menu appears ;
445 * Click on **Transformers **then on **Year - 1** ;
446 * The window **Year - 1** appears ;
447
448 (% style="text-align:center" %)
449 [[image:en_Edit_DM_ajout_measure_transformation_annee.gif||alt="Edit_DM_ajout_measure_transformation_annee.gif"]]
450
451 * First, enter the name of the new calculated measure being created in the first field: **Payroll (previous year)** ;
452 * On the drop-down list **Source measure**, choose the measure to which you want to apply the transformer to obtain the value of the previous year of this source measure. 
453 ** Here, choose the measure : **Annual salary** ;
454 * Complete the creation of this calculated measure by clicking on **Ok** ;
455 * The newly created calculated measure displays at the end of the columns' list.
456
457 (% style="text-align:center" %)
458 [[image:en_Edit_DM_ajout_measure_transformation_annee_creation.gif||alt="Edit_DM_ajout_measure_transformation_annee_creation.gif"]]
459
460 (% class="wikigeneratedid" id="HTauxd27E9volutiondelamassesalariale28gE9nE9raledeprogression29" %)
461 //**Evolution rate of payroll (general function : progression) **//
462
463 We are now going to create the measure that will return the rate evolution of payroll between a year and a previous year, relying on the already existing measure **Annual salary** and the the recently created calculated measure **Payroll (previous year)**.
464
465 * In the bottom of the columns' list, click on **Add a calculated measure** ;
466 * A context menu appears ;
467 * Click on **General functions** then on **% Progression** ;
468 * The window **% Progression** appears ;
469
470 (% style="text-align:center" %)
471 [[image:en_Edit_DM_ajout_measure_evolution_masse_salariale.gif||alt="Edit_DM_ajout_measure_evolution_masse_salariale.gif"]]
472
473 * First, enter the name of the new calculated measure being created in the first field : **Taux d'évolution de la masse salariale** ;
474 * To calculate a progression type measurement, we must indicate the first measure from which we will measure the evolution with the second measure. We will therefore insert the temporally "oldest" measure in the first measure and the most recent in the second.
475 ** Here, on the drop-down list **First Measure**, choose **Payroll (previous year)** ;
476 ** Then, on the drop-down list  **Second Measure**, choose **Annual salary** ;
477 * Complete the creation of this measure by clicking on **Ok** ;
478 * The newly created calculated measure **Evolution rate of payroll **is displayed at the end of columns' list.
479
480 (% style="text-align:center" %)
481 [[image:en_Edit_DM_ajout_measure_evolution_masse_salariale_creation.gif||alt="Edit_DM_ajout_measure_evolution_masse_salariale_creation.gif"]]
482
483 {{info}}
484 **💡 Good to know : ** a calculated measure can be created directly from an already existing measure :
485
486 * place your cursor on the line of **Annual salary**
487 * click on **More...**
488 * on the context menu displayed, place the cursor on **Create a calculated measure from 'Annual salary'**​​​​​, then on **Transformers**
489 * click on **Year - 1**
490 * the window for the creation of the calculated measure appears, already configured
491 * in our case, we have already created a similar function, click then on **Cancel**
492
493 (% style="text-align:center" %)
494 [[image:en_Edit_DM_creation_mesure_depuis_mesure_existante.gif||alt="Edit_DM_creation_mesure_depuis_mesure_existante.gif"]]
495
496
497 {{/info}}
498
499 (% class="wikigeneratedid" id="HModificationdeslibellE9sd27affichage" %)
500 **Changes to display labels**
501
502 * Last step in the configuration of our data model, we will now see how to rename the column identifiers.
503 * Indeed, taken from the columns of the Excel file, these identifiers may not be very representative of your business area, or speak little, etc.
504 * It is therefore entirely possible to rename them to allow a clear display in the graphics.
505
506 * In the current example that we are following during this tutorial, we can observe that the measure of column #10 is named "Annual salary". That is not consistent with the other recently created measures that have been named with "Payroll" wording.
507 * We are going then to rename the name "Annual salary" of column #10 by "Payroll" :
508 ** Place the cursor on the line of the column #10 "Annual salary"
509 ** The line become grey and a link **More...** appears.
510 ** Click on **More...**
511 ** On the context menu that just appears, click on **Edit display name**
512 ** The field containing the displayed value is now editable. Enter **Payroll**.
513 ** Click anywhere outside the field to complete the entry.
514
515 (% style="text-align:center" %)
516 [[image:en_Edit_DM_changement_libelle_affichage_masse_salariale.gif||alt="Edit_DM_changement_libelle_affichage_masse_salariale.gif"]]
517
518 * We can follow the same process to rename **Department code (ISO) ** to **Department code**:
519
520 (% style="text-align:center" %)
521 [[image:en_Edit_DM_changement_libelle_affichage_code_departement.gif||alt="Edit_DM_changement_libelle_affichage_code_departement.gif"]]
522
523 (% class="wikigeneratedid" id="HValidation" %)
524 **Validation**
525
526 We have arrived at the end of these steps of loading the data then configuring the data model.
527
528 Yoy can now click on the blue button at the bottom of the columns' list : **Validate the configuration**
529
530 (% style="text-align:center" %)
531 [[image:en_Edit_DM_validation_configuration.gif||alt="Edit_DM_validation_configuration.gif"]]
532
533 = Personalized dashboard creation : first charts =
534
535 After loading the data and editing the model of this data, we will now see the construction of the graphs to finally build our first dashboard on** absenteeism in the company**.
536
537 We will first choose how to create the dashboard, before configuring the charts.
538
539 We will then be able to insert them into the dashboard using a proposed smart layout.
540
541 == Personalized dashboard creation ==
542
543 === Choice of personalized creation mode ===
544
545 In its Wizard, DigDash Enterprise offers you two ways to create a new dashboard page from the data model we have just loaded and configured:
546
547 * **automatically **: the graphics are automatically preselected and preconfigured for you;
548 * **in a personalized way **: you create your charts while being free to choose the different axes of analysis.
549
550 In the case of this tutorial, we are going to create this new dashboard page by following the personalized way :
551
552 * In the page currently displayed, click on **Dashboard personalized** ;
553 * Click then on **Next** ;
554 * The page **Build your own dashboard** is now displayed
555
556 (% style="text-align:center" %)
557 [[image:en_Premiers_graphiques_choix_personnalise.gif||alt="Premiers_graphiques_choix_personnalise.gif"]]
558
559 === Charts construction ===
560
561 === Presentation ===
562
563 * In this part, the Wizard is divided into two vertical parts : 
564 ** **on the left, you will find the chart configuration part** : this is where you can configure the wanted chart, before adding them to the list of charts to be inseted in the dashboard page being currently created ;
565 ** **on the right, you find the list of charts to insert in the dashboard page being created.**
566
567 (% class="wikigeneratedid" id="HFonctionnementgE9nE9ral" %)
568 **General process**
569
570 The charts construction follows the following process :
571
572 1. Choice of a chart among the custom charts or the charts offered by DigDash Enterprise; ;
573 1. Configuration of dimensions and measures ;
574 1. Addition to the list of charts of the dashboard page being created.
575
576 This operation is to be repeated as many times as you wish to add a chart to the dashboard.
577
578 {{info}}
579 **💡 Good to know : **in this part of the wizard, the graphics are divided into two categories:
580
581 * **custom graphics **: you have the hand to choose the type of graphic representation and up to 3 dimensions and 3 measures ;
582 * **suggested graphics **: these are the graphics proposed by the intelligence of DigDash Enterprise because they can respond to an interesting use case.
583 {{/info}}
584
585 (% class="wikigeneratedid" id="HCrE9ationdesgraphiques" %)
586 **Charts creation**
587
588 First, we are going to create four graphs related to absenteeism in the company.
589
590 (% class="wikigeneratedid" id="HEvolutiondutauxd27absentE9isme" %)
591 //**Evolution of absenteeism rate**//
592
593 In this first graph, we will build a **line chart** showing the **evolution of the absenteeism rate over time**. This graph is already almost ready, because the intelligence of DigDash Enterprise has detected that it could respond to an interesting use case. This is why it is proposed in the **Suggested graphics**, which will allow us to configure it even more quickly!
594
595 To create this chart :
596
597 1. In the **Suggested graphics**, locate the **Trend Analysis**.
598 1. The dimension is automatically fixed on the Date. Choose **Absenteeism rate** from the drop-down list of measures.
599 1. Click on the button +.
600 1. The **Trend (Date) Absenteeism rate** graph is now integrated into the page being created. You will be able to see it, rename it, and even configure it in more detail in the next step !
601
602 (% style="text-align:center" %)
603 [[image:en_Premiers_graphiques_taux_absenteisme_par_date.gif||alt="Premiers_graphiques_taux_absenteisme_par_date.gif"]]
604
605 {{info}}
606 **💡 Good to know :** it is possible to delete one of the graphics already added in the list..
607
608 To do this, click on the cross associated with this graphic in the list.
609
610 (% style="text-align:center" %)
611 [[image:en_Premiers_graphiques_exemple_suppression.gif||alt="Premiers_graphiques_exemple_suppression.gif"]]
612
613
614 {{/info}}
615
616 (% class="wikigeneratedid" id="HNombredejoursd27absentE9ismeparservice" %)
617 //**Absenteeism days by service**//
618
619 In this second chart, we are going to build a **histogram **presenting the **number of days of absenteeism by service**. This time, the chart will be created from the **Custom graphics**.
620
621 To create this chart :
622
623 1. Locate the **Custom graphics** part in the left side;
624 1. By default, the chart type for Custom graphics is a horizontal bar chart. Click on the button representing this graphic representation to select a column representation.
625 1. By default, the number of dimension and measure is 1. This corresponds to the graph that we want to create. So, we do not have to modify these values.
626 1. Into the drop-down list of dimensions, choose **Service** ;
627 1. Into the drop-down list of measures, choose **Absenteeism days** ;
628 1. Click on the button +.
629 1. The chart **Absenteeism days by service** is now integrated into the page being created. You will be able to see it, rename it, and even configure it in more detail in the next step !
630
631 (% style="text-align:center" %)
632 [[image:en_Premiers_graphiques_jours_absenteismes_par_service.gif||alt="Premiers_graphiques_jours_absenteismes_par_service.gif"]]
633
634 (% class="wikigeneratedid" id="HCausesd27absentE9isme" %)
635 //**Absenteeism causes**//
636
637 In this third graph, we will construct a **pie chart** presenting the **distribution of the causes of absenteeism**.
638
639 To create this chart :
640
641 1. Locate the **Custom graphics** part in the left side;
642 1. By default, the chart type for Custom graphics is a horizontal bar chart. Click on the button representing this graphic representation to **select a pie chart representation**.
643 1. By default, the number of dimension and measure is 1. This corresponds to the graph that we want to create. So, we do not have to modify these values.
644 1. Into the drop-down list of dimensions, choose **Absenteeism reasons**
645 1. Into the drop-down list of measures, choose **Absenteeism days**
646 1. Click on the button +.
647 1. The chart **Absenteeism days by Absenteeism reasons **is now integrated into the page being created. You will be able to see it, rename it, and even configure it in more detail in the next step !
648
649 (% style="text-align:center" %)
650 [[image:en_Premiers_graphiques_jours_absenteismes_par_raison.gif||alt="Premiers_graphiques_jours_absenteismes_par_raison.gif"]]
651
652 (% class="wikigeneratedid" id="HCartographie:nombredejoursd27absentE9ismepardE9partement" %)
653 //**Map: absenteeism rate by department**//
654
655 In this fourth graph, we will construct a **map** representing the **absenteeism rate by department**. This graph is already almost ready, because the intelligence of DigDash Enterprise has detected that it could respond to an interesting use case. This is why it is proposed in the **Suggested graphics**, which will allow us to configure it even more quickly!
656
657 To create this chart :
658
659 1. In the **Suggested graphics**, locate the **Geographic Analysis**.
660 1. The dimension is automatically fixed on the department code (as it is the only geographic dimension of the data model). Choose **Absenteeism rate** from the list of measures.
661 1. Click on the button +.
662 1. The chart A**bsenteeism rate by department code **is now integrated into the page being created. You will be able to see it, rename it, and even configure it in more detail in the next step !
663
664 (% style="text-align:center" %)
665 [[image:en_Premiers_graphiques_jours_absenteismes_par_geographie.gif||alt="Premiers_graphiques_jours_absenteismes_par_geographie.gif"]]
666
667 === Naming the dashboard ===
668
669 * Before continuing, don't forget to name the dashboard.
670 * At the top of the page, the **Dashboard Name** field allows you to enter what will be the name of the new page being created.
671 * Here, enter "**Absenteeism**".
672
673 (% style="text-align:center" %)
674 [[image:en_Premiers_graphiques_nommage_dashboard.gif||alt="Premiers_graphiques_nommage_dashboard.gif"]]
675
676 === Choice of layout ===
677
678 We have just created 4 charts, which will be the charts of the "Absenteeism" dashboard.
679
680 To arrange these graphics within a page, several layouts are offered by DigDash Enterprise. These layouts automatically arrange the graphics on the page, to save you time.
681
682 * At the bottom of the list of the charts to be inserted in the page being created, locate the **Selected layout : automatic**
683 * By clicking on the button, several layout choices are available in a scroll list displayed at the right of the window.
684 * At the top, the first choice is **Automatic** : DigDash Enterprise will take care of all the layout logic.
685 * At the bottom of this first choice, you can choose several orientation of automated layout according to your preferences : 
686 ** notice the different symbols in the pre-layout areas : they correspond to the content that will be automatically added there : 
687 *** graphic
688 *** dimensions for filtering
689 *** filtered items
690 * Choose the second choice : **Charts + Filters on the left**
691 * Close the drop-down list using the cross.
692 * Check the choice we just made: **Selected layout: Graphics + Filters on the left**
693
694 (% style="text-align:center" %)
695 [[image:en_Premiers_graphiques_choix_disposition.gif||alt="Premiers_graphiques_choix_disposition.gif"]]
696
697 After this last step, we will exit the Wizard to find ourselves in the Dashboard Editor. From this editor, we will refine the dashboard just created.
698
699 * Click on **Finish and build the dashboard**
700
701 (% style="text-align:center" %)
702 [[image:en_Premiers_graphiques_terminer.gif||alt="Premiers_graphiques_terminer.gif"]]
703
704 = Finalization of the dashboard : absenteeism =
705
706 After loading the data, then editing the data model, and finally configuring the graphs that we want to see in our first dashboard dedicated to absenteeism in the company, we finally reach our goal! Indeed, we have just returned to the Dashboard Editor, and the 4 configured graphs are already arranged in our "Absenteeism" page.
707
708 Also, this part of the tutorial will show us how to polish the page we just created. Thus, we will see in particular:
709
710 * how to add dimensions as filters;
711 * how to modify the graphics already built;
712 * how to rename and access graph properties.
713
714 Finally, this part will also be an opportunity to familiarize ourselves more with the editor.
715
716 == Back in the Dashboard Editor ==
717
718 In the previous part, we configured the first charts.
719
720 Having requested the construction of the dashboard, they are now arranged in your first dashboard page, which you now see in the editor.
721
722 Let's observe several things:
723
724 * the page created belongs to your personal role and bears the name chosen in the previous step;
725 * the section of filtered elements has been automatically added (top left): this space will list the filtered dimensions (and the members to which these filters relate)
726 * on the left, the section "**Information Flow (Existing Graphics)**" is open:
727 ** this section contains all the graphs we just created in the previous step;
728 ** notice that the open role (or portfolio) is your personal role; later, you will be able to open another portfolio in your organization;
729 ** in the event that you delete by mistake one of the graphics inserted in the page, you can rearrange it in the page from this space by simply dragging and dropping to the desired area on the page;
730 ** also notice that the 4 dashboard charts present are all grouped together in a category with the same name as the page created.
731 * at any time, you can consult the dashboard in its final state by clicking on the consult button located in the upper banner of the editor.
732 ** this switch to consultation also allows you to save the modifications made in the editor.
733
734 (% style="text-align:center" %)
735 [[image:en_Finalisation_retour_editeur.gif||alt="Finalisation_retour_editeur.gif"]]
736
737 After these observations, let's move on to finalizing this first page dedicated to absenteeism.
738
739 == Finalization of the page ==
740
741 === Adding dimensions as filters ===
742
743 Any dashboard must be able to offer its users to filter on its dimensions, and this is what we are going to put in place from now on. We will now add the dimensions "Date", "Department" and "Gender" as a filter.
744
745 To do this :
746
747 * Notice on the left column of the page being edited, the three rectangles inviting you to "**Drag and drop Dimension**"
748 * It is on these three areas that we will insert our three dimensions.
749 * Click on the "Dimension" link of the first rectangle
750 * Note that in the left banner, the "**Filters / Variables**" part opens
751 * Drag and drop successively in the three identified areas:
752 ** the **Date **dimension
753 ** the **Service **dimension
754 ** and the **Gender **dimension
755
756 (% style="text-align:center" %)
757 [[image:en_Finalisation_insertion_dimensions.gif||alt="Finalisation_insertion_dimensions.gif"]]
758
759 {{info}}
760 💡 **Good to know :** did you notice that an asterisk appeared in the name of the page? It just means that changes in progress are not yet saved.
761 {{/info}}
762
763 * Notice that the **Date dimension presents its members in day / month / year format**.
764 * To switch to year format:
765 ** hover over this **Date **dimension with the mouse
766 ** click on the **toothed wheel** that appears
767 ** select **Properties **from the context menu, then **Settings**
768 ** in the **Hierarchy **drop-down list, select **Date**
769 ** then, in the **Level **drop-down list, select **Year**
770 ** finally, choose, below, in the **Type of visualization drop-down list: Horizontal list**
771
772 (% style="text-align:center" %)
773 [[image:en_Finalisation_modification_format_affichage_dimension_date.gif||alt="Finalisation_modification_format_affichage_dimension_date.gif"]]
774
775 {{info}}
776 As this part of the tutorial progresses, do not hesitate to switch from editor mode to consultation mode, to view the modifications generated on the final result by our changes!
777
778 **How to go directly back to the editor from the consultation mode?**
779
780 * click on your username
781 * in the contextual menu that opens, click on **Editor**
782
783 (% style="text-align:center" %)
784 [[image:en_Finalisation_back_to_editor.gif||alt="Finalisation_back_to_editor.gif"]]
785
786
787 {{/info}}
788
789 === Renaming the charts ===
790
791 As you may have noticed, automatically constructed graphs feature automatically generated names, which can be complex to understand.
792
793 Also, in this part, we will rename the graphics so that they have a more meaningful name.
794
795 To do this,
796
797 * hover over the graph **Trend (Date) Absenteeism rate**
798 * click on the **toothed wheel** displayed at the top right
799 * click on **Rename **in the context menu
800 * enter the new name: **Evolution of absenteeism rate**.
801 * click OK to validate the renaming
802
803 Do the same to rename:
804
805 * //Absenteeism days by Service// in **Number of days of absenteeism per service**
806 * //Absenteeism days by Absenteeism reason// in **Causes of absenteeism**
807 * //Absenteeism rate by Department code// in **Absenteeism rate by department**
808
809 (% style="text-align:center" %)
810 [[image:en_Finalisation_renommage_chart.gif||alt="Finalisation_renommage_chart.gif"]]
811
812 === Modification of already constructed graphics ===
813
814 Now that your page is starting to take shape, that it contains filters and that its graphics have meaningful names, it is important that the graphics do not bear inconsistencies, and follow rules that may be unique to your business. or operation of your service.
815
816 This is why we have the possibility to modify in depth the graphics already built, always from the editor.
817
818 So, we will see here how:
819
820 * change the level of the Date dimension of the Absenteeism rate by date graph to display the dates at the quarter level;
821 * change the colors of the columns of the histogram Number of days of absenteeism per service so that each service has a different color;
822 * change the colors of the absenteeism rate map by department.
823
824 (% class="wikigeneratedid" id="HFonctionnementgE9nE9ral-1" %)
825 **General process**
826
827 First, let's discuss the general operation of modifying graphics already created in the editor:
828
829 * When the mouse hovers over a graph, a pencil icon appears at the top right of the graph area: [[image:edit.svg||queryString="width=22&height=22" height="22" width="22"]]
830 * Click on it to open the chart modification area
831 * On this modification space:
832 ** the central space presents the preview of the modifications made;
833 ** the left column presents multiple elements and options, including in particular the dimensions and measures that can be added or substituted for each graph;
834 ** hovering over this left column, a configuration area appears over the central preview area:
835 *** it is here that we can add measures and dimensions by dragging and dropping from the left column;
836 *** it is here again that we can modify the configuration of the dimensions and measures already in place;
837 * Once the modifications are completed, it is possible to save the changes by clicking on the appropriate icon at the top right: [[image:save-round.svg||queryString="width=22&height=22" height="22" width="22"]].
838
839 (% style="text-align:center" %)
840 [[image:en_Finalisation_principe_edition.gif||alt="Finalisation_principe_edition.gif"]]
841
842 (% class="wikigeneratedid" id="HTauxd27absentE9ismepardate:afficherlesdatesauformattrimestre" %)
843 //**Absenteeism rate by date: display dates in quarter format**//
844
845 In this first graph, we are going to enter edit mode to display the dates of the line graph in quarter format.
846
847 To do this :
848
849 * On the editor page, hover over the area of the **Absenteeism rate by date** graph
850 * Click on the pencil icon that appears
851 * The edit space for this graphic appears
852 * In the left column, in the **Dimensions **section, click **Date ...**
853 * Locate the hierarchy / level couple **Month Year / Quarter**
854 * Drag and drop this hierarchy / level couple to the configuration area X
855 * Save the modification using the appropriate icon at the top right
856 The dates in the chart are now displayed in quarter format!
857
858 (% style="text-align:center" %)
859 [[image:en_Finalisation_edition_graphique_ligne_format_date.gif||alt="Finalisation_edition_graphique_ligne_format_date.gif"]]
860
861 {{info}}
862 **💡 Good to know :** if a dimension sees its name juxtaposed with "...", it means that it offers one or more hierarchies and allows you to choose the level to display in your chart.
863 {{/info}}
864
865 (% class="wikigeneratedid" id="HNombredejoursd27absentE9ismesparservice:colorerl27histogrammeparserviceettrierselonlamesure" %)
866 //**Number of days of absenteeism by service : color the histogram by service and sort according to the measure**//
867
868 In this second graph, we will enter the edit mode of the graph to color the columns according to the service. We will also take the opportunity to find out how to filter on the measure.
869
870 To do this :
871
872 * On the editor page, hover over the graph area **Number of days of absenteeism by service**
873 * Click on the pencil icon that appears
874 * The edit space for this graphic appears
875 * In the configuration area, right-click on **Column**
876 * In the context menu that appears, click on **Activate the color cycle**
877 * Notice that each column, for each department, is a different color.
878
879 (% style="text-align:center" %)
880 [[image:en_Finalisation_edition_graphique_colonnes_cyclage_couleur.gif||alt="Finalisation_edition_graphique_colonnes_cyclage_couleur.gif"]]
881
882 * Again, right-click on **Column**
883 * In the contextual menu that appears, hover the mouse over** Add sort on measure(desc.)**
884 * Click on the **Absenteeism Days** measure in the submenu that appears
885 * The columns are now sorted from the most important to the least important number of days of absenteeism
886 * Save the modification using the appropriate icon at the top right
887
888 (% style="text-align:center" %)
889 [[image:en_Finalisation_edition_graphique_colonnes_tri_mesure_desc.gif||alt="Finalisation_edition_graphique_colonnes_tri_mesure_desc.gif"]]
890
891 (% class="wikigeneratedid" %)
892 //**Absenteism rate by department : change the colors used by the map**//
893
894 In this third graph, we will enter the edit mode of the graph to change the colors used in the graph to color the departments. In fact, in the current state, the colors assigned by default do not make it possible to differentiate the rate shades at first glance.
895
896 * On the editor's page, hover over the area of the Absenteeism rate by department graph;
897 * Click on the pencil icon that appears;
898 * The edit space for this graphic appears;
899 * In the left area, click on **Style ...**, then on **Colors ...**;
900 * By default, the "Flat Design" color palette is selected;
901 * Click the drop-down list to choose **Flat Design 04**;
902 * Save the modification using the appropriate icon at the top right;
903
904 (% style="text-align:center" %)
905 [[image:en_Finalisation_edition_graphique_map_choix_palette_couleur.gif||alt="Finalisation_edition_graphique_map_choix_palette_couleur.gif"]]
906
907 = Creation of the second page: payroll =
908
909 After having created a first page of our dashboard relating to absenteeism, we are now going to create a second page dedicated to the payroll.
910
911 We will see as follows:
912
913 * how to add a new page;
914 * how to create new graphs from the data source added and modeled in the previous parts;
915 * and how to insert and configure these new graphics in the new page;
916
917 == Adding a new page and choosing a layout ==
918
919 As we have observed previously, the **Absenteeism **page belongs to your personal role, with your username. We will add a second page, still in this personal role. During creation, we will choose layout for our new page.
920
921 * Click on the symbol [[image:14-plus.png||queryString="width=22&height=22" height="22" width="22"]] to the right of the **Absenteeism **page;
922 * The **Add page **window appears;
923 * Enter the name of the page: **Payroll**;
924 * We are now going to choose a design mode for the page: in the **Display mode** drop-down list, click **Templates ...**;
925 * The **Templates **window appears;
926 * For more consistency with the previous page, we will choose the same layout: click on **Graphics + filters on the left**;
927 * Validate this choice by clicking on **OK**;
928 * Then validate the creation of the new page by clicking on **OK **again;
929 * Our new **Payroll **page is then displayed.
930
931 (% style="text-align:center" %)
932 [[image:en_Seconde_page_creation_nouvelle_page.gif||alt="Seconde_page_creation_nouvelle_page.gif"]]
933
934 == Creation of new graphics ==
935
936 Our new **Payroll **page has now been created! We will now configure new graphics.
937
938 === Creation of new graphics from the Editor : general process ===
939
940 * Note that on the left of our pages, the **Information Flow (Existing Graphics) **section is open and presents the information flows that already exist;
941 * Let's open the panel below **Creating new graphics** by clicking on it;
942 * We find the similar graph configuration tool that we took in hand earlier in the wizard;
943 * Note that the "**HR Datas**" data model is automatically selected;
944 * It is from this data model that we will create our new graphs about **payroll**.
945
946 (% style="text-align:center" %)
947 [[image:en_Seconde_page_creation_ouverture_panel_creation_graphique.gif||alt="Seconde_page_creation_ouverture_panel_creation_graphique.gif"]]
948
949 === Evolution of the payroll by service over the last year ===
950
951 This first graph, in the form of a table, will represent the evolution of the payroll by service. We will then apply a filter to show the changes in each service only over the last year.
952
953 (% class="wikigeneratedid" id="HConfiguration" %)
954 **Configuration**
955
956 * In the **Creating new graphics** section, locate the **Custom graphics **subsection;
957 * Click on the icon representing a table;
958 * In this table, we will represent, for each service, the payroll for the previous year, the payroll for the current year and the rate of change between these two years.
959 * We will therefore need **one dimension** and **three measures** to configure this table.
960 * Enter **3** in the **number of measures;**
961 * Then select the dimension from the drop-down list: **Service**;
962 * Then select the three measures:
963 ** **Payroll for the previous year**;
964 ** **Payroll**;
965 ** **Evolution rate of payroll**;
966 * Finally click on the + symbol to add the graphic to the page.
967
968 (% style="text-align:center" %)
969 [[image:en_Seconde_page_graphique_tableau_masse_salariale.gif||alt="Seconde_page_graphique_tableau_masse_salariale.gif"]]
970
971 (% class="wikigeneratedid" id="HRenommage" %)
972 **Renaming**
973
974 * Let us rename the graph by **Evolution of the payroll by service**:
975 ** position your mouse cursor on the graph;
976 ** at the top right of the graph, a toothed wheel appears: click on it;
977 ** in the context menu that appears, click on **Rename**;
978 ** enter the new name of the graph: **Evolution of the payroll by service**;
979 ** validate by clicking on **OK**;
980
981 (% style="text-align:center" %)
982 [[image:en_Seconde_page_graphique_tableau_masse_salariale_renommage.gif||alt="Seconde_page_graphique_tableau_masse_salariale_renommage.gif"]]
983
984 (% class="wikigeneratedid" id="HFiltrage" %)
985 **Filters**
986
987 * We will then filter this chart to take into account the last year of our dataset.
988 * The filter we are going to create here will be exclusive to this chart and will not be propagated to other charts.
989 ** position your mouse cursor on the graph;
990 ** at the top right of the graph, a toothed wheel appears: click;
991 ** in the context menu that appears, click **Properties**;
992 ** in the window that appears, click the **Filters **tab (under the **Parameters **tab);
993 ** in this tab, the filterable dimensions are displayed: there is currently no filter configured;
994 ** click on the **All **filter corresponding to the **Date **dimension;
995 ** a window allowing you to configure the filter for this dimension is displayed;
996 ** in the **Filter type** drop-down list, select **Predefined**;
997 ** in the second **Context **drop-down list, select **Max data date**;
998 ** in the last **Member **drop-down list, select **Year**;
999 ** validate by clicking on **OK**;
1000 ** validate again by clicking on **OK**;
1001
1002 (% style="text-align:center" %)
1003 [[image:en_Seconde_page_graphique_tableau_masse_salariale_filtrage_last_year.gif||alt="Seconde_page_graphique_tableau_masse_salariale_filtrage_last_year.gif"]]
1004
1005 === Payroll evolution ===
1006
1007 We are now going to create a second graph, in curve, which will represent the evolution of the wage bill over the years.
1008
1009 (% class="wikigeneratedid" id="HConfiguration-1" %)
1010 **Configuration**
1011
1012 * Into the **Creating new graphics** section, locate **Trend Analysis** (in **Suggested graphics** part);
1013 * Choose the measure on the drop-down list : **Payroll** ;
1014 * Finally, click on the plus symbol image:icon:add to add the graphic to the page.
1015
1016 (% style="text-align:center" %)
1017 [[image:en_Seconde_page_graphique_courbe_masse_salariale.gif||alt="Seconde_page_graphique_courbe_masse_salariale.gif"]]
1018
1019 (% class="wikigeneratedid" id="HRenommage-1" %)
1020 **Renaming**
1021
1022 * As in the previous step, let's rename this graph by **Payroll evolution **: 
1023 ** position your mouse cursor on the graph;
1024 ** at the top right of the graph, a toothed wheel appears: click on it;
1025 ** in the context menu that appears, click on **Rename**;
1026 ** enter the new name of the graph: **Payroll evolution**;
1027 ** validate by clicking on **OK**;
1028
1029 === Payroll by service ===
1030
1031 We are now going to create a third chart : it will be a pie chart representing the repartition of payroll by service.
1032
1033 (% class="wikigeneratedid" id="HConfiguration-2" %)
1034 **Configuration**
1035
1036 * Into the **Creating new graphics** section, locate the **Custom graphics** part ;
1037 * Click on the icon of the pie chart representation
1038 * Choose then the dimension in the dropdown list : **Service** ;
1039 * Then choose the measure : **Payroll **;
1040 * Finally, click on the plus symbol image:icon:add to add the graphic to the page.
1041
1042 (% style="text-align:center" %)
1043 [[image:en_Seconde_page_graphique_secteur_masse_salariale_par_service.gif||alt="Seconde_page_graphique_secteur_masse_salariale_par_service.gif"]]
1044
1045 (% class="wikigeneratedid" id="HRenommage-2" %)
1046 **Renaming**
1047
1048 * As in the previous steps, let's rename this graph by **Payroll by service **: 
1049 ** position your mouse cursor on the graph;
1050 ** at the top right of the graph, a toothed wheel appears: click on it;
1051 ** in the context menu that appears, click on **Rename**;
1052 ** enter the new name of the graph: **Payroll by service**;
1053 ** validate by clicking on **OK**;
1054
1055 === Payroll by service and gender ===
1056
1057 Finally, we will create a fourth chart : it will be a histogram presenting the repartition of payroll infunction of service and gender.
1058
1059 (% class="wikigeneratedid" id="HConfiguration-3" %)
1060 **Configuration**
1061
1062 * Into the **Creating new graphics** section, locate the **Custom graphics** part ;
1063 * Click on the icon presenting the histogram representation ;
1064 * In this diagram, we are going to represent, for each service, then for each gender, the payroll.
1065 * So we will need two dimensions and a measure to configure this diagram.
1066 * Enter 2 in the number of dimensions;
1067 * Then select the two dimensions in the drop-down lists: **Gender **then **Service**;
1068 * Then choose the measure : **Payroll **;
1069 * Finally, click on the plus symbol image:icon:add to add the graphic to the page.
1070
1071 (% style="text-align:center" %)
1072 [[image:en_Seconde_page_graphique_secteur_masse_salariale_par_service_et_genre.gif||alt="Seconde_page_graphique_secteur_masse_salariale_par_service_et_genre.gif"]]
1073
1074 (% class="wikigeneratedid" id="HApplicationd27unepalettedecouleuradE9quate" %)
1075 **Applying an appropriate color palette**
1076
1077 The histogram that we have just created presents a uniformity of color which does not make it possible to distinguish at first glance the two genders represented.
1078
1079 To correct this:
1080
1081 * with your mouse, position the cursor on the graph;
1082 * at the top right, a pencil appears: click on it;
1083 * the graph editing window appears;
1084 * in the configuration area, right-click on **Column**;
1085 * in the context menu that appears, click on **Enable the color cycle**;
1086 * in the left area, click on **Style ...** then on** Colors ...**;
1087 * a window allowing you to choose a color palette appears;
1088 * select from the **Color Gender** drop-down list;
1089 * automatically, the correct colors are applied;
1090 * save by clicking on the "floppy disk" logo at the top right.
1091
1092 (% style="text-align:center" %)
1093 [[image:en_Seconde_page_graphique_secteur_masse_salariale_par_service_et_genre_couleur_HF.gif||alt="Seconde_page_graphique_secteur_masse_salariale_par_service_et_genre_couleur_HF.gif"]]
1094
1095 (% class="wikigeneratedid" id="HRenommage-3" %)
1096 **Renaming**
1097
1098 * As in the previous step, let's rename this graph by **Payroll by service and gender **: 
1099 ** position your mouse cursor on the graph;
1100 ** at the top right of the graph, a toothed wheel appears: click on it;
1101 ** in the context menu that appears, click on **Rename**;
1102 ** enter the new name of the graph: **Payroll by service and gender**;
1103 ** validate by clicking on **OK**;
1104
1105 == Adding dimensions as filters ==
1106
1107 Our page is almost ready. We still have, as we did before for the previous page, to add the dimensions in order to allow us to filter in consultation mode.
1108
1109 To do this :
1110
1111 * Notice on the left column of the page being edited, the three rectangles inviting you to "**Drag and drop Dimension**"
1112 * It is on these three areas that we will insert our three dimensions.
1113 * Click on the "Dimension" link of the first rectangle
1114 * Note that in the left banner, the "**Filters / Variables**" part opens
1115 * Drag and drop successively in the three identified areas:
1116 ** the **Date **dimension
1117 ** the **Service **dimension
1118 ** and the **Gender **dimension
1119
1120 (% style="text-align:center" %)
1121 [[image:en_Seconde_page_ajout_dimension_filtrage.gif||alt="Seconde_page_ajout_dimension_filtrage.gif"]]
1122
1123 * Notice that the **Date dimension presents its members in day / month / year format**.
1124 * To switch to year format:
1125 ** hover over this **Date **dimension with the mouse
1126 ** click on the **toothed wheel** that appears
1127 ** select **Properties **from the context menu, then **Settings**
1128 ** in the **Hierarchy **drop-down list, select **Date**
1129 ** then, in the **Level **drop-down list, select **Year**
1130 ** finally, choose, below, in the **Type of visualization drop-down list: Horizontal list**
1131
1132 (% style="text-align:center" %)
1133 [[image:en_Seconde_page_modif_format_dimension_date.gif||alt="Seconde_page_modif_format_dimension_date.gif"]]
1134
1135 = Conclusion =
1136
1137 == Congratulations ! ==
1138
1139 From our Excel file, we were able to build a real dashboard thanks to the Dashboard Creation Wizard of DigDash Enterprise.
1140
1141 We saw :
1142
1143 * how to load a file;
1144 * how to edit the data configuration and thus model a data model;
1145 * how to configure charts from this data model;
1146 * how to configure dashboard pages to add filters;
1147 * how to modify the visualization generated by default, entering in more detail in the parameters;
1148
1149 == To go further... ==
1150
1151 It is possible to go even further!
1152
1153 With the Studio, DigDash Enterprise allows you to go into more detail in the configuration of your data models, to connect to your databases or to be able to join or join several data sources.
1154
1155 Do not hesitate to get in touch with your DigDash Enterprise administrator or your DigDash referent contact to discuss this matter!