Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I constructed the master calendar for the Hiredate field,
Now my quest is to find number of hirings per month year
Thank you
Assuming have a field containing YearMonth, then you can use that as an Dimension in a chart or table together with a measure for calculating the number of hirings. How It is calculate is depending on your data, but it could be like one of the two below
Count(HiringID)
Sum(NoOfHires)
Assuming have a field containing YearMonth, then you can use that as an Dimension in a chart or table together with a measure for calculating the number of hirings. How It is calculate is depending on your data, but it could be like one of the two below
Count(HiringID)
Sum(NoOfHires)
Thanks for replying