Hello!
I am trying to enter a temporary array into a variable, from which I then want to output to the pivot table only those values that meet the condition "more than 30 percent" (the expression will be changed)
I tried to immediately display only the default values in the pivot table, but no formula works. So now I'm trying it through aggr.
How can I get not one number, but an array of data? Just as if I was writing an sql query with count(... group by...). I try the following formula, but it always gives me one number, not an array. And at the same time, this number is incorrect, if we talk about what I count inside the brackets. I need grouping by partner_name field.
=count(Aggr(count({<signup_time= {">=$(vDateFrom)<=$(vtodayDate)"}>} distinct user_id), partner_name, user_id))
Thanks for any tips on how I can implement this! The format of counting this array in the script does not suit me.
Expected result of the data array:
partner_name |
count |
partner1 |
320 |
partner2 |
120 |