tag:blogger.com,1999:blog-3899813451295027721.post8400626306042556450..comments2019-07-19T07:42:04.562-04:00Comments on Kevin Flerlage - Data Visualization: Small Multiples: Just a Matter of Long DivisionKevin Flerlagehttp://www.blogger.com/profile/12367500962793593350noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3899813451295027721.post-5468507161361266082019-01-19T06:25:13.079-05:002019-01-19T06:25:13.079-05:00Very interesting and helpful post. Just to highlig...Very interesting and helpful post. Just to highlight the mathematical beauty of this process, I would just point out that the Y coordinate could also be defined as the quotient (or its integer part, more precisely) of the division of INDEX()-1 by the number of columns (the number of panels in each row). <br /><br />That is, once you have chosen the number of columns, when you divide each INDEX()-1 by that number, the quotient of this division will give you the Y coordinate and its reminder will give you the X coordinate.<br /><br />In yet other words, when INDEX()-1 is the dividend and the number of columns is the divisor, the quotient becomes the Y coordinate, and the reminder becomes the X coordinate.<br /><br />Also, I am not a Tableau user, but I looked it up and it seems that Tableau has a function to return the quotient, or the integer part of a division ("integer division"): the "DIV" function. So Y could also be calculated with the expression DIV(INDEX()-1, Number_Of_Columns).<br /><br />Great post.tiagombphttps://www.blogger.com/profile/11163232788950291200noreply@blogger.com