Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I was getting 0 in the x-axis bar chart.Please help me how to remove it .It was coming because of using year to date function in dimension.
Check the attachment and also is there a way can i join both the charts in one.Expressions are same,but dimensions are different.
Thanks,
Venkat
what is your expression ?
not sure whats ur calculated dimension but you write something like if(yeartodate(...)=0,'')
Dimension is Year2date(Date),Expression iam using dual to calculate the % and num
Can't you simply tick the check box "Hide Axis". Will that help?
Thanks,
Ram
Thanks for your reply.If i remove the legend that's working .But i need to show dimension name in X-axis.Any ideas
Thanks,
Venkat
If you in a hurry situation, just use a text box to hide it ![]()
you must have checked the option "Text on Axis" option in the Expression tab. un-
check that option.
Nope actually 0 is coming from calculated dimension. I had a dimension date field like 'DD/MM/YYYY'.when i use that i am getting graph as per every year but i need upto date.So, i used year2date which is causing that 0.
so you have two dimensions and three expressions on the bar chart. correct?
Can you please post the expression you are using in the calculated dimension.