I want to cacluate a
metric called acquisition rate whereby i want to know how many new customers
have been acquired in any period, be it day, week, month etc. what would be
right way of doing it and which function should i use for it. i have
inserted all customers record in the fact table.