Could you help me with some advice. I have 3 separate table on HR subject:
1) Vacancy status (ID, current status)
2) Date close planned (ID, Date close planned, Date)
3) Date close actual (ID, Date close actual, Date)
Tables are connected by ID and ID+Date fields.
I need to visualize in combo chart number of vacancies need to be closed in each month e.g. vacancies with [Date close planned] equal to analyzed month or earlier and not have been closed yet)
I started with:
- creation of combo chart with dimension [Date]
- creation of measure Rangesum(above(count([Date close planned]),0,RowNo()))
- Now I need to extract all vacancies which were closed.
If use Rangesum(above(count({<[current status]={'closed'}>}[Date close planned]),0,RowNo())) I get vacancies closed on the current moment and not take into account [Date close actual].
Hi, have you tried below expression? Rangesum(above(count({<[current status]={'closed'}>}[Date close planned]),0,RowNo())) - Rangesum(above(count({<[current status]={'closed'}>}[Date close actual]),0,RowNo())) ZZ
