How to handle Multiple Dates Counts with Common MonthYear Axis?
For example in the below Repair QVD, we have Multiple dates called "Repair First Estimate Received Date",[Repair Completed Date], "Repair Add Date", "Repair VOR Date", "Repair First Repair Authority Issued".
From these Dates, we have to calculate the common MonthYear which is applicable to all the above dates. So we can see each Date wise count of Repairs in one chart with a common MonthYear Dimension.
Date(Floor(Repair First Estimate Received Date])) as "Repair First Estimate Received Date",
Date(Floor([Repair Completed])) as [Repair Completed Date],
Date(Floor( [Repair Add Date])) as "Repair Add Date" ,
[Repair Closed Date],
Date(Floor([Repair VOR Date])) as "Repair VOR Date",
Date(Floor( [Repair First Repair Authority Issued])) as "Repair First Repair Authority Issued",
FROM [lib://$(vLib)/QVD/Repair_QVD] (qvd);
First, we have to create a Bridge Table by taking [Repair ID] and Each date as a resident into one table and need to concatenate all the resident tables into one and to call each date as separate in UI need to qualify each date by using Flag in Set Analysis.
Then based on these Date need to create a Master calendar like below.
How to create a New Date field by adding 35 Business days to the Existing Date Field?
For example, we have [Received Date]. From this date need to derive a new date field called “Estimate Date” by adding 35 Business days.
A “business day” is defined as any Monday, Tuesday, Wednesday, Thursday or Friday that is not a bank holiday date in England in the relevant year. The above scenario we can achieve by using Lastworkdate()
We can able to validate the above Business days duration by using the below link