Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyoneI want to be able to count the number of a company for the date, company, workshop and categoryHere is the expression I tried to display sum ( aggr(count(distinct MatriculeRegie),%KEY_DATES,[SOCIETE],[ATELIER],[CATEGORIE]))The problem is that after the erexion my application ram so I want to rewrite this same expression in set analysis but I do not thank thank you for helping me
Aggr used like Group By in SQL. So that, You can not do as i aware and what you written is good approach. May be explain little more related about RAM consumption ?? And how many used for %KEY_DATES
If you want to nested aggregate functions i.e. Sum of DISTINCT COUNT then AGGR is the best choice.
Apologies for not considering this in earlier response.
Regards!
Rahul Pawar
I can send you my application with qvd for you to try to see
I don't think workfile needed to test. May be use simple
Count(DISTINCT MatriculeRegie) // Take one snapshot for Task manager where you are looking?
And then use, Aggr(...) then again take snap shot for that. We can notice where we troubleshoot.
Here is the slowness when I use the expression(sum ( aggr(count(distinct MatriculeRegie),%KEY_DATES,[SOCIETE],)[ATELIER],[CATEGORIE]))
Right side not correct because you are just doing degrade some fields from expression. Your requirement is simple whether sum(aggr(...Set....),..,..)) in set analysis. My answer is no, What you written is correct approach only. please share images regards this part
camille kouaho wrote:
The problem is that after the execution my application ram so I want to rewrite this same expression in set analysis
Does this ram / RAM in your OS?
Ok i understood but it is when i added this table using the aggr that the application started to row ... so in conclusion what to do.