In addition to what @mahfooj khan has mentioned. You can create a calculated filed as below
"W" + STR (DATETRUNC('week', <Date column>))
1 of 1 people found this helpful
Thank you for that suggestion, however it does not work for me.
There are two date inputs:
1) Project timeline, on the top, comes from project gateways and I want to show week number with corresponding dates. Project timeline will change as per the selected programme's gateway dates.
2) Activity dates, at the bottom, comes from the activities that are part of Subprojects.
When I tried your suggestion, I ended with the below:
New columns are added to the dashboard. Am I doing something wrong here?
Please share sample data (not as image pls) to re-create the Viz. I think what you are targeting is easily achievable.
One issue could be the definition of the week which in this case would be the week of the year which is effected by the first day of the week. You can change this under Data > name of your data source > date properties.
Another thing to consider is to use a Gantt chart instead of dual axis dates.
You can do a datetrunc to get the first day of the week for the project.
DATETRUNC('week',yourdatehere) and then do a DATEDIFF to get how many days between the beginning of the week and the end. You can use this on the size shelf to scale your bars accordingly.
I have created some sample.
[Days at GW]
lookup(min([GW Start]),1)-min([GW Start])
or If you need detail and have enough space.
You can show Each start date with ref line,
GW_Gantt_SM_9.2.twbx 26.4 KB