Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
BrianConnelly
Icon for Resolver III rankResolver III
3 years ago

Are you using a Date Dimension?  If so, have a column for the Day Number, for example..

DayNum = DAY([Date])

Then create a another column that you can filter (could use a measure as well)

Is Day Num before Today = IF(DayNum <= DAY(TODAY()), "Yes","No")

On your chart add the "Is Day Num before Today" and then select "Yes".

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      BrianConnelly
      Icon for Resolver III rankResolver III
      3 years ago

      Can you share some screenshots so I can see what is happening?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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