H
HowieAR
I’m trying to analyze an asset inventory for missing data and present the
percentage of missing data in a chart. I need to analyze it for 5 regions
based on records missing Installation Dates, Records with no Parts entered
for an asset and records with no Specifications entered for an asset. The
data spans 3 tables linked on [Asset]. Table 1 is an Asset List with
[InstallDate] as one field. Table 2 is Parts List with multiple records for
an asset from the asset table and Table 3 is Specifications list with
multiple records for an asset from the asset table.
I’m inexperienced in advance SQL and advanced Queries. I can build
individual queries to give me all the records in Assets with no Install dates
and a query that gives me all Assets with No Parts and one that gives me all
Assets with No Specifications. I can put that in a report that groups it on
Region and that report will do a count but I’m not sure how to carry the
total assets by region value through the report and then present that in
Chart form.
I’m having a hard time getting my head around how to include all three
tables and then Get an individual count of Total Assets by Region (1 – 5)
along with Number of Unique Assets with no install dates by region and the
number of Unique Assets with no Parts Entries and Number of Unique Assets
with no Specification entries. And then put that into a Chart.
Ultimately I want to build a graph that has each Region as a Column with
Percentage of assets completion (0-100) as the vertical information. One
chart representing the Install Dates One for Parts entry and one for
Specification Entry.
I’ve started down Several paths and realize I don’t have the expertise to
put it together. I think My short coming is when and where to use the count
function. I’m sure I have more short comings but I’ll start there and let
anyone that wants to respond tell me the rest. ïŠ
percentage of missing data in a chart. I need to analyze it for 5 regions
based on records missing Installation Dates, Records with no Parts entered
for an asset and records with no Specifications entered for an asset. The
data spans 3 tables linked on [Asset]. Table 1 is an Asset List with
[InstallDate] as one field. Table 2 is Parts List with multiple records for
an asset from the asset table and Table 3 is Specifications list with
multiple records for an asset from the asset table.
I’m inexperienced in advance SQL and advanced Queries. I can build
individual queries to give me all the records in Assets with no Install dates
and a query that gives me all Assets with No Parts and one that gives me all
Assets with No Specifications. I can put that in a report that groups it on
Region and that report will do a count but I’m not sure how to carry the
total assets by region value through the report and then present that in
Chart form.
I’m having a hard time getting my head around how to include all three
tables and then Get an individual count of Total Assets by Region (1 – 5)
along with Number of Unique Assets with no install dates by region and the
number of Unique Assets with no Parts Entries and Number of Unique Assets
with no Specification entries. And then put that into a Chart.
Ultimately I want to build a graph that has each Region as a Column with
Percentage of assets completion (0-100) as the vertical information. One
chart representing the Install Dates One for Parts entry and one for
Specification Entry.
I’ve started down Several paths and realize I don’t have the expertise to
put it together. I think My short coming is when and where to use the count
function. I’m sure I have more short comings but I’ll start there and let
anyone that wants to respond tell me the rest. ïŠ