Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a pie chart that shows the staff count for staff starting with the organisation. This has a dimension is by 'Division'.
I only want to show the data within the chart for any staff starting after Jan 2013 and earlier than today (planned start date).
As I do not have the date dimension in my pie chart, how do I do this?
Thanks
Phil
In your expression, you can use set analysis that looks like the following:
count({<[Start Date]={'>=$(=MakeDate(2013,1,1))<=$(=today())'}>}[Staff Field])
You must use set Analysis in your expression, like this. I Suggest use variables.
Count($<Date={">=$(=Date(vDateStartP1,'DD-MM-YYYY'))<=$(=Date(vDateEndP1,'DD-MM-YYYY'))"} > Staff)
Thanks
Bruno