I need to create a Calculated Field for Average projects Completed per Month. Using Projects Complete Measure and No of Completed months for the Calendar year.
Calculated field: Projects Complete / No of Completed Months in the year Ex : 12 Months per year ( Completed Months: 11) ( 112/ 11 ) = 10.18
please find the attached workbook Version 2019.2
To determine month is completed or not TODAY function will help.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...