Report Portal

MDX - Counting Consecutive Days

A recent blog post (here) questioned a method for returning the most consecutive days that a customer has brought product for. For example, given a particular customer what's the largest continuous date span of their purchases? More realistically, a business question may be 'what are the customers who purchase for more than 5 days in a row'?

Read more...

Tags: mdx, time

 

2007-2015 VidasSoft Systems Inc.