4 Replies Latest reply on Jul 20, 2017 8:34 AM by Arjan Hada

# Scatterplot, binning and calculations

I am trying to show the difference between movies based on novels and not based on novels (Dimension- Based On Novel) on two criteria Profit and Ratings. I made a [scatterplot](https://public.tableau.com/profile/arjan.hada#!/vizhome/movies_novel_notnovel/Scatterplot?publish=yes). However, it is really hard to see the difference. If you have a better idea for showing the difference please help.

I came up with the idea to compute following metrics in Tableau,

(# movies based on novel with ratings > 5.944 and Profit >= 1000M)/(Total # of movies based on novel)
(# movies not based on novel with ratings > 5.944 and Profit >= 1000M)/(Total # of movies not based on novel)

(# movies based on novel with ratings > 5.944 and Profit >= 500M)/(Total # of movies based on novel)
(# movies not based on novel with ratings > 5.944 and Profit >= 500M)/(Total # of movies not based on novel)

(# movies based on novel with ratings > 5.944 and Profit >= 250M)/(Total # of movies based on novel)
(# movies not based on novel with ratings > 5.944 and Profit >= 250M)/(Total # of movies not based on novel)

(# movies based on novel with ratings > 5.944 and Profit >= 0)/(Total # of movies based on novel)
(# movies not based on novel with ratings > 5.944 and Profit >= 0)/(Total # of movies not based on novel)

I can calculate the metrics in Python, but not sure how to do it in Tableau and plot it. Can you please help me?

• ###### 1. Re: Scatterplot, binning and calculations

Indeed.

Would you be able to expand the viz to the right as well?

You should try different shapes, maybe a little bit smaller as well.

We'll work on that matter together step by step

----------

Lénaïc RIÉDINGER, Global Community Engineer Tableau

If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!

• ###### 2. Re: Scatterplot, binning and calculations

Thanks Leniac for responding. I made the requested changes. How do we move forward now?- https://public.tableau.com/profile/arjan.hada#!/vizhome/movies_novel_notnovel/Scatterplot?publish=yes

• ###### 3. Re: Scatterplot, binning and calculations

I think that is pretty understandable now, what would you like to add in there?

I can easily tell the different between based on novels or not now

• ###### 4. Re: Scatterplot, binning and calculations

Is there anyway to calculate the following metrics and plot it in Tableau?

(# movies based on novel with ratings > 5.944 and Profit >= 1000M)/(Total # of movies based on novel)

(# movies not based on novel with ratings > 5.944 and Profit >= 1000M)/(Total # of movies not based on novel)