Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
Would you be able to share a smaller sample?
Preparing examples for Upload - Reduction and Data Scrambling
Hi Sunny,
Kindly find the attachment.
Hi Sunny,
i selected more filter option. now it less than 5 Mb .. !
Hi All,
Can any one suggest me how to achieve this ?
Hi Sunny ,
Are you able to check the qvw ?
Boss it seems data modelling issue. pl look below
Hi Ashish,
I am Having only two table .. one having event level dimension and another is aggregated value for that visits..
So how resolve this ?
can you share the data?
with some info regarding wat you are doing?
Can you try this script at the end of the script:
Aggr:
LOAD VisitFull,
Visits
Resident Second;
Left Join (Aggr)
LOAD VisitFull,
Link_Date
Resident First;
Left Join (Aggr)
LOAD Link_Date,
Date
Resident [Master Calendar];
TempAggr:
LOAD DISTINCT VisitFull,
Date,
Visits
Resident Aggr;
FinalTableAggr:
LOAD VisitFull,
Date,
Sum(Visits) as TotalVisits
Resident TempAggr
Group By VisitFull, Date;
DROP Table Aggr, TempAggr;
And use TotalVisits in your chart