1 Reply Latest reply on Feb 20, 2018 6:39 AM by lenaic.ridinger

    Educational Brain Teaser ==> Answer 1 : running_sum by Year

    Shinichiro Murakami

      Thank you the replies

       

      This case, the condition is not tight, and there were various ways of approach including which I did not imagine.

      That's also fun and really educational, but had to summarize....

      But will try my best

       

      I will not cover all the approaches, but typical several approaches will be mentioned in this post and next post.

       

      Question:

      Educational Brain Teaser : running_sum by Year

       

       

      What was the problem?

       

      With this, becomes cumulative for entire period, not stop at year level. ==>  NG!!

       

       

       

      With this, nothing becomes cumulative.

       

       

      Does it work if I explode to smallest level of "Day" ??

       

      ==>  OK? ======>

       

      orz   (<== This means People who are depressed, famous in Japanese Web communication and of course you can use)

      なんて読むかわからない。orz | シルエットデザイン

       

      From here, sample of answers I got.

       

      Answer #1   Put everything with exploded.

       

       

       

      This works, but because of "Day" level granularity, it's not comfortable.

       

      Answer #2    put "Year" only, but with some conditions.

       

       

       

      There is no smaller level of noise, and this might be the simplest solution ins this teaser.

       

       

      Here the condition is I use different calculated field to represent "year"

      year(date) does not work though, because it's is different granularity level. I guess??

       

       

       

      It's getting longer and I will post another approaches next time.

       

      If you think this post is useful, please click "Like" top right or under each reply.

       

      I will attach workbook next time.

       

       

       

      Thanks,

      Shin