Forum Discussion
Ryan19
6 years agoRegular Visitor
Combine Line Charts Built off the Same Field
We have a simple table with visitor data that includes an arrival date/time and departure date/time, and we've charted the year's worth of data based on the hour of day, as shown in the attached imag...
Icey
Community Support
6 years agoHi Ryan19 ,
It is suggested to create another Dates table. And then create relationship between your fact table and the Dates table. Use the date/time hour column from Dates table as x-axis.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.