Line Graph per MM/YYYY

[Anonymous]

Dear All,

I´m trying to create a line graph that shows a SUM pre month/year. The main problem is that I have different days in a base and the dimension "date([datefiled],'MM/YYYY')" is returning more than one register per month/year.

The expression is a simple SUM([value field])

Please let me know how I can solve it.

Thanks in advance.

[jonathandienst · Accepted solution]

Hi

The date() function does not remove the day value from datefield, it simply formats the display into (in your case) MM/YYYY format. To remove the day value and have only one dimension value per month, you can use:

Date(MonthStart(datefield), 'MM/YYYY')

Hope that helps

Jonathan

[Anonymous]

Thanks Jonathan,

Working well !