Measure calculation

[Anonymous]

Hi, Gurus.

I have a task to calculate performance of product launches.

One of KPI is NSD - numeric sales distribution, which calculates - #selling points of selected product / #selling points of any product.

I have incoming data of 5 products with different selling periods of each (pre-calculated first 10 weeks of every product).

4 products have correct names and 5th is a groupped name - Other products (to decrease number of incoming rows). 

The task is a simple line chart of 4 products (exclude Other products) and there performance in there 1st 10 weeks - so x-axis is 1-to-10 values. The problem is - calculation of NSD denominator. I've calculated with datediff [weeks on market] for every product.

But! Other products includes more that 10 weeks due to different launch dates of every product:

Data fields:

selling_point

week_start_date

product_name

product_category

data_provider

warehouse

So here is where help is required. I need to calculate #unique selling points for week_start_date, but showing only weeks_on_market. Several filters should be applicable.

[Anonymous]

Hi @Anonymous,

>>So here is where help is required. I need to calculate #unique selling points for week_start_date, but showing only weeks_on_market. Several filters should be applicable.

I'm not so clear about your description. Can you please explain more about these?

How to Get Your Question Answered Quickly
Did you mean to get the unique count of the product based on each 'start date' or get unique count based on the weeknum and 'start date' group?

Regards,

Xiaoxin Sheng