Topic
  • 6 replies
  • Latest Post - ‏2013-12-19T23:46:29Z by Cog8A
Cog8A
Cog8A
47 Posts

Pinned topic Venn Diagram in Cognos

‏2013-12-18T18:11:16Z |

Hello experts, 

I have a requirement where I have to design a venn diagram to display information of 3 dimension's measures along with their overlaping counts. Ideally this can be archeived in Venn Diagram chat but unfortunately we don't have a Venn Diagram chart, Please kindly suggest some ideas .

I found using google charts as an option but I don't the technical details of using it.

Updated on 2013-12-18T18:11:27Z at 2013-12-18T18:11:27Z by Cog8A
  • OpherB
    OpherB
    664 Posts

    Re: Venn Diagram in Cognos

    ‏2013-12-18T20:41:35Z  

    I think you're out on a limb with this requirement. I checked Cognos 10.2.1 which has the new RAVE chart engine and it doesn't have Venn Diagrams either.

    Good luck,
    Opher

     

  • Cog8A
    Cog8A
    47 Posts

    Re: Venn Diagram in Cognos

    ‏2013-12-18T21:37:15Z  
    • OpherB
    • ‏2013-12-18T20:41:35Z

    I think you're out on a limb with this requirement. I checked Cognos 10.2.1 which has the new RAVE chart engine and it doesn't have Venn Diagrams either.

    Good luck,
    Opher

     

    Thanks Opher, but can you think of any other alternate approach in charts for showing overlapping segments of measure like in Venn diagram

  • OpherB
    OpherB
    664 Posts

    Re: Venn Diagram in Cognos

    ‏2013-12-18T23:02:47Z  
    • Cog8A
    • ‏2013-12-18T21:37:15Z

    Thanks Opher, but can you think of any other alternate approach in charts for showing overlapping segments of measure like in Venn diagram

    No, I really can't without seeing the data and some understanding of how it would be analyzed. Have you looked at things like Area or Radar Charts?

     

     

  • Cog8A
    Cog8A
    47 Posts

    Re: Venn Diagram in Cognos

    ‏2013-12-19T19:29:28Z  
    • OpherB
    • ‏2013-12-18T23:02:47Z

    No, I really can't without seeing the data and some understanding of how it would be analyzed. Have you looked at things like Area or Radar Charts?

     

     

    I have attached the sample. So basically the report has 3 different measures. and then combination of each , making it 6 different measures.

    Please take a look at the screenshot attached.

  • OpherB
    OpherB
    664 Posts

    Re: Venn Diagram in Cognos

    ‏2013-12-19T21:45:11Z  
    • Cog8A
    • ‏2013-12-19T19:29:28Z

    I have attached the sample. So basically the report has 3 different measures. and then combination of each , making it 6 different measures.

    Please take a look at the screenshot attached.

    That doesn't help. I would like to see how the data is laid out. What does it mean for something to be "Direct Mail" AND "Email"? How is that represented in the data?

  • Cog8A
    Cog8A
    47 Posts

    Re: Venn Diagram in Cognos

    ‏2013-12-19T23:46:29Z  
    • OpherB
    • ‏2013-12-19T21:45:11Z

    That doesn't help. I would like to see how the data is laid out. What does it mean for something to be "Direct Mail" AND "Email"? How is that represented in the data?

    Sorry for confusing you, I have Channel Code as a field which contains 3 different values, Phone, Email and Direct Mail . Here my measure is Count of Customers . We have different customers who were contacted through this different channels. Now the business user want to know combination of channels apart from individual channel groups in a visual form more like in Venn Diagram where you can see the overlaps of different segments. For instance I want to see how many customers were contacted by both Email and Direct mail.This is how the data  looks like in a tabular  form

    Channel Code # of Customers
    Phone 1000
    Email 5000
    Direct Mail 2000
    Phone & Email 1250
    Phone & Direct Mail 400
    Email & Direct Mail 1500

    Hope its clear now. Thank you in advance

    Attachments

    Updated on 2013-12-20T03:50:16Z at 2013-12-20T03:50:16Z by Cog8A