Scatter chart

[Anonymous]

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,

[vgutkovsky · Accepted solution]

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

[Anonymous]

Thanks Vlad.

[nilo_pontes]

Hi Vladimir,

Please take a look on the attached file.

I made some changes on your datamodel using crosstables.

Hope it helps you.

Regards