6 Replies Latest reply on Aug 31, 2016 12:04 AM by keerthana kumar

# Rank Value as axis for a trend Graph

Hi All,

Im Using Tableau 9.2

My Scenario is below

For Each Product show what is the sales when it happened 1st time 2nd time 3rd time so on...

I have to plot a Line graph

X Axis - Sales Record ...1,2,3(1st time purchase 2nd time purchase)...till what user wants to see end of axis chosen by user

Y Axix -Sales Value

Product Name in Colours

Filters :State,Category,Date

I have the data grid here, now i have no clue how to bring the number of purchase (Shown A Sales record)as axis in graph

For Product "1.7 Cubic Foot Compact "Cube..." sales has happened 6 times till date

"1/4 Fold Part Design invitation .." sales has happened 2 times

Expected Output a Graph like below for "1.7 Cubic Foot Compact "Cube..."

In the same graph i have to show "1/4 Fold Part Design invitation .." product sales line trend if chosen by user

• ###### 1. Re: Rank Value as axis for a trend Graph

Hi keerthana,

Please attach the workbook for better understanding.
I would like to understand, what is the calculation that you have put under "Sales Record".

And, you can refer to the workbook attach if it aligns with your query.

It has got the Sum(Sales) in Y axis
and, Purchase order-Ids in sequence of order been placed in X-axis.

Please let me know if it helps.

Kajal

• ###### 2. Re: Rank Value as axis for a trend Graph

Thanks Kajal,

I have attached my sample dashboard in the original post. Sales Record was just and index function for me to see the number of times the prouct was purchased.

As I am using Tableau 9.2 Im unable to open your dashboard.

Is there any possibility for you to share in 9.2

Thanks a ton for giving a try on my scenario.

• ###### 3. Re: Rank Value as axis for a trend Graph

Hi,

i have converted the file into 9.2 version.

Please let me know if it helps.

Kajal

• ###### 4. Re: Rank Value as axis for a trend Graph

Hi Kajal,

May be my requirement is not clear .. Im looking out for a graph like below(I have made a dummy data)

I Want to plot No of Purchase(1,2,3....) and sales

Where No of Sales  is just continuous numbers 1...n . So i, trying to achieve this No of Purchase using index function

But no idea how to plot in a graph.

End Result is to see product "1.7 cube..." when 1st purchased  sale was 208\$ while "1/4 Fold.." Product when First Purchased made 6\$ only.

• ###### 5. Re: Rank Value as axis for a trend Graph

It is Simply achievable by using same pills that you have used, your are alomost near to solution , Its only change of pill location and advance compute using option change

Please refer the below attached workbook for the solution , I would recommend to use 9.3 version to open the solution.

Hope this helped you

Regards

Srinath. Panjala

• ###### 6. Re: Rank Value as axis for a trend Graph

Thank you So much .. Yes I missed the table calculation somewhere.

Thanks for your tme and help