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

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
    ACCEPTED ANSWER

    Re: Venn Diagram in Cognos

    ‏2013-12-18T20:41:35Z  in response to Cog8A

    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
      46 Posts
      ACCEPTED ANSWER

      Re: Venn Diagram in Cognos

      ‏2013-12-18T21:37:15Z  in response to OpherB

      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
        ACCEPTED ANSWER

        Re: Venn Diagram in Cognos

        ‏2013-12-18T23:02:47Z  in response to Cog8A

        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
          46 Posts
          ACCEPTED ANSWER

          Re: Venn Diagram in Cognos

          ‏2013-12-19T19:29:28Z  in response to OpherB

          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
            ACCEPTED ANSWER

            Re: Venn Diagram in Cognos

            ‏2013-12-19T21:45:11Z  in response to Cog8A

            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
              46 Posts
              ACCEPTED ANSWER

              Re: Venn Diagram in Cognos

              ‏2013-12-19T23:46:29Z  in response to OpherB

              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