- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Good morning @Sam_SAS
It looks like it worked, thanks a lot for the assistance.
Kind Regards,
Fungai Jani
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Great! Thanks for letting us know 🙂
Sam