Bar chart

[srinivasa1]

Hi

I would like to display all date in bar chart ( showing in arrow mark 10/12/2012  and other date is missing in bar chart. i need to display all date )

I have attached sample application for eassy refrence. can any suggest me how can do this

Thanks in advance

[sivarajs]

Those dates doesnt have the amount in it

So that its not displaying but if you want display zero value, goto presentation tab and uncheck supress zero value

[srinivasa1]

Thanks for Quick reply i would like to shows 0 in bar if sum(Amount)=0
can you pls guide me

Thanks

[#4]

In presentation tab click on the "Zero on Bars" radio button. This is below the unchecked "Suppress Zero Values". In the Expressions tab click on the "Values on Data Points". That should show zero where there are no bars.

EK

[MayilVahanan]

Hi

PFA

Regards,

R.MayilVahanan

[srinivasa1]

Thanks

Its usefull but my date  with time also when im trying format to Date([date]'MM/DD/YY')
it will not show a date

Thanks

[MayilVahanan]

Hi

Try with

Date#()

or

timestamp()

or

timestamp#()

because, may be its not correct format for date field..

hope it helps.

[srinivasa1]

Thanks its not working im whenever getting null value like "-"(is null (represnted by "-"))  it will not disply date in bar

Appreciate your help

[MayilVahanan]

HI

Syntax:

Date([date], 'MM/DD/YY')

Hope it helps

or post a sample file..

[srinivasa1]

Hi Thanks for your help.

Your right but there's pbm in my data as its comes in null one more dim.i have found that some other way to  handle  this and its working .done format in etl like dateisland  thanks