Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a bar chart with the below requirement.
Let's assume the below mentioned sample data,
Customer | Field Name |
---|---|
A | AD |
A | BG |
A | BM |
B | AD |
B | BK |
B | BM |
C | KL |
C | BG |
C | SR |
C | BM |
If customer A is selected, it needs to show the unique field count used by other customers in a bar chart. For customer A, there are 2 same fields in customer B and C.
But the "Field Name" = BM is getting repeated in customer B and C, so the count needs to be 2 for customer B and 1 for customer C in bar chart.
I just need to show only the unique fields count in the chart. All help appreciated.
Attached sample data and qvw file.
Regards,
Siva
Why customer C needs to be 1? Your C customer has a field name BG that matches customer A. Right?
Yes, the customer C has two field names matching with customer A - BG and BM. But the field BM is already matching with customer B too.
When the field is repeated again, I need to ignore them in the count. So, the result should be Customer B - 2 fields (AD and BM) & Customer C - 1 field (BG).
The unique fields matching with customer A from other customers are totally 3 fields (AD, BM and BG).