Eazybi Calculation

[Manoj]

Hi All,

I am trying to created a calculated table in eazybi however my query does not work in a right manner,

based on 2 conditions i have to make a count. 

For example, I have status named "Sick Leave" and employee type [as in custom field] "Contractor"

Suppose if some is on sick leave and he is a contractor if this criteria meets then gives me total count of sick leave.

Please suggest.

Thanks!

M

[Fabian Lim]

Hi @M

This is what I would recommend:

• You would need to add the dimension for status and employee il the pages and filter them to sick leave and contractor.
• Then add the issues dimensions to rows
• In measures, select the issues created measure

Thanks