I have show Maximum wait time which I have calculated as max(wait_time) and it’s top 1% of which i.e. row 15th of Column wait_time is Last entry of Top 1% which is sorted in descending order by maximum of wait_time and I have to ignore that 15th row and take the 16th row wait_time which is considered as maximum wait_time of 1% i.e. wanted that calculated field created. Is that possible and hope you have got my point, what I was trying to explain?
The below screen shot will clearly give you what I exactly needed. Total Contact is total count of data and 1%_TotalCount is 1% of Total Contact i.e. 1% of 5697=57 and Nth_indexofWaitTime is 58th rank (red marked) which we need by indexing that row wait time, currently stuck on that. Please help on this to wrap it up. Thanks in Advance!
Hi @vinay_revankar
do you have a calculation in mind to calculate only that one row?
like
ifelse(DenseRank=TotalCount*0,01,0,1)
With Lead or Lag you could try to get the next/pre value.
And try to combine both calculations.
BR
1 Like
Hello @ErikG thanks for the solution I got the solution but this is new one will try out in this way too! 