Viewing 15 posts - 1 through 15 (of 16 total)
Hi,
I have done a lot of automation work where execs require various charts. I suggest you look at the final deliverable. In my case it was Power Point. The way...
July 11, 2003 at 4:20 am
Hi check, out recrystalise, its meant to be a much lower license cost. However lacks some of the easy to use features of Chrystal.
July 8, 2003 at 3:05 am
Anzios final solution was sligtly faster then Daves with my data, however Daves seems to perform better when there are more variables.
Both are very good, and I would appreciate some...
May 16, 2003 at 8:07 am
Problem solved
--------------
Hi Just wanted to thank Dave Barrows on solving this one!! I tested his solution with 15 variables (A-O) and with 300 responses the solution time took approx 20min....
May 9, 2003 at 8:25 am
Hi,
This does not work either.
A quick way to test it is to simply do something like
Select count(distinct resp)
From tblrespondent
Where Prod='A' or Prod='B'
change the where clause to the combincation you wish...
May 9, 2003 at 5:20 am
Can yot elaborate on this approach, using an OLAP tool might be an option for this job
Regards
quote:
This sounds more and more like...
May 8, 2003 at 3:09 am
Th ouput for this Would be as follows:
A 1
B 1
C 1
AB 2
AC 1
BC 2
ABC 2
Answer the rest shortly
May 8, 2003 at 3:03 am
Hi,
May be I did not make my self clear,
each respondent will only respond to a unique attribute.
Therefore respondent 1 can only say yes to product A once.
Therefore you could look...
May 7, 2003 at 10:25 am
Hi David,
I posted a quick response to your previous solution where we could use Distict counts of respondents, recall if a respondent responds more than once to a combination we...
May 7, 2003 at 9:12 am
Hey, not quite there yet, but not bad.
If you have only 6 respondents you cant have a base size of more then 6. In your case you are getting 14...
Basicly...
May 7, 2003 at 8:31 am
Yes, I think thats right for one respondent. I am saying
1 A Yes
1 B Yes
1 C Yes
Might produce 1 A or 1B or 1 C if 1 respondent has answered...
May 7, 2003 at 7:49 am
Hi,
Clearly your solution does not work!!
Again as I pointed out earlier if ABC has 2 then ABCD should have more then 2 not 0
Regards
May 7, 2003 at 7:20 am
Hi,
A unique identifier is not a problem, I left it out to keep things simple.
Also ABC would be 4 or more cause AC is already 4 (remmember the relationship is...
May 7, 2003 at 5:34 am
quote:
Since you are ignoring NULLS then this I think is what you are looking for is something like this.
May 7, 2003 at 5:23 am
Just a note about the data format. I am open to the format I thought the following was best:
RespIdProdValue
1AYes
1BNo
1CYes
2AYes
2BYes
3CNo
etc..
Basicly storing multiple records for each respondent. The other option would be
Resp...
May 7, 2003 at 3:58 am
Viewing 15 posts - 1 through 15 (of 16 total)