Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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):
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