I am not sure if my solution will suit you, however I would do that playing in with the Dashboard view. Please find attached file.
Whole idea relies on constructing the dashboard. You have 2 similar sheets - one with extended data and hidden Resolve date column, second with only ATTR for resolve date - colored and visible in last column.
Hope that helps.
Project reporting _answered.twbx 45.3 KB
From reviewing your workbook, the ideal scenario would be to have the Overall Status Name conditionally formatted like below. As your formatting is based on the Overall Status Name this would be more logical.
Your request to conditionally format the first column makes it slightly more tricky. As you already know, the measures and colour formatting is normally assigned to the right columns as this is normally subject to a measure value and we are unable to conditionally format a dimension like so without some sort of workaround.
We can however still achieve this by using calculated measures and multiple Marks altho this does have some limitations to the style and formatting of the worksheet.
This produces something like this shown below. I have attached it for your reference. I created a chart, with MDY Reporting Date in the rows, I then dropped Avg 1 on the columns twice and used the marks values to create a bar chart that we assign the colour formatting onto, and dropped the MDY(Reporting Date) in as text, fixing both axis and then dual axis these together gives you the conditionally formatted date. To added further columns we need to create measure columns and drop the necessary dimensions into the Marks card as text objects which you will see.
This limits the ability for headers as I have removed the Axis headers.
Feel free to break the workbook down and decipher what is best for you.
Project reporting example.twbx 63.2 KB
As far as I know you can color those headers dynamically. That's the reason you can see the separate part to the right.
I don't think there is any way to color code first column using single sheet. All what you can do is refer to the screenshot below.
I have added the Dates to the label section so we started getting dates there. Now you can see that we are able to get the whole background color-coded. If you put a dimension to the color (in this case Reporting date), you will get the separate color for each of the date but we need dates to be color coded as per the Overall status.
Can't attach the workbook since you are using the older version of tableau.
Thanks and Regards,
Reporting Date is not a real Date field.
Is it possible bring a real date field?
can we give the color based on date difference percentage
suppose i have project manger and their project each manger have 10 project and i have dates like planed end date and actual planed end date
i am calculating date difference between two dates. then i am getting some negative and positive values in date difference calculation.
then after that i need to changes these date difference to percentage like if the days difference is 15 or 45 or 100 or 300 or -100 or -50 or days like that at that time also the percentage should be 100%.
after that i need give the color for if percentage is less then 20% to less -20%(-20% to 20%) is green and >20% is blue and >-20% is Red.
How can i achieve this?