We would like to create a view of YTD, QTD & PTD that can be used either in the axis or legend of a visual. Our data is aggregated by week, depending on the week, it could appear in upto 3 places i.e. the latest week would be in YTD, QTD and PTD.
We have a work around at present that relies on aggregating the data in alteryx and uploading it as a seperate (large) data table. We would like to be able to do this from the core data so it is dynamic rather than creating another huge data set.