topic Re: Obtaining a Key Value to reflect Number of Stores On Target in SAS Visual Analytics

Obtaining a Key Value to reflect Number of Stores On Target

President — Fri, 20 May 2022 08:37:11 GMT

I can't share the actual data because its confidential, but please see excel file with a simple example of the data I have.

All I am trying to do is to get the total number of stores On Target in terms of sales and place that number in a Key Value.

Store - Name of the store

Actual Sales - Sales that have been carried out

Target Sales - The target sales amount or the day

Target Ratio = Actual Sales/Target Sales

Target Reached - This is a calculated item that I created to return "On Target" or "Not On Target" depending if the ratio is >= 1

Thanks

Re: Obtaining a Key Value to reflect Number of Stores On Target

Sam_SAS — Fri, 20 May 2022 15:18:45 GMT

Hello,

There might be better ways of doing this, but I think this should work:

1. Create a distinct count of Store. You could do this by right-clicking Store in the Data pane, selecting New Calculation, and then selecting Distinct count.

2. Assign the new Distinct Count measure from step 1 to a Key Value object.

3. Assign a filter to the Key Value, based on your Target Reached calculated item. Select "On Target".

The Key Value should display the number of stores that are on target.

Let us know if that helps!

Sam

Re: Obtaining a Key Value to reflect Number of Stores On Target

President — Mon, 23 May 2022 07:39:48 GMT

Hi @Sam_SAS

Thanks so much for the assistance.

I am going to give a go this morning, then I will update you.

Kind Regards,

Fungai Jani

Re: Obtaining a Key Value to reflect Number of Stores On Target

President — Mon, 23 May 2022 10:18:01 GMT

Good morning @Sam_SAS

It looks like it worked, thanks a lot for the assistance.

Kind Regards,

Fungai Jani

Re: Obtaining a Key Value to reflect Number of Stores On Target

Sam_SAS — Mon, 23 May 2022 13:11:31 GMT

Great! Thanks for letting us know 🙂

Sam