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

[t_chetirbok]

hi!

can you share your qvw or some sample?

[#3]

Hi Tatsiana,

The data is sensitive so I tricky I've extracted some details on the graph :

[MK_QSL]

Better to provide sample application

[#5]

Is there a way to scramble or encrypt the data sorry never done this before ?

[miguelbraga]

Hey Sara,

Did you tried using a WHERE clause like this:

YourTable:

LOAD *

FROM [pathtoyourdatabase]

WHERE Value <> 0;

This method should eliminate the 0 values

Regards,

MB

[MK_QSL]

Create dummy data and provide sample application.

[#8]

Hi Miguel

I cant do it unfortunately as other columns with data we need to include for those rows if that makes sense

[t_chetirbok]

try this expression

count(distinct if(tsk_id<>'',tsk_id))

[miguelbraga]

Maybe if you do something like this:

=if(tsk_id == '', NULL(), count(distinct tsk_id))

Then check "Surpress Vhen Values In Null".