Setting a year independently of list boxes

[#1]

Good morning,

I have data as time series like

PersonnelNr: 4711

AreaOfWork: R&D

YYYY.MM: 2014.06

I would like to present two pie circles with the composition of the work force by AreaofWork for say 2014.12 and 2015.12 regardless of the user´s selection in list boxes. What is the right syntax for this in the Chart Properties --> Expressions tab?

Thanks in advance!

[gautik92 · Accepted solution]

sum({<YYYY.MM={'2014.12'}>}yourfield)

sum({<YYYY.MM={'2015.12'}>}yourfield)

[swuehl]

Not sure if I completely understood, but maybe try this:

Create a chart with dimension AreaOfWork

As Expression use something like

=Count({<[YYYY.MM] = {'2014.12'}>} PersonnelNr)

Where {<[YYYY.MM] = {'2014.12'}>} is a set expression to use a fix filter on that field.

Use similar for your second chart.

[#4]

That works, thanks!