Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi to all qlicker's ,
i have NAMES and CITIES , I need to show comparatively numbers of visits of NAMES that visited in a CITY ,
with the others CITIES , for example , if we look at London we can see that Mira and Jecob visit there -> So its 2 ,
Now we check Mira and Jecob in Jerusalem and we see that they also visit there -> So its 2 ,
Now we check Mira and Jecob in New York and we see that only Mira visit there -> So its 1 ,
Now we check Mira and Jecob in Mumbai and we see that they also visit there -> So its 2 .
.. and so on ... ( Mira and Hana and Jecob visit Jerusalem )
I need to show in a table or chart or anything the wanted Solution :
i know its hard - but its fun , THANKS.
Create a cartesian product:
T1:
LOAD * INLINE [
NAME, CITY
Mira,London
Mira,Jerusalem
Mira,Mumbai
Mira,New York
Hana,Jerusalem
Hana,Mumbai
Jecov,London
Jecov,Jerusalem
Jecov,Mumbai
]
;
JOIN (T1)
LOAD NAME as NAME, CITY as CITY2 RESIDENT T1;
Then use CITY and CITY2 as dimensions in a pivot table and count(CITY) as expression
Create a straight table with CITY as dimension and these for expressions:
hi Gysbert, i understand , it is a nice solution for now , but i have many cities and i need something dynamic , is it possible ?
Create a cartesian product:
T1:
LOAD * INLINE [
NAME, CITY
Mira,London
Mira,Jerusalem
Mira,Mumbai
Mira,New York
Hana,Jerusalem
Hana,Mumbai
Jecov,London
Jecov,Jerusalem
Jecov,Mumbai
]
;
JOIN (T1)
LOAD NAME as NAME, CITY as CITY2 RESIDENT T1;
Then use CITY and CITY2 as dimensions in a pivot table and count(CITY) as expression
WOW , so simple and so smart - THANKS Gysbert !!