Monthly Attrition rate/Average

Manoj_4r4x3x

Hi All,

I have to find out the Attrition rate on monthly basis of different departments for the period of FY1920.

Departments are marketing, HR and IT.

How to plot the formula in eazybi to use as in dashboard. please guide me on this. as i new to this.

 

Daina Tupule eazyBI

eazyBI has a default measure Issues resolved to represent issues resolved (assumption - employees left) in the period. You can use another default measure Open issues to see how many issues are open at the period end. Open issues of a previous period will represent open issues at the start of the period.

 

1. With those assumptions, you can define a new user define calculation in Measures with the name Attrition rate using this formula:

[Measures].[Issues resolved]/

(([Measures].[Open issues]

+

([Measures].[Open issues],

[Time].CurrentHierarchyMember.PrevMember)) / 2)

Then you can use this new measure in the report on Columns.

 

2. Then you can use dimension Time and move it to Rows. Click on a header of Time column in report and select All hierarchy level members>Month (to see data by Month)

 

3. If you would like to see an Average across all periods, you can click on a header of the column for a measure Attrition rate and select Add calculated>Statistical>Average this will plot a line representing an average of all periods.

 

4. If you would like to split data by Departments. I would suggest splitting only one measure to not overcrowd the report (it would be easier to read). You can click on the header of the measure Attrition rate and select Drill into and select the Custom field>Department.

(You would like to have a custom field department and select it for import in eazyBI as a dimension before you can apply this step)

 

5. Then you can select a chart type, for example, Bar, and switch to a vertical chart there.

 

6. If necessary, add any other customizations there.

 

Daina / support@eazybi.com