Hi there,
I am trying to use a custom field with sumOver() formula in aggregation for pie chart, but the aggregation is incorrect.
custom_total formula
sumOver(total,[{event_date},{channel_id},{rule_name},{shared_with}],PRE_AGG)
It shows the correct number in the pivot table, but not in the pie chart when using the sum of {sumover} field.
not sure what and how QS came up with these numbers. Any suggestion on how I can solve the problem?