Display multiple dates in combo chart

[#1]

Activity	Begin	End	Date	Patient ID
00002	11-1-2011	4-10-2011	24-1-2011	1
00002	11-1-2011	4-10-2011	7-6-2011	1
00002	11-1-2011	4-10-2011	12-9-2011	1
00002	11-1-2011	4-10-2011	19-9-2011	1

Hi,

here is a little part of my data. The data is about patients. I would like to use a combochart and visualise each date with a symbol.  Because i use  patient ID as  a  dimension, the only thing i can come up with is display the first and last  date. EG.

MinString ({$<Activity= {00002}> } Date -Begin).  What  function can  I use to display all dates?

Thanx in advance.

Maartje

[CELAMBARASAN]

Hi,

     Try using Concat function

     Concat({$<Activity= {00002}> } Date -Begin,',')

Hope it helps

Celambarasan

[#3]

Thanx for this quick answer! I think the function is very helpful. However, how do I get these 4 numbers (13,147,244,251) as symbols in my chart? Any idea?

[CELAMBARASAN]

Hi,

     I think its not possible?What is your dimension and can you tel me detail about your problem?

Celambarasan

[sridhar240784]

Hi,

Hope i understood your question.

Check the attached application.

Your expression should be something like below.

=Dual(Concat(Aggr(sum(Date - Begin),Activity,Begin,End,Date),','),SUM(Date - Begin))

Hope this gives you an idea.

-Sridhar

[#6]

Thanx for your help. Actually I would like to see for each date a different symbol. So in this axample for patient 1 4 dots (one after 13 days, one after 147 days, one after 244 and 251 days). And in your example also 4 symbols (dots) for patient 2.

Do you think this is possible?

Thanx in advance

[#7]

Actually i'm looking for a function like only(). Because there is an aggregation (dimension) on patient level, I need a function. However I would like to see all these 4 dates. What I can do is show the first-last, average but not just all 4 dates.

Anyone any idea?