I want to show diff days in bars from start to End . Example below
I
I want to fill the orange color from starting to End data as showing in tooltip. Please help .
Regards
Shiv
-
1. Re: I want to show diff days in bars from start to End . Example below
Zhouyi Zhang
Feb 12, 2018 11:05 PM
HI, Shiv
try this
hope this helps
ZZ
-
2. Re: I want to show diff days in bars from start to End . Example below
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 Zhang
Feb 13, 2018 3:58 AM
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
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.
-
5. Re: I want to show diff days in bars from start to End . Example below
Zhouyi Zhang
Feb 13, 2018 4:48 AM
Hi, Shiv
thanks for your workbook, it really helps.
I have a question, in your view, you use date waiting, which is not aligning with treatment start date, I give one example below
Can you tell me why you didn't use treatment start date, but use date waiting instead?
ZZ
-
6. Re: I want to show diff days in bars from start to End . Example below
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 .
