Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
sum({<YYYY.MM={'2014.12'}>}yourfield)
sum({<YYYY.MM={'2015.12'}>}yourfield)
sum({<YYYY.MM={'2014.12'}>}yourfield)
sum({<YYYY.MM={'2015.12'}>}yourfield)
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.
That works, thanks!