topic How to show consolidated values on visual without removing the dublicates in data set in Custom Visuals Development Discussion

How to show consolidated values on visual without removing the dublicates in data set

pakkirkani — Wed, 11 Sep 2024 13:57:37 GMT

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 -

Re: How to show consolidated values on visual without removing the dublicates in data set

lbendlin — Thu, 12 Sep 2024 17:36:53 GMT

what would be the expected outcome?

Re: How to show consolidated values on visual without removing the dublicates in data set

pakkirkani — Mon, 16 Sep 2024 10:57:34 GMT

The outcome should come as 1 in the visual instead of 4 .

Re: How to show consolidated values on visual without removing the dublicates in data set

lbendlin — Mon, 16 Sep 2024 12:31:22 GMT

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.

Re: How to show consolidated values on visual without removing the dublicates in data set

pakkirkani — Tue, 17 Sep 2024 12:55:14 GMT

I want to show in the clustered bar chart - is that possible

Re: How to show consolidated values on visual without removing the dublicates in data set

lbendlin — Tue, 17 Sep 2024 15:03:27 GMT

No idea how that would look like. Why 1 and not 4 ?