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.
After the 6th row it returns 'Error'
DataSource.Error: invalid query locator
Details:
List
Also, I left out the column for Meeting Date which would be a date we use to filter on.
not sure why you leaving that out, how many columns you have?
I just left it out in my mockup.
I'm pulling a custom object from Salesforce.
I have 13 columns in addition to ID
I guess BRE ID is unique column, if yes, you cn create a duplicate column, remove all column from it, and keep these 4 column in duplicated table and unpivot that.
Eventually you will have two tables, and then yu can set relation on BRE ID between those tables and that will get you going.