Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have these fields in my database, PayRollYear and PayRollMonth and EMPNO.
I want to create a combo chart, that shows the count of employees in the present year vs the previous year. Present year would be a bar chart, and previous year would be a line chart, month being the dimension. Any ideas????
Hey,
I am sorry, but what am I suppose to open? There isn't any file attached, in you reply.
Shreya
You can'see this?
Nope!!!
Hi,
No need to create variable in your case.
Create a graph with dimension Month and two expressions:
First expression in bar chart:
count(distinct {<PayRollYear ={$(=Max(PayRollYear))}>}EMPNO)
Second expression in line chart:
count(distinct {<PayRollYear ={$(=(Max(PayRollYear)-1))}>}EMPNO)