Find my approach based in datediff below and stored in attached workbook version 9.3
Days 0-99: if datediff('day',[Date],today()+47)<100 then [Number of Records] END
Datefunction DATEDIFF.twbx 15.3 KB
Thank you so much for replying! I have added some extra context here.
I have added a screenshot here of the type of data that I have and what I am trying to achieve.
Correct visualization of a range and various values above.
Above is the day range for which I have certain measures/values. So 77-273 means day 77 till day 273.
I created a split, but that doesn't seem to work when trying to plot the various values on the axis with a range of days.
I would like to have a smooth range here and visualize a connecting line from the beginning point to the end point instead of these separate bars.
This is what I get, it makes no sense
Any other ideas for:
-Getting the date ranges (intervals) correct? Should I do something with grouping, changing the date format (although I have already tried every option there was) Is something wrong with dimensions/measures?
-Visualizing the values in the ranges
Thanks for prompt reply. Are you able to share your workbook?
I have attached it here.
Have the day intervals. Some overlap I believe I am doing something wrong here.
I would like to plot the values on the axis like a continuous range, so example from 90 to 400.
Workbook Day Ranges v1.twbx 88.2 KB
Nogmaals goedenavond Sylvia,
Find my updated approach as reference below and stored in attached workbook version 10.1
Not sure but I think you would like to "group" e.g. Days Fibrosis
1 of 1 people found this helpful
First of all thank you for all the effort! Appreciate it!
We're getting somewhere.
I try to display the day range as a line or bar, for example: Begin day 252 and end day 364. So you will see on straigth line from begin to end day, for example for the dosis of 13.00 here and Stain CBA/Ht.
And on the X-axis the chronological display of days.
I found some examples on the internet:
Mouse with dosis 16,00 and dose rate 4.13 had complications starting from day 95 (pneumonitis).
That same mouse had worse complications (fibrosis) starting on day 364.
I would like to visualize when these 2 complications start to occur, in what date range. Compared to the dosis they had (on Y- axis).
Couple of questions:
-Should I manipulate the data to be able to visualize this correctly, if so, how?
-What is the right setting for visualizing these date ranges (Date Type/Measure/Continuous) ?
Ideally I would like to have time (in days) on the X-axis and the range of days in Pneumonitis and Days of Fibrosis visualized in different colours on the canvas like a bar or line or something else.
On the Y-axis the applied 'Dosis'.
Something like this (Gantt chart):
-Do I have to make use of calculations? If so, what should I try? (Datediff did not work for me here )
-Any good suggestions for visualizing this in general?
I've just added a new update of the workbook.
Thank you so much for your time!
3 of 3 people found this helpful
To get a Gantt chart, split Days Fibrosis into Start and End Days. Calculate Duration (days) and create a dual axis Gantt chart. You need to place Duration on size. You can create an additional Ranking field and put it in the appropriate place depending on your sorting preferences. I have done this for Fibrosis. If this is what you want, then you can replicate it for Pneumonitis.
See attached modified workbook in Tableau 10.
I wanted to thank you for your contribution and efforts!
It really helped me to continue my analysis. Will keep you posted on the end results
Thank you so much!
It's always NICE:) when "a plan comes together"......