Showing values within date range?

Hi everyone,

I’m trying to show quantity of sales over a specific date range. This range is from when the individual finished their training to 6 months after that date. I have a date field for when each person finishes their training and another calculated field for 6 months after that date. Wondering what next steps could be to so I can show the # of sales that fall between those 2 date markers.

Thanks!

Hi @megaman8, Do you have Sale Date and Sale Id columns in your dataset along with training completion date? It will be helpful if you are able to share mocked up data to explain your requirement.
Assuming you have Sale Date and Sale Id columns, you can create a calculated field to count # of Sales either using ‘countif’ or ‘distinct_countIf’ depending on how transactions are stored in your dataset and the condition to count sales should be something like Sale Date >= Training Completion Date and Sale Date <= Training Completion Date +6months(The calculation that you have already created).
If this works for you please mark this as solved.
Regards,
Karthik

1 Like