Forum Discussion

Lightice83's avatar
Lightice83
Helper I
3 years ago

Not all date data displaying in chart

Hi team,

 

I have an simple area chart with 'Returns' as the Y-Axis & 'Dates' as the X-Axis with no filters. The data pulling through to the chart starts in Sep 2016 but the data in the source starts in Jan 2015. 

 

Why would the periods Jan 2015 to Jul 2016 not be pulling through to the chart?

 

Thanks!

 

Data Table

 

Date Lookup Table

Need Help

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Lightice83 What is your measure forumula? Also, how are your tables related? I don't see ReturnDate in your calendar table, only in your fact table. Your Date column in your data table seems like it is all 2016 dates. So...

    • Lightice83's avatar
      Lightice83
      Helper I
      3 years ago

      Greg_Deckler 

       

      My measure is a simple COUNTROWS function

       

      I have created a relationship between 'Return Date' in the Data table (which has returns from 2015 onwards) & Date in my Lookup table (which also has dates from 2015 onwards)

       

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        3 years ago

        Lightice83 Maybe some kind of unmatched rows situation? Like your 2015 dates have timestamps so they don't match your date table 2015 dates?