-
2. Re: I want to show diff days in bars from start to End . Example below
Shiv PANDIT Feb 13, 2018 1:48 AM (in response to Zhouyi Zhang)Hello ZZ,
Still i am getting like lines in some cases.
If patients come four times in a month then it is showing four times like below lines but i want to show it in countinuous mode from first day to last date
order date is here date_Waiging
datediff('day',startdate,enddate)- it will show differences of both date.
I want to show like yellow color like above.. how is it possible
-
3. Re: I want to show diff days in bars from start to End . Example below
Zhouyi ZhangFeb 13, 2018 3:58 AM (in response to Shiv PANDIT)
Hi, Shiv
What's your Date Waiting (days)?
can you provide a sample workbook? it seems there some other dimension in your details as well.
ZZ
-
4. Re: I want to show diff days in bars from start to End . Example below
Shiv PANDIT Feb 13, 2018 4:15 AM (in response to Zhouyi Zhang)Hi ZZ,
I have attached the TWBX file please see . I want to show if treatment is going on till end of the treatement date then it should be continuous in bars. see first row. in attachment.
thanks.
-
6. Re: I want to show diff days in bars from start to End . Example below
Shiv PANDIT Feb 13, 2018 8:14 AM (in response to Zhouyi Zhang)date waiting is just like order date and treatment start date and treatment end is patients treatments period so I have to show treatment duration days within date waiting. I have to calculate duration days from treatment start date and treatment end date .