BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
President
Fluorite | Level 6

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.

 

Sales by Store Example.png

 

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

 

Calculated Item to Return Character.png

 

Thanks

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Sam_SAS
SAS Employee

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

View solution in original post

4 REPLIES 4
Sam_SAS
SAS Employee

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

President
Fluorite | Level 6

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

President
Fluorite | Level 6

Good morning @Sam_SAS 

 

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

 

Kind Regards,

Fungai Jani

Sam_SAS
SAS Employee

Great! Thanks for letting us know 🙂

 

Sam

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 543 views
  • 0 likes
  • 2 in conversation