Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Use Month as Dimension and expression as
=Sum(Sales)
Regards,
Jagan.
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.
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?
Please check the attached file....
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.