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.
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.
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.
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
Rank in axis _Solution.twbx 1.2 MB
Thank you So much .. Yes I missed the table calculation somewhere.
Thanks for your tme and help