Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thanks Jonathan,
Working well !