Active Count of As Of Now for each year

[subbareddykm]

Hi All,

i want to active employee on YoY.

Actually I m getting only particular year count in bar chart.

What i want is For example,

Now we are in 2017 ,as of now total is 1552 in text box i m getting, that is fine.But if i take year dim and Take same expression its now giving me . Anyhow if i create Year wise expression that will work.after we require for drill down for year and Month, For that how can i achieve it ?

Please help me oin this.....

[#2]

Hi Subbareddy,

Could you be little more clear on what you want to see as output .

The text box value you see is irrespective of the year (in case if you haven't selected any year).

[subbareddykm]

No,

My result should be like

For 2017 -1552 i.e if you filter in text box with StartDate<=today this 1552 will get

For 2016 ,filter <=2016 max date

like for all years

i hope you you got it.

[tresB]

I am not sure if this is directly doable in the front-end or not. However, just playing in the script a bit you may get your desired output.

[subbareddykm]

Hi,

result Is not correct except for 2017.

[tresB]

What are expected out put for other years (with logic please)?

[subbareddykm]

I have crated for each year,

Using like below expression:(this is 2016)

=fabs(Count({<[Start Date]={"<=$(=Date(AddYears(YearStart(Today())-1,0),'YYYY-MM-DD'))"},Flag={'Total'}>}DISTINCT ID)

-Count({<[Start Date]={"<=$(=Date(AddYears(YearStart(Today())-1,0),'YYYY-MM-DD'))"},Flag={'Sep'}>}DISTINCT ID))

other years i just changed addyears number

[tresB · Accepted solution]

Please find attached a solution using The As-Of Table .