tag:blogger.com,1999:blog-3178813192704651028.post5229581249507550604..comments2020-09-29T08:59:29.733-04:00Comments on The Flerlage Twins: Analytics, Data Visualization, and Tableau: Small Multiples: Just a Matter of Long DivisionKen Flerlagehttp://www.blogger.com/profile/03698843288892226027noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3178813192704651028.post-63057324293530242042019-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