search

BITraining / SSRS_12132014_UserStory

11 stars 6 forks source link

Top N Best Selling Products in USA #2

Open derekdai1978 opened 9 years ago

derekdai1978 commented 9 years ago

This report is to show top N (By default 10) best selling product. This "best" is defined by Revenue=sales amount.

Users can pass in year(s) to analyze the best selling products. The table should present the "Net Sold Quantity" and "Net Revenue". On each product name, it can be linking to another report to show product detail information.

liangzz commented 9 years ago

I was trying to add a little extra nice thing to the report. On the top area of the report, I want to add a text box, write an expression that will show " Top N bestselling product in year xxxx" and I got a problem.

Here is my expression: ="Top " & CStr(Parameters!prmTopN.Value) & " Best Selling Products in Year " & CStr(Parameters!prmYear.Value(0))

It works fine when only one year is selected. However, when I select multiple years, only the most recent year was shown. Can anybody tell me how to solve this problem? Thanks!

liangzz commented 9 years ago

Also, both Erina and me have a question:

Please look at the same expression:

="Top " & CStr(Parameters!prmTopN.Value) & " Best Selling Products in Year " & CStr(Parameters!prmYear.Value(0))

What is that "(0)" behind "Parameters!prmYear.Value"? It was added automatically by the program. If you delete it, you will get an error.

txwhiterock commented 9 years ago 
  By Google, the value(0) return first value of the multivalue parameters.

Date: Wed, 28 Jan 2015 08:33:25 -0800 From: notifications@github.com To: SSRS_12132014@noreply.github.com Subject: Re: [SSRS_12132014] Top N Best Selling Products in USA (#2)

Also, both Erina and me have a question:

Please look at the same expression:

="Top " & CStr(Parameters!prmTopN.Value) & " Best Selling Products in Year " & CStr(Parameters!prmYear.Value(0))

What is that "(0)" behind "Parameters!prmYear.Value"? It was added automatically by the program. If you delete it, you will get an error.

¡ª Reply to this email directly or view it on GitHub.

liangzz commented 9 years ago

Thanks! But is there a way to include all the values of a multi value parameter?

txwhiterock commented 9 years ago 
     Join(Parameters!<MultivalueParameterName> .Value,", ")     gives you the function to show all the value

by comma-delimited list.

Date: Wed, 28 Jan 2015 09:23:10 -0800 From: notifications@github.com To: SSRS_12132014@noreply.github.com CC: chunyangliang@hotmail.com Subject: Re: [SSRS_12132014] Top N Best Selling Products in USA (#2)

Thanks! But is there a way to include all the values of a multi value parameter?

¡ª Reply to this email directly or view it on GitHub.

liangzz commented 9 years ago

Wonderful! thank you thank you thank you~~~

derekdai1978 commented 9 years ago

My Friends,

All good questions and answers. Good to see you guys start to use it. But, Yes I want to say something about "But"! Maybe I didn't explain this well. My point is, remember, this repository is for user stories(Business Requirements). IT people and Business planners are on view of this US. The comments above are focusing on how to resolve a very specific tech question. first of all, we should NOT there yet. Even we have been, this is NOT the right place to discuss. Besides, imagine any business people from sales/marketing dept. will be tiny interested in what we are talking about right now?! So far, we only need to ask whether I have understand the business requirements here. You dont need to think about how to implement it. Good start and a typical mistake IT people make. Hope my callout can help you understand further how to use the repository for business requirements/User stories.

liangzz commented 9 years ago

Got it! Now you have just taught us another good lesson.

derekdai1978 commented 9 years ago

Just opened another repository for IT people to discuss the tech questions/issues.

Raybenleo commented 9 years ago

To Business Partners,

Please specify the following point: 1) do users want the year information in each Top N record? Or on the top of each year group? 2) when users pass in multiple years, please specify whether the Top N is defined for each year or the multiple years as a whole group? Thanks,

Users can pass in year(s) to analyze the best selling products. The table should present the "Net Sold Quantity" and "Net Revenue". On each product name, it can be linking to another report to show product detail information.

jiaying425 commented 9 years ago

My group receive four issues- issue#2/ issue #3 and issue #5 / issue #6.

Based on my understanding, there are two independent topics- product /related report and stored/related report.

Can users advise what is your priority? Thanks

derekdai1978 commented 9 years ago

Hello Raybenleo,

See my comments below, Please specify the following point: 1) do users want the year information in each Top N record? Or on the top of each year group? Yes, we need the year information on top of the table.
2) when users pass in multiple years, please specify whether the Top N is defined for each year or the multiple years as a whole group? It is defined in a whole group.

derekdai1978 commented 9 years ago

To Jiaying425,

Yes, they are basically 2 topics. To me, we need to finish all these 4 issues for your group as you have 5 people in the group. They have the same priority for me. Trying to understand why you asked this question? Not enough resources?

jiaying425 commented 9 years ago

We are creating a report including the content of " Year" " Product Name", "Net Sold Quantity" and "Net revenue" Columns.

  1. Is there any other columns the users want to be covered in the report?
  2. We are proposing to include a row number column for the user ,which will help the user easily find the revenue ranking. will user accept it?
derekdai1978 commented 9 years ago

Erina,

1, if you can show me the profit%, it will be perfect. profit%=(sales amount-total cost)/total cost

2, Ranking number works for me

Thanks

GPWang commented 9 years ago

From my understanding, best selling != most profit Best selling item in Amazon should be the one sold the most quantities? Just my 2C

derekdai1978 commented 9 years ago

To GP,

What you say makes sense. But in term of this issue, let 's define the best selling as "sale amount"

liangzz commented 9 years ago

Team: Group 1

Estimation: 16 Points

Primary developers: May, Ming

Interface with other issues: Issue 3

Possible Solutions: This report will contain one table presenting bestselling products in specified years. By default, the table will show top 10 bestselling in the most recent year. The users will be able to select years and top number. The users will also be able to click on the name of each product and view detailed product information.

Code reviewer: Sherry

Tester: Kevin

jiaying425 commented 9 years ago

Group 2

Estimation: 15 Points

Primary developers: Erina Huang

Interface with other issues: Issue 3

Possible Solutions: The report will show the users "Year", " Product Name", "Net Sold Quantity" ,"Net revenue" and "profit" information with a default of the top 10 highest revenue record .

The users can key in the year or years to get the customized top 10 highest revenue and the numbers of record can be revised according to the user's needs.

When the users client click the product name, they can see the product detail report accordingly

Code reviewer: Hongling

Tester: Jane Shen