Calculated metric on time dimension to spit out time dimension without changing date type[ Edited ]
March 2017 - last edited March 2017
I would like to add business weeks to my line graphs as opposed to ISO week number/dates. One way I have hypothesised is to perform a calculated metric on my date dimension (counted as time dimension). However, the problem is that this new calculated metric cannot be used on the line graph as it is not a time dimension. I would have to change the data type to one of the date type options, which takes me back to my original problem of having a date/ISO week instead of business week!