interval table

[#1]

hi i have a table with a calculated dimension( periode en jours) i  want to count values between  120  and 240 in this table  any ideas

please?

[sunny_talwar]

May be this:

If(Interval(DATA_BOLLA-DATE_COMM_LIV, 'd') > 120 and Interval(DATA_BOLLA-DATE_COMM_LIV, 'd')  < 240, 1, 0)

[#3]

thanks for your reply i want to count haw many values between 120 and 240 in this calculated dimension ?

[swuehl · Accepted solution]

You want to count in which context? In a text box?

Maybe like

Sum(

    Aggr(

        If(Interval(DATA_BOLLA-DATE_COMM_LIV, 'd') > 120 and Interval(DATA_BOLLA-DATE_COMM_LIV, 'd')  < 240, 1, 0),

        [NUM_COMM_...]  // replace with your full field name you've used in your chart

     )

)

[sunny_talwar]

I guess then follow how Stefan mentioned:

Count(Aggr(If(Interval(DATA_BOLLA-DATE_COMM_LIV, 'd') > 120 and Interval(DATA_BOLLA-DATE_COMM_LIV, 'd')  < 240, 1, 0), YourChartDimensions))

[#6]

thank you it works