CODEWITHSUNDEEP
tableau-apidata-analysis
raushu
raushu

Reputation: 81

How can I sum the variable those has the some value on tableau?

I have a dataset like below: Please click this link

and I already make a graphic like this:

Please click this link

In the dataset, every different orderID means a different order. In my graphic, the x-axis is userID, the y-axis is how many order the user created and I noticed many users have some order amount. so I want to make a new graphic, the graphic's x-axis is order amount and the y-axis is user amount, the user's order amount is equal to x-axis.eg. There are 7 users created 21 orders, so the new graphic should have a point(21,7) How can I reach my gold on the tableau

Upvotes: 0

Views: 74

Answers (1)

Parul Bansal
Parul Bansal

Reputation: 42

Use LOD expression, fixed your user ID and Sum (Amount of dIstinct OrderID)

Upvotes: 1

Related Questions