Error in Nested Aggregation

Q&A
,
1

I want to do add a claculted field, that can add the values that lies in the week. I am doing it as follows:
periodToDateSum({DailyLoginStatus}, {AdjustedDates}, WEEK, truncDate('DD', now()))

Getting the following error:
Nesting of aggregate functions like {{aggregateFunction1}} and {{aggregateFunction2}} is not allowed.

The DailyLoginStatus is also a calculated Field as follows:
ifelse(in(distinct_count({store_id}),[distinct_count({Active-Store_id})]), 1, 0)

If the nested aggregation is not possible, can somebody please suggest what can be done here to achieve the purpose?
store_id is the list of stores logged in on a particular date. There can be repeated store_id for a particular date.
Active-Store_id is the calculated field, which is calculated as follows:
ifelse(

Login_id=‘’,NULL,店舗id

type or paste code here

)

2

Hi @priyagoel,
While I’m not completely sure how the ifelse statement in your ‘DailyLoginStatus’ is working, I put together some notes on an alternate way to try this out in an Arena view that’s attached below:

Error in Nested Aggregation

If this does not help with a solution for your case, could you include some additional information on what the ‘adjustedDates’ formula looks like?

3

Hi @priyagoel,
It’s been awhile since we last heard from you so checking in to see if you had any additional questions?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @priyagoel,
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 post in the community and link this discussion for relevant information if needed.

Thank you!