pcolson
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Un-weighting an average value
Hello all, I have what I hope is a simple question. We have a database that can be boiled down to the image below. Each entry has a date (YYYYMM) and whatever the monthly member count is for that entry (Members). We want an average member count of Q4 (202110, 202111, and 202112), but the only way I can get Sisense to calculate that is: 100 + 100 + 100 + 100 + 200 + 300 / 6 = 150. However, there are duplicate member counts/YYYYMMs here. I want it to do it by distinct YYYYMM, like this: 100 + 200 + 300 / 3= 200. Different months can have identical member counts. Does anyone have any ideas?Solved3.4KViews0likes5Comments