Forum Discussion
Post PatronShow repeat customers within a week
Hi GunnerJ
Please refer to the linked discussion:
(the part of repeat in the suggested solution)
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Super UserHi,
Not sure of whether you want to write a measure or a calculated column? Share the tables in a format that can be pasted in an MS Excel file and show the expected result.
Post PatronAshish_Mathur Ritaf1983
Here is a linked file. I have a table that is filtered to one account where all of the ticket occurance dates are within 7 days of each other except for the last ticket which is 8 days from the last ticket for that customer. My goal is to have all of the tickets within 7 days of the last ticket to be flagged.
- Ashish_Mathur
Hi,
In calculating the difference of 8 hours, do you want to consider the time stamp as well or only the date?
- GunnerJ
Ashish_Mathur Honestly I'd take either solution but I suppose just by date and note the date/time would be the preference.
- Ashish_Mathur
Hi,
I tried something but it did not work. I think the best way to solve this is with the new WINDOW functions introduced in December 2022. Once i learn tose, i will revert with a solution.