topic Re: How would I create a Trend Analysis visualization (line graph) using text of employee Morale in Custom Visuals Development Discussion

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

Omar_204 — Fri, 24 Jun 2022 20:22:08 GMT

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.

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

JChai — Mon, 27 Jun 2022 14:13:22 GMT

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

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

Omar_204 — Mon, 11 Jul 2022 16:04:17 GMT

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.

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

JChai — Mon, 11 Jul 2022 19:39:33 GMT

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

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

Ali_Alkhadhar — Wed, 13 Jul 2022 10:32:39 GMT

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

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

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

Omar_204 — Thu, 14 Jul 2022 14:04:42 GMT

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.