Solved

Age of employees

  • 12 July 2021
  • 4 replies
  • 115 views

Hello, how do I get the age of the collaborators? I already have the date of birth.

icon

Best answer by Martin Burian 17 July 2021, 12:48

View original

4 replies

Userlevel 3

You can use Date Arithmetic based on the date dimensions you have uploaded to your project. This is the best way to calculate time duration in a report. If you are having issues with the report itself, it may be best to open a ticket directly with our support team so we can look into the LDM and dates used.

Userlevel 2

Hi @Rafael Cruz. Please see example.

Data:
 

Model:
 

Metric (days):

For result in days

Metric (months):
 

For result in months

Metric (years):

For results in years

Report (days):
 

Report (months):

Report (months with formatting):
 

Format:

{{{12||[>1]# years ;[=1]# year ;#}}}{{{|12|[>1]# months;[=1]# month;#}}}

 

Report (years):

 

Tks!!

Userlevel 2

Tks!!

Welcome :-)

Reply