Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.....
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).
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.
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.
Hi,
result Is not correct except for 2017.
What are expected out put for other years (with logic please)?
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