Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Visual showing 1970 for date

Hey

 

I have a visual which uses the uses the Date and Count of Intake Received On date to plot a clustered column chart.

 

 In Dev and Test this works perfectly well. see the chart below pointing to the Dev envrionment dataset

 

But when I point the dataset to Prod it shows as below.

 

Please what could be the possibe cause and the solution.

 

Note the relationship is thesame and data type

 

General Comment
Need Help
Show and Tell
Tips and Tricks

3 Replies

  • CoreyP's avatar
    CoreyP
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Without seeing the data and model I can't be sure. It's either an issue with the relationship and data types, or prod doesn't actually have any data that matches the current context. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Dev data details

       

      Caledar table details

       

      Intake Received On Date details

       

      Relationship in Dev

       

       

      Prod Details

       

      Calendar 

       

      Intake Recieved On

       

      Relationship

       

      Please let me know if you need more info

      • CoreyP's avatar
        CoreyP
        Icon for Solution Sage rankSolution Sage
        2 years ago

        Try changing the data type of "Intake Received On Date" to Date, not Date/Time.