Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pretty simply data-set(attached). I want to count how many projects have start dates in a given month and compare them for each month across years. using the attached dat-set it would look like this:
I would also like to display the percentage change for each MoM inside the bars or at least as a tool-tip.
Thanks for any help!
-Craig
I would add a Year and a Month field in the script, this would be make easier to create the table you need.
You could use these formulas to see the number of projects by year. As dimension in the chart you can use month and then
Count({$<Year={$(=Year(today())}>}Project) for the current year
Count({$<Year={$(=Year(today())-1}>}Project) for the previous year
Count({$<Year={$(=Year(today())-2}>}Project) for two years ago
I hope this helps