Why are the number of bars not equal to the number of month values?

[#1]

Hi folks, How can I reduce the number of bars in the attached document to only show one for each month on the x axis instead of one for each date? Thanks for the help.

[jagan]

Hi,

Use Month as Dimension and expression as

=Sum(Sales)

Regards,

Jagan.

[#3]

In the Script, you can create the New field MMMYY by using text(date(Date,'MMM YY'))

In the UI , the date values are different even though we interpret the format.

[#4]

Thanks dathu, I can't use a text field because I want to show the axis values for 6 months interval. So the x axis of the chart will be Jan 2013, Jun2013, Dec 2013 etc.I guess I won't be able to accomplish this without using a date field.

Do you have any other suggestions?

[#5]

Please check the attached file....

[jagan]

Hi,

In Script arrive a new dimension like this

LOAD

     Date(MonthEnd(DateDimension), 'MMM-YY') AS MonthName,

     *

FROM DataSource;

Now use this as dimension and expression as Sum(Sales).

Regards,

Jagan.