Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everyone,
I created a line chart für the profit and the linechart has the day of a month and the years as dimensions. day is on the x-axis and year on the y-axis. so far so good. I always display the last 4 years. and for example: 2010 the 7th of march was a sunday and I didn't have any profit!! but my chart I not displaying it as 0. It basically makes a straight line to the next day with profit.
does anyone know how to solve this?
regards,
MT
Hi,
Hope this helpful for you
hi,
Try this expression
if(isnull(sum(fieldname) or fieldname=' ',0,sum(fieldname))
where field name is your value or amount
Best wishes,
anant
Hi,
You can write like this in expression.
If(isnull(expression),'0',Expression)
Then tick mark show value on data points in expression tab for this expression.
Regards,
Udit
thanks for all your answers but none of your suggestions works. does anyone of you have another idea??
Hi,
Try going to properties in your line chart and in presentation tab,
uncheck 'Suppress zero-values' and check 'Zero on bars'
This should work fine.