Tableau - Do it Yourself Tutorial - LOD Calculations - DIY -27-of-50 скачать в хорошем качестве

Tableau - Do it Yourself Tutorial - LOD Calculations - DIY -27-of-50

Tableau - Do it Yourself(DIY) Tutorial - LOD Calculations - DIY -27-of-50 by Bharati DW Consultancy cell: +1-562-646-6746 - Cell & Whatsapp email: info@bharaticonsultancy.in bharati.dwconsultancy@gmail.com website: http://bharaticonsultancy.in/ Tableau - Do it Yourself(DIY) Tutorial - Level of Detail - LoD Calculations - DIY -27-of-50 In this video, we will see how to work with Level of Detail - LoD Calculations in Tableau 1- Reuse the TWB file, created in video DIY-26 using Claims Subset.csv - BDCS Claims Subset.TWB 2- You must have download the "Claims Subset.csv", if not send an email to bharati.dwconsultancy@gmail.com. 3- Create a new Sheet, DIY - Vid -27 4- Drag and drop the Country field on the Columns shelf. 5- Drag and drop the Claim Amount field on the Rows shelf. 6- Select the type of measure aggregation as Average. Does this look right? 7- To create a correct calculation, use the LOD calculations ({INCLUDE [Claim Id]: SUM([Claim Amt])}) 8- To create a calculation, use the LOD calculations ({FIXED[Claim Id]: SUM([Claim Amt])}) 9- To create a calculation, use the LOD calculations ({EXCLUDE[Claim Id]: SUM([Claim Amt])}) 10- Let's do the following hands-on exercise. Hands on - DIY #43 1- Create a new Tableau sheet. 2- Drag and drop the Country field on the Columns shelf. 3- Drag and drop the Paid Amount fields on the Rows shelf. 4- Select the type of measure aggregation as Average. Does this look right? 5- To create a correct calculation, use the LOD calculations ({INCLUDE [Claim Id]: SUM([Paid Amt])}) 6- To create a calculation, use the LOD calculations ({FIXED [Claim Id]: SUM([Paid Amt])}) 7- To create a calculation, use the LOD calculations ({EXCLUDE [Claim Id]: SUM([Paid Amt])})