This content has been marked as final.
Show 2 replies
-
1. Re: Calculate average with Null values calculated as Zero including a Hierarchy
Zhouyi ZhangJan 9, 2019 5:12 AM (in response to to.van)
Hi, Van
To achieve your requirement, you need some sort of data reshape by adding a table which has all the week values.
Below is the steps I did to reshape your data and create the calculation field as well as the result of removing the person and team from the view.
I also attached the workbook for your reference.
Hope this helps
ZZ
-
test (20)_v10.2.twbx 16.3 KB
-
-
2. Re: Calculate average with Null values calculated as Zero including a Hierarchy
to.van Jan 11, 2019 2:26 AM (in response to Zhouyi Zhang)Hi ZZ
Thanks a lot, I like your approach to reshaping the data with a clever join!
Tobias