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...
Yes, I'm using the date dimention and added additional columns. Unfortunetly the latest month is still showing the line until the end of the month. Possibly need to add day and month.
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