combo chart not showing zeros when there is no value

[#1]

Hi All,

I'm using a combo chart, where my line chart is not showing zeros when there is no value.

the bar chart is wotrking fine, but my line chart is not showing zero values and my line is alsio not getting extended.

Sum(sales) is my bar chart expression.

num(round(sum(aggr( sum(sales),country,year))/sum(aggr( sum((sales),country,year)),0.0001),'0.00%')

i have used if condition as well but no luck

if(num((sum(aggr( sum(sales),country,year))/sum(aggr( sum((sales),country,year)),0.0001),'0.00%')>0

,num((sum(aggr( sum(sales),country,year))/sum(aggr( sum((sales),country,year)),0.0001),'0.00%') ,0)  no luck

this is how my current output is like i need zeros if there is no value and the line should also extend and say zero

[Frank_Hartmann]

can you post a sample?

[Anil_Babu_Samineni]

Have you used the representative  for line of your second metric.  If so,  can you share the presentation  tab screen shot

[johnw]

Have you unchecked Suppress Zero-Values on the Presentation tab?

You've probably already tried that, and it didn't work, but I want to make sure we start with the basics, like when tech support asks, "Is the computer plugged in? Have you tried rebooting?"

There are lots of reasons it wouldn't work, and lots of solutions to get what you want. But the right approach will probably depend on the specifics of your situation. So as franky_h79 says, can you post a sample?

And just in case it's of use, here's a line chart with the zeros displayed. In this specific case, the difficulty was that we didn't have all the dimension values in our data, so had to generate the missing ones before unchecking Suppress Zero-Values would work. I don't think that's your problem, though, since you have bars for all your values.

[#5]