Hi,
I have a scenario to calculate the time-difference between each snapshots received in a month for a Vendor & vendor Site.
I was able to calculate the time difference between the subsequent snapshots by creating 2 calculated fields.
LeadDate
:
lead(
{snapshot_time_utc},
[{snapshot_time_utc} DESC],
1,
[vendorname]
)
&
DateDiffWithLead
dateDiff(LeadDate,max({snapshot_time_utc}),'MI')
The data comes up in this format in the visual as :
Now my requirement is to calculate the average of (Percentile 90) all the time duration for a month for a site
Required Output. But I am unable to add any more calculations on the field DateDiffWithLead
Vendor | Site Name | Avg (Percentile 90 Hours)
Please help me, if I am missing some thing.
Thanks