tag:blogger.com,1999:blog-3721871707048712457.post6738003011605646998..comments2024-03-28T00:39:48.395-04:00Comments on Breaking BI: Level of Detail Calculations in Tableau Part 6: Nested LoDsBreaking BIhttp://www.blogger.com/profile/02551920506874509998noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3721871707048712457.post-77699146534655450812017-02-07T19:04:32.385-05:002017-02-07T19:04:32.385-05:00Hi Brad,
Can you throw more light on the part
Wh...Hi Brad,<br /><br />Can you throw more light on the part<br /> What is we wanted to know the average number of Unprofitable Orders per Customer, for each Segment?<br />The calculations after that or the context of it. Could you walk me through. <br />ThanksAnonymoushttps://www.blogger.com/profile/07179766683426861836noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-88488302368683788782016-01-11T22:59:39.640-05:002016-01-11T22:59:39.640-05:00Brad, thank you!
In PowerPivot we can have
1. ...Brad, thank you!<br /><br />In PowerPivot we can have<br />1. 'Product' table (rows)<br />2. Disconnected 'Filter Product' Table (columns)<br />3. Measure like <br />=CALCULATE (<br /> DISTINCTCOUNT ( Sales[CustomerKey] );<br /> CALCULATETABLE (<br /> SUMMARIZE ( Sales; Sales[CustomerKey] );<br /> ALL ( Product );<br /> USERELATIONSHIP ( Sales[ProductCode]; 'Filter Product'[Filter ProductCode] )<br /> )<br />)<br />and get something like matrix for basket analysis<br /><br />with all these new LOD and other things<br />how can it be done in Tableau?<br />what is best practice?<br />How would you do it conceptually?<br /><br />thank you very much!<br /><br />Anonymoushttps://www.blogger.com/profile/14915923505805048361noreply@blogger.com