topic Re: Comparing Hire Date Year/Month against Termination Date Year/Month - Bar Chart in App Development

Comparing Hire Date Year/Month against Termination Date Year/Month - Bar Chart

craigbence — Mon, 20 Dec 2021 21:38:40 GMT

We need to chart a count of how many employees were hired in any given year/Month side-by-side with a count of how many employees were terminated the same year/month. We have a [Hire-Year-Month] field and a [Termination-Year-Month] field.

Having a brain freeze on how to create a Bar Chart to present this information. Any help would be greatly appreciated.

Re: Comparing Hire Date Year/Month against Termination Date Year/Month - Bar Chart

Kushal_Chawda — Sat, 18 Jan 2020 21:27:35 GMT

Is there any Flag to identify that employee is terminated ?

Re: Comparing Hire Date Year/Month against Termination Date Year/Month - Bar Chart

craigbence — Sat, 18 Jan 2020 23:06:24 GMT

Just the Termination Date <> ' '

Re: Comparing Hire Date Year/Month against Termination Date Year/Month - Bar Chart

Kushal_Chawda — Sun, 19 Jan 2020 19:35:26 GMT

Create bar chart

Dimension:

[Hire-Year-Month]

Expressions:

1) Count(distinct EmpID) -> No of employee hired

2) Count(distinct {< [Terminate-Month-Year]=p({1}[Hire-Year-Month])}>}EmpID) -> No of employees Terminated

Re: Comparing Hire Date Year/Month against Termination Date Year/Month - Bar Chart

craigbence — Mon, 20 Jan 2020 21:26:00 GMT

We really appreciate your help on this. Our code we created is displayed below. The first measure/expression appears to work fine. However, the second measure/expression is generating the following error:

Error in expression

Error in set modifier expression.

First measure (syntax ok):

Count(distinct EmployeeKey)

Second Measure :

Count(distinct {< [Termination Date.ac.YearMonth]=p({1}[Hire Date.ac.YearMonth])}>}Employeekey)

Thoughts??

Re: Comparing Hire Date Year/Month against Termination Date Year/Month - Bar Chart

craigbence — Tue, 21 Jan 2020 17:48:11 GMT

We are still unable to get this solution to work. Any additional help we can get from our last post on the syntax error would be greatly appreciated!!

Thanks.

Re: Comparing Hire Date Year/Month against Termination Date Year/Month - Bar Chart

Kushal_Chawda — Tue, 21 Jan 2020 19:27:33 GMT

Dimension:

[Hire-Year-Month]

Expressions:

1) Count(distinct EmployeeKey) -> No of employee hired

2) Count(distinct {< [Terminate-Month-Year]=p({1}[Hire-Year-Month])>}EmployeeKey) -> No of employees Terminated

Re: Comparing Hire Date Year/Month against Termination Date Year/Month - Bar Chart

craigbence — Mon, 27 Jan 2020 15:04:29 GMT

This did work!!! Thank you.

Count(distinct {< [Termination Date.ac.MonthYear]=p({1}[Hire Date.ac.YearMonth])>}EmployeeKey)