How to discard zero values in bar chart?

[#1]

Hi to all,

As you see in screenshot below, I could not discard zero values in bar chart. Is there anybody who knows how to achieve this?

Thank a lot in advance!

[#2]

i still get the same result

[arulsettu]

can you explain what you trying to do in dimension

[#4]

Actually, for one dimension to be created, i need two [Seri Açıklaması] names. Because in the expression side, i use these two different [Seri Açıklaması] names for one dimension and substitute these two values from each other. So, i am trying to combine this two names into one dimension name. I know, it seems highly complicated, and i hope i could explain clearly what i am trying to do

[arulsettu]

[Seri Açıklaması] is a single field right?

[pk2019]

Hi Oytun,

Are there Null values in your data that is causing this?

Thanks,

Paul

[#7]

Yes, you are right! it is a single field, i use the names in it during calculation process.

[#8]

Hi Paul,

There is no null values actually causing this problem Thanks a lot.

[arulsettu]

are you trying to limit few values from the field?

for ex

field

1

2

3

4

5

6

7

8

9

10

you are trying to show only

field

2

4

6

8

10

[#10]

Yes, you are right Arul. But, for example i use just 2 and 4 in the expression region. (Sum(2)- Sum(4)) and in the dimension region i would like to combine these two values and show this as just one dimension name like "even number".

In the second expression section, i use just 1 and 3 in the expression region. (Sum(1)- Sum(3)) and in the dimension region i would like to combine these two values and show this as just one dimension name like "odd number".

[arulsettu]

if you post sample data it would be easy to find out