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
What's your Date Waiting (days)?
can you provide a sample workbook? it seems there some other dimension in your details as well.
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.
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 .