Forum Discussion
How would I create a Trend Analysis visualization (line graph) using text of employee Morale
Hello, How would I go about creating a trend analysis visualization (line graph) to track employee morale / employee workload with Months / Years. Currently, this is what I have: T...
Omar_204 I think this broken visual has to do with either your dataset does not contain the right information or the relationships of the tables that you have defined is inaccurate. I will show you one quick example here.
I have created 3 simple tables: Date, Morale, & Fact. My Fact table contains information that can relate to Date & Morale tables where each period (Month) has Morale evaluation results for each employee (I am assuming to have 8 employees). The line chart takes Month as the Y-axis, Count of Employee ID as the X-axis, and Employee Morale as the legend. The visual from these tables are shown as below. (Note that this example is not the best but should help to give you some ideas to work on yours) Thanks.
