Months in fields/columns in Table visuals

Hey David,

to me it seems you have to build a new table - I would call ProjectStatus, the columns would be

ProjectID (maybe it is Projectname) | Date | StatusID | StatusImageUrl

And it also seems to me that you should also use a separate Calendar Table

The Relationships then sould be

Project (one) to ProjectStatus (many)

Date (one) to ProjectStatus (many)

Status (one) to ProjectStatus (many)

I'm not sure but to me it seems that you are somewhat trapped in your current table ProjectTable.

This table seems to be  one table fits all questions approach.

It is always a good approach to separate tables in a star schema like approach, meaning build dimension tables and fact tables. A fact table holds data about measured objects (status about a project during a certain point of time), whereas dimension tables provide information about organisational objects you want to analyze (your project). Basically dimension tables have hold just one instance of these objects, with its describinng attribute. Whenever the value of one these attibutes changes its value and you have to track this change, then you have to think about a fact table (sales amount for a product changes over time, or the status of a project changes over time).

Currently I'm not able to deduct why the status column in the report you thankfully provided is called "May" and how the Status for June should be calculated.

Guess I'm missing a lot to provide a solution for your problem

Regards