I have a certain field which contains the location of a file. The filepath looks like this /some/path//some.csv. I want to group my results based on the file paths that match except the date condition. For example Field1 /a/b/c/2016-01-01/abc.csv /x/y/z/2016-01-01/xyz.csv /a/b/c/2016-01-02/abc.csv /x/y/z/2016-01-02/xyz.csv /a/b/c/2016-01-03/abc.csv /x/y/z/2016-01-03/xyz.csv I want something like this if I were to do a count /a/b/c/*/abc.csv 3 /x/y/z/*/xyz.csv 3 ... View more