How to use Set Analysis based on graph dimension?

[isorinrusu]

Hi everyone,

I have two calendars, one for services and one for employers. I have a linechart that shows the evolution of services (dimension being year month from the service's calendar), and I'd like to also show the number of employers for each existing year month in the x dimension.

So, I'm trying to use Set Analysis, but in vain. The expression I use is the following:

count({< AñoMes={'$(=only(ServAñoMes))'}, Mes=,Año=>} DISTINCT total DNI)

AñoMes being the employers' Year Month from its calendar, and ServAñoMes being from the services' calendar, used as a dimension in the graph.

Does this have any solution at all?

The second thing I've tried is to have a variable that takes its first parameter as the AñoMes value. But it's still not working because it won't take the only(ServAñoMes) as its parameter.

PS: Building only one calendar (or Master Calendar) is not feasible due to the data associations.

Thank you in advance.

[#2]

Can you upload a sample file for better understanding and quick resolution?

Regards,

KKR

[isorinrusu · Accepted solution]

Hi KKR,

The problem has been solved, thanks