6 Replies Latest reply: Apr 10, 2017 8:36 AM by Florian Lemarquand RSS

    Calculation condition

    Florian Lemarquand

      Hi,

       

      On a bar chart I display different information but only for the last 12 months. I did this with a set analysis : sum({<[Date]={">=$(=today()-365)"}>}Data) and it works perfectly.

      I don't tick the box "Show null value" to only display the last 12 months on my chart. The problem I have is if in my last 12 months I have a null value it won't be display but actually I want it to be.

      I thought I could answer this problem with ticking "Show null value" and add a "Calculation condition" to only calculate for the last 12 months but I don't know what to write in.

       

      Have you got an idea?

      Thanks in advance