find out Upcoming number of Birthdays monthwise in Script

[ArjunPrasad]

Hi All,

I have a table like below with data

Data:
LOAD [Date of Joining],
[Emp Name],
[Date of Birth],
[last day at office]
FROM
[C:\Users\Documents\Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Data:

Date of Joining	Emp Name	Date of Birth	last day at office
4/8/2019	Raghu	14/01/1990	Null
5/5/2019	Ashok	3/3/1993	2/2/2020
20/3/2017	Sai	4/5/1995	6/5/2020
5/3/2015	Ramu	31/3/1990	1/8/2020

Would like achieve in script to know right from Jan to Dec how many number of cakes to be ordered to celebrate the birthday of emp every month wise.

Can you please suggest me on this.

Thanks in Advance..

-Arjun

[tresesco]

It should be pretty simple - counting the Date of Birth month wise. If you have a master calendar you can do that joining this count to it. However, using UI expression would be simpler; you can just take one table chart and month as dimension, expression being something like : Count( [Date of Birth])