Forum Discussion
Creating a shared axis from multiple columns
mspiep01 you need to unpivot your data to achieve this.
- Go to query editor
- Select BRE ID column, right click on it, select unpivot other columns
- it will give you 3 column, BRE ID, Attribute, Value. Rename attribute column to Impact
- close and apply
Now you can use Value column on X Axis, Impact as Legend, Impact on Values which will be count.
mspiep01 you need to unpivot your data to achieve this.
- Go to query editor
- Select BRE ID column, right click on it, select unpivot other columns
- it will give you 3 column, BRE ID, Attribute, Value. Rename attribute column to Impact
- close and apply
Now you can use Value column on X Axis, Impact as Legend, Impact on Values which will be count.
After the 6th row it returns 'Error'
DataSource.Error: invalid query locator
Details:
ListAlso, I left out the column for Meeting Date which would be a date we use to filter on.
