Rangesum above

AndreyBel — Wed, 22 Dec 2021 20:40:09 GMT

Hello colleagues,

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].

Can you suggest how to solve my task?

Thanks in advance

Re: Rangesum above

zzyjordan — Wed, 09 Jan 2019 13:44:10 GMT

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

topic Rangesum above in App Development

Rangesum above

Re: Rangesum above