Bar Chart Year and Month, showing months with no data

[#1]

HI

Wondering if anyone can help feel like im banging my head against a wall !

I have this bar chart which is currently stacked to show tasktype, it also has two other dimensions year and month.

I have the problem in that it is showing me months which have no data,

I have tried cliking suppress 0 values on the dimension and the presentation tab to no avail ! can anyone help ?

I cant use drill downs for this graph as they want it showing on an nprinting slide.

Thanks

Sarah

[miguelbraga]

You can do in the script also something like this:

if(tsk_id <> '', '1', '0') as flag_tsk_id

And then use this expression

count({$<flag_tsk_id = {'1'}>} distinct tsk_id)

[jonathandienst]

Your pictures indicate the "Suppress When Value Is Null" (on Properties | Dimension) is not set for the year dimension. Is it set for the Month and/or type dimensions?

If that does not work, then it is important to understand what is causing the months to display. For example, the values could be non-zero but very small. Posting your app with scrambling and/or data reduction is the most likely to lead to a quick solution.

Preparing examples for Upload - Reduction and Data Scrambling