3 Replies Latest reply on Nov 13, 2018 9:55 AM by Dan Cory

    How do I create a bar chart separated by year and month/day

    Mike Pratt

      I am trying to create several bar charts, stacked, on the y axis is the fiscal year, and on the x axis I want to list the month/day of that year, so it would be October-September of next year.

      date seperation issue.png

      The formula I tried to use is: DATE(DATEADD('day',DATEPART('day',[Date]),DATEADD('month',DATEPART('month',[Date])-1,#2015-09-30#)))

      It kind of worked, but it is giving me some Null Values. I checked my data, there are no null values there, so i am confused as to where they are coming from, what do i need to change in the formula to fix this?