0 Replies Latest reply: Dec 11, 2012 6:43 AM by jhydoski RSS

    Chart Total Count and NullCount problems

      Hello all,

       

      My first post here, and I assume it's a silly one!

       

      Due to client confidentiality, I am unable to post the QVW, so I'll try my best to explain the problem and what I'd like resolved.

       

      **

       

      So, I'm trying to visualise data quality for x client. All data is pulled from the client's database through SQL. The client has 4185 suppliers:

       

      • 65 percent of those suppliers have VAT Numbers, 35 NULL
      • 45 percent have bank account numbers, 55 percent either have NULL or entry as zero
      • 40 percent have listed cities, 60 percent NULL
      • etc.

       

      I would like to make a radar chart that shows NULL/0 entry count for each of the above criteria. (So, nullcount radar for VAT would have a count of ~1300, etc.)

       

      This was possible through excluding dimensions and calculated dimensions, by using the following sample expressions:

       

      if([Bank Account Number]<>'NULL' and [Bank Account Number]<>0, count(DISTINCT([Bank Account Number])))

       

      =Count(DISTINCT{$<[Bank Account Number]={"NULL"}>} [Supplier Name])

       

      =Count(DISTINCT{$<[Bank Account Number]={"0"}>} [Supplier Name])

       

      However, clicking the expressions did not link to any data, I assume because no dimensions were entered.

       

      **

       

      Here's where I'm stuck. The chart should be a drilldown, showing (in order):

       

      1. Count and NULL count for VAT, bank account, cities, etc
        • Would like this to be for ALL suppliers (one radar chart line with value of 1300 VAT nullcount, one radar chart line with value of 2600 VAT total count, etc)
        • Obviously showing a radar chart with 4185 distinct lines per 10 data quality tests is not ideal
      2. Depending if the user clicks a NULL count or total count:
        1. Show all suppliers with NULL or
        2. Show all suppliers with entry
        3. Clicking either of these will list all suppliers in a list box

       

      I understand I have not done well with explaining this, but any help would be very much appreciated. This is an amazing community, and I look forward to being able to give back to it someday!

       

      Please don't hesisitate to ask for clarification, as this was probably a confusing post

       

      Thanks,

      Joe