Count of products per week?

[#1]

Hi,

I have to create how many Products there are per week.

I used

Dimension: Week

Expression: Count(Distinct(Productname))

will this get correct values? can anyone suggest me please.

Thanks.

[#2]

but what is the difference? I will get the same result right?. If I want to show count of individual Productname per week(individual days in that week). how can I do this?

[SunilChauhan]

if you have date field then you can use below for weekday in dimension

Date(Date,'WWWWW')  it will provide you weekdays of  week individually.

hope this helps

[aveeeeeee7en]

I am little confused on your exact requirement.

Can you attach an excel file showing what Actually you want??

[#5]

This is my requirement

1)  A summary of how many Products there are per week.

e.g.

Table

                            Week 1        Week 2        Week 3
No of Productnames  
  

Chart
Bar chart showing week number on the horizontal axis and number of Products on the vertical axis.

2)  A summary of the Productname split per week

Table

                               Week 1            Week 2             Week 3
Clothes  
Soaps  
Wardrobes  
..  
..  
                   

Chart

Line chart showing week number on the horizontal axis, a legend showing the Productname and the number of Products on the vertical axis.

[SunilChauhan]

If you have date field the use below in dimension

'Week'&Week(Date) as Week,

and

below in Expression

count( distinct ProductName)

hope this helps

[SunilChauhan]

see the attched file for help