Creating an age pyramid

The aim of this tutorial is to create an age pyramid. A population pyramid is used to represent the gender and age distribution of a population at a given time.

17

18

The Registre_RH.xls dataset used in the tutorial corresponds to fictitious data from a company containing information about employees such as their ID, name, age, etc. This data is contained in the Excel file "**[[Registre_RH>>attach:Registre_RH.xlsx]]**".

19

20

This entire tutorial takes place in the Studio.

21

To create the age pyramid, we will first prepare the data and then configure a Bar chart.

= Prerequisites =

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

26

27

* have installed DigDash Enterprise version 2024R1 or later;

28

* be a member of the**"Data Model Designer**" authorisation group;

29

* download the Excel file "**[[Registre_RH>>attach:Registre_RH.xlsx]]**".

(% class="box" %)

(((

ℹ The screenshots in this tutorial were produced using the Chrome browser. There may be slight differences depending on the browser.

34

)))

35

36

= Step 1: Create and configure the data model =

37

38

(% class="box infomessage" %)

39

(((

40

This tutorial assumes that you will import your data sources and create your graphs in your personal role.

41

)))

42

43

== Import the "Registre_RH" data ==

44

45

Here we're going to import data from the Excel file "Registre_RH" (retrieved earlier), which represents the human resources data for a fictitious company.

To do this

1. Launch the **Studio**.

50

1. Open the **Templates** tab.

51

1. Click on the **New Template** button.

52

1. In the **Create a new data model** box, select **All types** in the **Files** section.

53

[[image:Nouveau_modele2.png||alt="Nouveau modèle"]]

54

➡ The **Search for Remote Files **box appears.\\

55

1. In the **Server** drop-down list, select "**Common Datasources**".

56

1. Click on the **Add a file to the server**... button.

57

[[image:1716976126263-315.png||alt="Ajout fichier" height="417" width="659"]]

58

1. The **Select local file or URL **box appears, keep the default selection** From your computer**.

59

1. Click **Browse **to select the **"Registre_RH **" file retrieved earlier.

60

1. Click **OK**.

61

➡ The file is now saved on the DigDash**"Common Datasources"** server and accessible to all users.

62

63

(% class="box infomessage" %)

64

(((

65

ℹ If the //**UserDocs **//document server is selected the documents are only accessible to the user who uploaded them.

)))

(% start="10" %)

1. In the **Search for remote files** box, select **"Registre_RH"**.

70

1. Click **OK.**

71

72

The **Excel File **box is displayed. It offers data selection options and a preview of the data.

73

74

[[image:Prévisualisation_age.png||alt="Prévisualisation"]]

75

76

The items in the first row of the table correspond to the data types in each column. We will therefore use them as column headings. For example, Employee ID for column 1. To do this

77

78

* In the **Data selection** section, tick the **First row as header** box.

79

[[image:Entête.png||alt="1ere ligne"]]

80

81

== Transform date of birth into age (optional) ==

82

83

If you only have the date of birth, you can perform a data transformation to obtain the age.

84

85

(% class="box warningmessage" %)

86

(((

87

In this case, you will not be able to perform another data transformation to group by age bracket.

)))

To do this

1. Click on the **Birth** column header.

93

1. In the pop-up menu which appears, select **Data transformation**...

94

[[image:Menu_colonne2.png]]

95

1. In the **Type **field of the dialog box which appears, select **Shared function**.

96

1. In the list of** Shared functions**, select** Age**.

97

[[image:Fonction_partagée.png||alt="Fonction partagée" height="417" width="781"]]

98

1. Click **OK**.

99

➡ The date of birth is replaced by the calculated age.

100

1. Click on the header and then select **Rename **to change the name of the column.

101

102

== Group ages by group ==

103

104

Here we choose to group ages by groups of 5.

105

To do this:

106

107

1. Click on the **Age** column header.

108

1. In the pop-up menu which appears, select **Data transformation**...

109

1. Perform a [[data transformation >>doc:dev:Digdash.user_guide.studio.Create_datamodel.transform_data.Column_transform.WebHome||anchor="Transformation_colonnes"]]on the** Age** column.

110

[[image:Transformer_colonne_age.png||alt="Transformation colonne age"]]

111

1. In the " **Age" column Transformation **box that appears, select the **Script **type and enter the following script:

var v = value;

while(v%5 != 0) {

v++;

}

return v +'';

(% start="4" %)

1. Click **OK**.

➡ The **Age** column is transformed.

124

[[image:Ages_groupés.png||alt="Ages groupés"]]

125

126

We can now move on to configuring the data model: click on the **Next **button at the bottom right to open the data model configuration window.

127

128

== Configure data model ==

129

130

The data model configuration window opens on the **Columns** tab. We are going to make the necessary settings in the data model.

131

132

=== Change the type of the Age column ===

133

134

The **Age** column has been detected as a measurement. However, it will be used here as a dimension. To change this:

135

136

1. Select the** Age** column.

137

1. In the **Type** field at the top right, select **Dimension**.

138

[[image:Type_colonne_age3.png||height="460" width="998"]]

139

1. Also change the type of the following columns:

140

1*. **Postcode**: select **Dimension (geographical)**

141

1*. **Entry date **: select **Dimension (time)**

142

143

=== Create the measures Number of women and Number of men ===

144

145

We need to know the number of women and men for each age. To do this, we are going to create 2 calculated measures based on the unique identifier determining the person. The calculated measure displayed on the left of the axis must be negative. In this example, we choose to place men on the left and women on the right of the age pyramid.

146

147

1. Click on the **New Measure **button at the top left of the list of columns.

148

1. In the window** [[Calculated measure>>doc:dev:Digdash.user_guide.studio.Create_datamodel.configure_data_model.Configure_columns.Create_new_measure.Create_calculated_measure.WebHome]]**[[ >>doc:dev:Digdash.user_guide.studio.Create_datamodel.configure_data_model.Configure_columns.Create_new_measure.Create_calculated_measure.WebHome]]window that appears, enter the name of the new measure: **Number of men**.

149

1. Then enter the following formula (double-click on the** Employee ID** dimension to insert it in the formula):

150

151

152

return -<ID Employé(dcount)>;

153

154

155

[[image:Mesure_calculée_hommes.png||height="488" width="837"]]

156

157

(% start="4" %)

158

1. Edit the dimension to add a filter (right-click and **Edit**).

159

➡ The **associated Dimension "//Dimension name //**" box **//is //**displayed.

160

1. In the **Add a dimension** drop-down list, select the **Gender** dimension.

161

1. In the **Filter** column, click **Off** and then **New**.

162

➡ The **Edit filter for the Gender dimension**box **//is //**displayed.

163

1. Keep the **Elements** type and tick **H** for men.

164

[[image:Contexte_dimension.png||alt="Edition filtre" height="279" width="811"]]

165

1. Click on **OK**.

166

1. Repeat the operation for the number of women without the negative sign and selecting **F in **the filter step.

167

➡ The 2 new measures **Number of men **and **Number of women **are added to the list of columns.

168

1. Click **Finish **and enter a name for the model:** Pyramid ages **to save.

169

170

= Step 2: Configuring the Age Pyramid chart =

171

172

== Create the Bars graph ==

173

174

1. From the **{{glossaryReference glossaryId="Glossary" entryId="Flux"}}Flow{{/glossaryReference}} **tab in the **Studio,** click on the** {{glossaryReference glossaryId="Glossary" entryId="Flux"}}Flow{{/glossaryReference}}** button.

175

1. Select the **Bars** flow.

176

➡ The **{{glossaryReference glossaryId="Glossary" entryId="Flux"}}Flow{{/glossaryReference}} Properties** window appears.

177

1. Select the data model created earlier: **Pyramid ages**.

178

1. Drag and drop the **Age **dimension onto the **Bar **axis (y-axis).

179

1. Drag and drop the 2 measures**(Number of men **negative and **Number of women **positive) onto the **Stacking **axis (x-axis).

180

1. From the toolbar, click on **Colours **and then the** Edit **button to change the [[colour palette>>doc:dev:Digdash.user_guide.studio.Create_flow.Configure_flow.Flow_toolbar.Colors.WebHome]].

181

1. Select the **Color gender** palette.

182

[[image:Configuration_flux_age2.png]]

183

184

== Change the age sorting ==

185

186

To display the ages in the desired order :

187

188