Forum Discussion
Line chart latest month days
Hi, I created a line chart to show the balance movement on a daily basis, comparing few months trends. For some dates the data is missing, so I added the formular to add zero and used a day in t...
BrianConnelly
Resolver III
Resolver IIICan you share some screenshots so I can see what is happening?
Hi.
I don't have the data for the last day of the month, that is why in the measure I add 0 to the sum of balance. Then link the date to the calendar table and use the calendar date in X axis.
Without adding a zero the chart look like this, so the end of the month 31st or 30thth is missing.
With the zero it looks like I want, but the latest month has future days populated.
With the new day formulars the chart breaks at just over mid month