topic Issue with SAS Visual Analytics 7.3 in SAS Visual Analytics

Issue with SAS Visual Analytics 7.3

sassy7 — Thu, 25 Jun 2020 15:45:54 GMT

Hi,

I am working with SAS VA 7.3 for building reports for quality control in manufacturing industry. The dashboard should show three types of reports linked together: the frequency of each defect, the frequency of the defects grouped by the product type and a time series that shows the frequency and % of defects per day.

The three reports are linked through a filter interaction: firstly the type of defect is selected, then the product group and at the end, the time series shows the trend of the defects through the time period.

I am having problems with the time series, more precisely with building the aggregate measure that shows the % of defect on total items produced. I have tried with a couple of aggregate measures but none seems to work. The first formula shows the % of defect on daily basis (so for the whole time period the sum of % is 100) and the second formula is equal 100% for each day.

Instead I would like to show the % of defect on total items produced day by day:

Here's an example of the data source

Can you help me resolving this issue?

Re: Issue with SAS Visual Analytics 7.3

PetriRoine — Mon, 29 Jun 2020 08:54:04 GMT

Hello @sassy7

Let's see if I can help you. Here's a table I did:

I wasn't quite sure about the exact measure you were after so here's my three pics:

Defected (% of total) is daily defects divided by total defects.
Sum ByGroup Defected / Sum ByGroup Frequency is daily defects divided by daily production.
Sum ByGroup Defected / Sum ForAll Frequency is daily defect divided by total production.

Is any of these what you want?

Best regards,

Petri

Re: Issue with SAS Visual Analytics 7.3

sassy7 — Tue, 30 Jun 2020 10:11:24 GMT

Hi Petri
Many thanks for your help!!! 🙂 The second one (B) is the aggregate measure I was interested in obtaining.

Re: Issue with SAS Visual Analytics 7.3

PetriRoine — Tue, 30 Jun 2020 13:14:18 GMT

Great!

So the steps taken are:

Create a new calculated item called Defected

IF ( 'Defect'n = 'NONE' )
RETURN 0
ELSE 'Frequency'n

Create a new calculated item called f.ex. Defected %

Sum [_ByGroup_] ('Defected'n) / Sum [_ByGroup_] ('Frequency'n)

That's it!

Best regards,

Petri