Hello! I am trying to determine why my pivot table totals are blank for some of my calculated fields. My calculated fields are dependent on created_at date (aggregated by month in the table) and patient_id.
My calculated column is:
Churn MoM= ifelse({Enrolled Patients Last Month}-{Enrolled Patients}=1,1,0).
Thus, I would expect to see a total sum of all the values of “1” per patient_id, but it is blank.
When I export to Excel and create a PivotTable this works just fine but obviously that is not ideal!
I have tried using the following sumOver and runningsum functions to get totals to display on the pivot table but not having any luck with these as well:
ifelse({Churned MoM}=1,
runningSum
(
{Churned MoM},
[{created_at} ASC],
[{patient_id}]
),0)
runningSum({Churned Count}, [{created_at} ASC])
Thanks for the help!
Hi @shanna5
I think problem with Enrolled Patients Last Month … could you please share screen shot of the enrolled patients last month calculation expression and also the field well screenshot to see the datatype .
Thanks
VInod
Hi Vinod,
Here is the formula for Enrolled Patients Last Month:
and here are the field wells for the Pivot Table:
Thank you!
Hi @shanna5
Can you please also share calculation expression screenshot of Enrolled Patients field as well … wondering why aggregation for the Enrolled Patients is custom .
sure, had to retract most fields but it is a distinct_countIf formula based on fields from the time-series dataset
Hi @shanna5
Currently not possible to get the overall total for the calculations involving distinct with LAC/Period functions . Let me ping you separately to get more details to update product feature request .
Thanks
Vinod
Thank you, that would be a great feature to have!