Forum Discussion
How to show consolidated values on visual without removing the dublicates in data set
Hello Guys,
Please help me to get a solution on below.
there are 4 different POs combined under the same booking & I want to show them in the visual based on booking as a single value without removing the dublicates in the data since they are different POs.
| PO | Category | Origin Country | Carrier | Booking reference | Arrival |
| 45598155979 | XXX | Spain | XXXX | 24276953712 | XXX |
| 45598525981 | XXX | Spain | XXXX | 24276953712 | XXX |
| 45598559277 | XXX | Spain | XXXX | 24276953712 | XXX |
| 45598559182 | XXX | Spain | XXXX | 24276953712 | XXX |
Now showing as below -
5 Replies
- lbendlin
Super User
what would be the expected outcome?
The outcome should come as 1 in the visual instead of 4 .
- lbendlin
You would create a matrix visual that has both the booking reference and PO numbers.
In collapsed view you get the total number
In expanded view you get the PO details.
I want to show in the clustered bar chart - is that possible
