Page 1 sur 1
Cross tabs and dates
Posté : mer. oct. 03, 2007 2:03 pm
par Frenchie
Is there a way to do cross tabulations between dates and other variables?
Thanks.
Posté : mer. oct. 10, 2007 9:17 am
par Guillaume
Yes, it's possible.
In graphic table, click on the menu "Analyses" and "Cross table".
And then, select variables.
On this display, you can cross dates with other types of variables.
best regards
Posté : mer. oct. 10, 2007 4:26 pm
par Frenchie
Thanks Guillaume!
However, when I do this, Sphinx automatically groups my dates into months. Not that I mind, but there are times when cross tabs with exact dates may be required.
Thank you for your advice.
Posté : jeu. oct. 18, 2007 2:09 pm
par Guillaume
On your graphic table,
- right clic on your cross table, and click on "Modify format" menu,
- Your are in cross table properties,
- Click on the tab "Calculate",
- Choose "Date Variables" in the roll menu,
- A new roll menu appear, use it to change the presentation of your date variables.
best regards