Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try using Concat function
Concat({$<Activity= {00002}> } Date -Begin,',')
Hope it helps
Celambarasan
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?
Hi,
I think its not possible?What is your dimension and can you tel me detail about your problem?
Celambarasan
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
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
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?