Pl follow this thread. kettan has beautifully explained this.
Also, you may get your answers in this collection, again courtesy by kettan
Hi Lalitha Pragada,
A helpful way to get answers when using the forum for problems involving sensitive data is to Anonymize your Tableau Package Data for Sharing.
In this case, it would help to have an extract of your data to know your field names and their respective values to make it easier to give you a solution.
Depending on the structure of your data, there are multiple solutions to go about this. If your data is structured as;
Task Start Date End date
Task Date Start/End Value
each structure will have a different type of solution.
If you could either attach a workbook or summarize your data structure in this case, I would be able to help you out!
I have gone over this post earlier but i could not find a way to show my Task number - Field on multiple date cells ( Start-End date range) on my calendar.
I would appreciate if that can be helped with.
Please attach some mockup data.
Any update on this one?
Personally I wouldn't know where to start without a packaged workbook, this is a much more complex problem than I initially thought as there appears to be a lot of moving parts from the image you provided. Your viz is interesting, as it replicates that format of a calendar, however I'm not sure how formulas will interact with the multiple entries that appear.
The trick is even if i manage to share my workbook, with my data source being SQL server, i am not sure if you can really view anything.
You can create an extract and package the notebook with it as the data source, allowing me to access it. If your data is sensitive, please refer to the above link on anonymizing your data.
Thanks for attaching the data Lalitha, just to be clear on your required here -
Task 124 has a start date of 8/7, and an end date of 8/10. Currently it only appears on Monday the 7th, but it should appear on the 7th, 8th, 9th and 10th.
Also, how are tasks without an end date handled? Do they just appear on the start date only?
Yes, that's exactly what i need Marc
For the tasks with no end, they can only show up once on the start date. That's right.
Just adding another curious point, if the task has no start/end date, it stays in a Null bucket and will all be grouped in that. Can only do so much right?
My idea was to do as follows - calculate the number of days the task is expected to be outstanding, sticking with my previous example for task 124 it would be 3. Next I would compare the difference between each date and the expected start date. Based on the value between each date and the expected start date, the calculation would then output the short description and task number.
In this case, the output would be the following
The comparison expression would print out the description and task number of days with a difference =< the expected dates outstanding and => 0. In this case, 8/6 is less than 0, and would not have the task displayed (the same goes for 8/5, 8/4, 8/3 etc...) and 8/10 would be greater than the expected dates outstanding (4 > 3) and would not have the task displayed (same goes for 8/11, 8/12, 8/13 etc...)
However, I ran into the issue of not having all dates accessible. The calendar view is created off of expected start and expected end date. In the case of task 124 in the data attached, there are no references on 8/9, which means I would have nothing to compare the date difference and output the result.
I might be going about this wrong but for the time being I'm stumped.