Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
Please could you assist me with the following:
I have loaded a staffs start date and made end date to be September 2016.
What i would like is for the literal number count to be applied based on the staffs start date month.
For example:
Staff A , started in December 2015 and end date is September 2016.
I would like to display the counter as an expression as Start Month being 1 , second month being 2 and so on:
Date Month Counter
Dec-15 | 1 |
Jan-16 | 2 |
Feb-16 | 3 |
Mar-16 | 4 |
Apr-16 | 5 |
May-16 | 6 |
Jun-16 | 7 |
Jul-16 | 8 |
Aug-16 | 9 |
Sep-16 | 10 |
Thanks Guys!
This you want from the script or directly in your front end chart? I think doing it in the script might be an easier option. Chart expression can get messy
Most common is to match the start- and end-dates with a calendar per IntervalMatch.
- Marcus
This blog by HIC have an example of how to this in the script:
(year([Date#(DateMonth, 'MMM-YY')])*12 + Floor(Month([Date#(DateMonth, 'MMM-YY')])) )
-
(year(min(TOTAL [Date#(DateMonth, 'MMM-YY')]))*12 + Floor(month(min(TOTAL [Date#(DateMonth, 'MMM-YY')]))) )
+
1
Thanks Gents appreciate it, tried all your methods and it worked.
Appreciate it.