Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have 4 sites, where were asked for each site Rating and Usage.
In database looks like Site1 Usage, site2 Usage, and so on
and the the same Site1 Rating, Site2 Rating and ...
I want to make a scatter chart depended on MYear and other variables.
I did it like a snap shot. Could you help me with ideas?
I think I need to crosstab load, but how?
Please see my sample file.
Thanks,
Vladimir, take a look at the attached. I created a new table called SiteData for you, which I think is what you're looking for. You can delete all instances of the word "ADD" which I just needed to perform a partial reload (since I didn't have your original data source). That's the general idea, although you can probably do it in less steps since you would be starting with the original data source instead of a partial reload.
Regards,
Vlad
Vladimir, take a look at the attached. I created a new table called SiteData for you, which I think is what you're looking for. You can delete all instances of the word "ADD" which I just needed to perform a partial reload (since I didn't have your original data source). That's the general idea, although you can probably do it in less steps since you would be starting with the original data source instead of a partial reload.
Regards,
Vlad
Thanks Vlad.
Hi Vladimir,
Please take a look on the attached file.
I made some changes on your datamodel using crosstables.
Hope it helps you.
Regards