I have a few calculated fields created in my dashboard, monthly Cost per Unit(CPU) = coalesce(sum(totalcost)/sum(quantity), 0) baseline Cost per unit(CPU) (Trailing 12 month average cost per unit) = windowSum(sum(totalcost),[{month_period} ASC],12,0, [{item_id])/windowSum(sum(quantity),[{month_per…

See if this helps [image] Nesting aggregation for ifelse Question & Answer Hi, I have a calculated field: If the ${customerVSrev} paramater = ‘No. of Customer_’, then get the count of customer_. if ${customerVSrev} paramater=‘Revenue’ then get the sum of revenue. ifelse…

Hi @yuchen1 , It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post? If we do not hear back within the next 3 business days, I’ll close out this topic. Thank you!

Hi @yuchen1 , Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information if needed.

Nesting of aggregate functions...is not allowed

Q&A

Giridhar.Prabhu November 20, 2024, 11:40am 2

See if this helps

Topic		Replies	Views
Nesting Not Allowed - Error Q&A quick-sight , calculations , Business-Intelligence-Engineer	2	86	August 30, 2024
Nesting aggregation for ifelse Q&A analysis , parameters , error , quick-sight , calculations , Business-Intelligence-Engineer	8	309	February 14, 2024
Nesting of aggregate functions is not allowed Q&A error , quick-sight , calculations	3	1667	May 8, 2023
Countif Nesting Aggregate function Q&A quick-sight , calculations	8	1353	August 8, 2024
Getting error as Nesting of aggregate function is not allowed Q&A quick-sight , calculations	2	3946	March 1, 2023

Nesting of aggregate functions...is not allowed

Related topics