Compare values in charts

[Anonymous]

Guys,

Assume I have a bar chart with dimension as customer and showing no. of fields for each customer in y-axis as shown below,

By using the values in the above bar chart, I need to create another bar chart by satisfying below conditions,

1. In the above bar chart, there are 3 customers, Hapag Lloyd has 3 fields, Addivant has 2 fields and Cargosmart having 1 field.

2. As per this data in above chart, Hapag Lloyd has to come first in the bar chart that I'm going to create, since it has highest value out of all the customers.

3. Then, Addivant has to come since it is having second highest, but fields of Addivant should not be common to the fields of Hapag Lloyd. But here, 2 fields of Addivant are common or matched with the fields of Hapag Lloyd. So, here Addivant count will be zero or won't exist.

4. Similarly, for other customers. I need to achieve this logic dynamically. Kindly help me out guys.

Thanks,

Siva.

[Anil_Babu_Samineni]

Looks like you already create this thread earlier when i see backward. So, I would ask you to share some sample which demonstrates the issue. Please make a draw neat and clean image which number you need to show.

[techvarun]

Try below expression.

Count(aggr(Count(distinct Fields), Fields))