How would I create a Trend Analysis visualization (line graph) using text of employee Morale

[Omar_204]

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.

[JChai]

@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.

[Omar_204]

Hi @JChai,

When I went to create a line graph, it's showing only Axis NOT X-Axis or Y-Axis. How did you get both of these fields to appear.

See below.

[JChai]

Hello @Omar_204,

I am not certain how your data looks like but I think adding the MORALE column as legend for the line chart should work fine for your objective.

Best,

JKC

[Omar_204]

Hi @JChai ,

I added the MORALE column to the legend and it's only showing up as dots/points. I want this trend graph to show as a line graph. 

The Axis is the Months, and the values is set to the count of morale.

Any ideas ?

Thank you.

[Ali_Alkhadhar]

Why your Y Axis has only to values, 1 and 2 ? 

Shouldn't be Y-Axis Sum instead of Count?