I have a large set of products (hundreds of thousands), each identified by two measures - let's call them profit per item and cost of production per item. I want to look for a relationship between the two, and suspect that the data set includes several groups with linear relationships, but I have no way to separate the groups.
I have an idea about how to make trends stand out, but I don't know how to make it happen in Tableau. I am sure there is a simple way.
The idea is to bin the two measures, then make a visualization with the horizontal being categories of one binned measure, and the vertical being categories of the other binned measure. then each cell of this matrix would be colored with the number of products (=rows) with qty 1 in the bin of quantity 1 for that cell, and quantity 2 in the bin for quantity 2 for that cell. (I think this type of viz is a kind of heat map but I'm not sure.) I could then play with the bin sizes to see if patterns emerge.
So the cell color would be Count of something, but I'm not sure what.
Any help would be appreciated. I am so close I can taste it!