Forum Discussion
Relation ruins visuals
Hello,
I'm attempting to establish a connection between energy data and weather data tables. Both of the columns I'm attempting to link are formatted as "Long date."
However, when I create the relationship between these tables, the visualizations that rely on data from the energy tables cease to display any information.
I'm not sure if this explanation is clear, but I'm hoping someone can provide assistance.
Weather table:
Energy data table:
3 Replies
The "Long Date" is only an ornament of the value. What really counts is the data type, like "date" and "datetime".
Here's the kicker: Internally there is no such thing as a "date". Everything is datetime, but the "date" values are pegged at 00:00:00am time.
Most likely you have data that goes down to time granularity on one table and "midnight" on the other table. When you join these tables the results will only include the columns that are actually at midnight.
Thank you for your response. The data type for both tables has been determined as "Date" ?
Hi,
Ideally you should create a sepeate Calendar Table and build a relationship (Many to One and Single) from the 2 Fact tables to the Date dimension table.
