I am working on making an application about exchange rates. In the chart a line should be plotted about the daily exchange rate, but on the X-axis only the months should be mentioned (see QVW-file).
If have tried this with dual(Month, Date) as a calculated dimension. The problem here is that on every date the month is mentioned and I would like to have the month mentioned only on the X-axis on the first date of the month and not repeated on each date. I have tried to do this with below formula:
This however does not work as not for each month there is a value for the 1st of the month. I need a formula that selects the first date in each month (for example 02-11-2009) and then give the monthname on the X-axis and otherwise ' '.
