Show Dimension with NULL value in Bar Chart

[Anonymous]

Hi Folks,

I have a Bar Chart, Dimension MCJahrWoche and would like to show all Weeks in the Bar Chart, also those with no values.

Thereafter I want to calculate GetPossibleCount(MCJahrWoche) / All Weeks (including those with no values).

I tried some things, however, they did not work so far.

(Week 2017/02 to show with no bar,

calculation 6/7 = 0,857) (6 I get with GetPossibleCount(MC...), but how do I get the seventh week into it?)

Thank you so much in advance!

Wolfgang

[Frank_Hartmann]

try to add this as expression:

avg({1}1/1)

and make the expression invisible or just use

this as expression:

count(Aufl.....)+ Avg({1} 0)

hope this helps

[Anonymous]

Hi Suresh,

unfortunately there is nothing attached.

[sureshsindhigi]

Hi Wolf,

I have attached, but I don't know..why you're not seeing it. 🙂

let me send you again. !!

Regards,

Suresh Sindhigi