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:
This graph is only showing the months (X-axis) and the count for each month (Y-axis). I would like to visuialize the feelings of an employees morale such as: Good, Fantastic, OK.
Any help would be appreciated.
5 Replies
Why your Y Axis has only to values, 1 and 2 ?Shouldn't be Y-Axis Sum instead of Count?
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.
