How to Write Aggr Function script in Script Editor

[brijeshvma]

Hi All i have a two table in one i have all the dimension and second table have a Aggregated value for the same ..

and both are connected with common field.. But when i do sum(visits) i get wrong output ..

and if i am writing a sum(Aggr(Visits,VisitFull,Date)) Expre. i am getting a correct value .. But because of aggr function it slow down the

application .. so is there any way i can join this table and directly write this expression on script editor .. so on expression by directly

writing sum(visits) it gives proper value .. I am attaching qvd and qvw file .. kinldy check and help me how to achive this....

[brijeshvma]

Hi Sunny thanks for ur reply,

But can u tell me  if i do this with more dimension that i have

Aggr:

LOAD VisitFull,

    Visits

Resident Second;

Left Join (Aggr)

LOAD VisitFull,

     Channel,

     Action ,

     Category,

  Link_Date

Resident First;

So say example in second table i have Value 1 for Visitfull

VisitFull     Visits    Channel   Action    Category

101/10001      1          FB            Click      On-Page

101/10001       1         FB             Impression  On-page

so session count for 101/10001 is 2 ..sum(Visits)... but it should come 1

[sunny_talwar]

Why would you want to do it with more dimensions? Just use those dimensions which are needed, extra dimensions are going to throw your results of.

[brijeshvma]

Hi Sunny but i want those channel as a Filter and chart like dimension as channel and Measures will be sum(Visits)

[sunny_talwar]

I have done a binary load and it seems the results are not exact, but are close. I will continue to troubleshoot. But have a look