topic Re: Set analysis with dimension min as input to set function in App Development

Set analysis with dimension min as input to set function

LinusNandin — Sun, 13 Feb 2022 07:42:21 GMT

Hello!

The expression is supposed to count the number of sessions for the 30 first days for each app, and add them together. The apps have different start dates.

I have the following expression:

sum(
aggr(
count(
{<[Session Start] = {"<=$(=Date(min([Session Start]) + 30))"}>}
[Session Count]
)
,[App name]
)
)

Currently the function min([Session Start]) returns the minimum date for all the "App names"

I need help to get the min([Session Start]) to return the minimum date corresponding to each app

Re: Set analysis with dimension min as input to set function

rubenmarin — Sun, 13 Feb 2022 17:01:47 GMT

Hello!

Set analysis is calculated before the table, not applied ro by row, neither inside of an aggr for each dimension.

Not efficient but maybe:

sum( aggr( count( If([Session Start]<=min(TOTAL <[App name> [Session Start])+30) ,[Session Count]) ) ,[App name],[Session Start] ) )

To be more efficient you can calculate this in script with the help of mapping table and resident loads.

Re: Set analysis with dimension min as input to set function

LinusNandin — Mon, 14 Feb 2022 07:26:36 GMT

Thanks for the replay.

Does not seem to work. I get 0.

I'm working on it in the load script too. I do not currently have access to the data connection, thats why i've tried it in chart expression

Re: Set analysis with dimension min as input to set function

rubenmarin — Mon, 14 Feb 2022 07:30:27 GMT

Hi, there was a typo:

min(TOTAL <[App name]> [Session Start])

If still doesn't works, can you upload a sample dummy data/app to make some tests?

Re: Set analysis with dimension min as input to set function

LinusNandin — Mon, 14 Feb 2022 19:04:47 GMT

Hi!

I did realize the typo and corrected it.

This is want.