Showing Dates Outside Range of TimeDim() Function
I have compiled a report and I have used the TimeDim() function to fill in dates within the range.
This has worked to a great extent but when I filter my chart to show another Source Y, e.g. another product, then the beginning and end of the month dates do not show on the chart since they are seen as empty dimensions.
Is it possible to apply the dates from Source X to my filtered chart of Source Y without affecting the results of my chart?
I've tried all sorts of methods but to no avail and I will appreciate advice and suggestions to my query.
Jaspal Dhariwal replied
I figured it out and it was a lot simpler than what I thought it would be
I removed the filter on the chart and created a new variable
=[Average Turnaround (Minutes)] Where ([Contract Source] InList("SourceY")) where SourceY has been renamed but relates to the product
I have to amend the average line now!
EDIT: Amended average line formula
=Interpolation(Round(Sum([Paid Out Turnaround Time (Minutes)])/Count([Contract Number];All);0) In ([Contract Source]) Where ([Contract Source] InList("SourceY")))