Forum Discussion

k3rz0rg's avatar
k3rz0rg
Advocate III
6 years ago
Solved

Issue with the date column!

Hi all,

 

lately I am experiencing an issue with the date column in one of my reports!

When I load the data from the query editor refresh with excel as source keeping historical data, the table shows that it has the most recent date inside the query editor. Then I do the close and apply but at the data view section of the desktop, the column does not show the most recent months. It is stuck until june. I have no filter set on that table or anywhere!

Can somebody heap me with that?

 

                 

 

 

 

 

 

 

 

 

 

 

 

 

The left one is inside the query editor which seems fine but the right one is the data view, even after so many refresh, its still the same.

 

Any help would be appreciated.

 

Thanks,

K3.

Need Help
  • k3rz0rg's avatar
    k3rz0rg
    6 years ago

    Thank you all for the suggestions, however, nothing helped to solve that weird issue.

    I ended up recreating the exact same report with exact same data copying the exact same code from the adavanced editor for each table and the new report has no issue! 

    I still don't understand what happened with the older report that was not showing me any data beyond june but the 100% replica is working fine!

     

    Anyways, thank you all for responding to my issue and the suggestions.

     

    - K3

9 Replies

  • MCornish's avatar
    MCornish
    Responsive Resident
    6 years ago

    Have you got a step that filters them later, or on your report, a slicer/report level filter?

    • k3rz0rg's avatar
      k3rz0rg
      Advocate III
      6 years ago

      Hi MCornish , I have no filter on any of the tables, it's just taking the data from query editor straight! I do have date slicer but also tried removing those slicer but no luck.

       

      Hi Anonymous , I checked the modeling pan and tab, removing/modifying all the connections, tweaking them in multiple ways yet no luck. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I just saw thats the table pane, are the visualizations wrong when you put it in any visual?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Looks like a modelling outside the query editor, the format on the modelling pane, but had to look for the exact cause.

  • k3rz0rg's avatar
    k3rz0rg
    Advocate III
    6 years ago

    Thank you all for the suggestions, however, nothing helped to solve that weird issue.

    I ended up recreating the exact same report with exact same data copying the exact same code from the adavanced editor for each table and the new report has no issue! 

    I still don't understand what happened with the older report that was not showing me any data beyond june but the 100% replica is working fine!

     

    Anyways, thank you all for responding to my issue and the suggestions.

     

    - K3