4 Replies Latest reply on Mar 20, 2018 8:07 AM by Jim Dehner

# Combining Non Aggregated Values in One Chart

Hello,

So I have data that lists five fields, and an employee, where each employee ranks them from 1 to 5, so the data looks like this:

I want to graph the number of employees that ranked each op on the same chart. Right now it looks like below, but I can't figure out how to get them all onto the same axis so it just shows five different ops overlapped.

Does anyone have any suggestions for a way to makes this work? Since to show this I have each Op as an non aggregate I can't just add to measure values, so I'm not sure what to do.

Thank you,

Dan

• ###### 1. Re: Combining Non Aggregated Values in One Chart

Good morning

see the attached

Not sure how you want the output viz to appear if you use a Line chart on a single axis it looks like this

a bar chart is easier to read

I pivoted your data to create the charts Pivot Data from Columns to Rows

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: Combining Non Aggregated Values in One Chart

Hi， Dan

Is it something like below?

ZZ

• ###### 3. Re: Combining Non Aggregated Values in One Chart

Hi Jim and Zhouyi,

Thank you both for you feedback thus far. I think i may have poorly explained what my goal is. I want each line to represent the  number of employees who ranked each op like the chart below. So the X axis would be the rank for each of them and the y would show the count of how many employees chose that option as their first choice, etc.  Does this clarify what I am looking for?

Thank you,

Dan

• ###### 4. Re: Combining Non Aggregated Values in One Chart

see the attached

this is what the chart looks like

I zero packed the count of employees with this to fill the null values

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.