Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to a create a venn diagram. I have a column as 'Channel_Usage', I need to find the count for each channel used using the column 'Channel_Usage'. I am unable to do so. Any help regarding this will be highly appreciated.
Thanks in advance.
Regards,
Aaspruha
Try this sample, it uses Google Charts.
Hi Daniel,
Thanks for the reply. ![]()
But I still face some issues.
Details provided:
I have a field as 'channel_name' in my file where 3 values are present : 'ATM', 'POS', 'TELLER'
Here ‘ATM’ has been defined as Set1, ‘POS’ as Set2 and ‘TELLER’ as Set3 (Set1, Set2 & Set3 are the bookmarks defined).
‘x_field’ is a field defined manually using the below script:
LOAD * INLINE
[
channel_name, x_field
ATM,1
TELLER,2
POS,3
];
In the ‘Expressions’ tab:
='http://chart.apis.google.com/chart?cht=v&chs=330x220&'&
'chdl=Set1|Set2|Set3&'&
'&chco=8DAACB,FC7362,BBD854&'&
'chd=t:'&
sum({Set1}x_field)&','&
sum({Set2}x_field)&','&
sum({Set3}x_field)&','&
sum({Set1*Set2}x_field)&','&
sum({Set1*Set3}x_field)&','&
sum({Set2*Set3}x_field)&','&
sum({Set1*Set2*Set3}x_field) has been mentioned.
The above image shows the chart obtained.
Can you suggest the steps to be implemented to get the correct venn diagram?
Thanks & Regards,
Aaspruha