Forum Discussion
I need to create column with fulldate from 2013
I have two table with enrollment data. I have first table have enrollments having from 2103 and second tabel having enrollmnets from 2021. i need to create a line chart comparing enrollments between these two tables.
i need separate fulldate column in table to join these to this third table create a visual line based on the date.
If the columns in your two enrollment tables are the same/similar, you should append the tables in the query editor, disable load on the originals and only load the appended table. This will simplify your analysis/visualization.
Pat
Anonymous
If you don't want keep the original tables, you can create a calendar table with full date, create link the calendar with your 2 tables. Then you can just create line charts using the calendar date with data in the other 2 tables.Calendar = Calendar(Date(2013,1,1),Date(2021,12,31))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
2 Replies
- mahoneypat
Microsoft Employee
If the columns in your two enrollment tables are the same/similar, you should append the tables in the query editor, disable load on the originals and only load the appended table. This will simplify your analysis/visualization.
Pat
Anonymous
If you don't want keep the original tables, you can create a calendar table with full date, create link the calendar with your 2 tables. Then you can just create line charts using the calendar date with data in the other 2 tables.Calendar = Calendar(Date(2013,1,1),Date(2021,12,31))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.