Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My data that I have attached provides an
agent name,
unique sale #,
hire date of the agent
and the date of the sale.
I need to provide an analysis that will allow me to show a count of sales per week. However I need to exclude data where the agent was hired within the last 60 days in relation to the date dimension.
Any guidance would be appreciated. I have attached my data table in an excel spreadsheet.
Thanks!
you can use something like in Set Analysis:
Count( { $<HireDate<60>} Sale#)
Create a variable vagentdate as "=date(Today() - 60)" so that you can configure the number any time and have the expression as count({<[Agent Hire Date] = {'>$(vagentdate)'}>}[Unique Sale ID]) . This will give the sales count of a agent whose hire data is 60 days before today.