TP90 for dates where two or more events occurred

Q&A
, ,
1

i want to create a calculated field for TP90 for percentage column where two or more events occurred on same date so calculate this column i tried to use percentile alongside count but it didnt work so is there any solution for this matter

2

Hey @ZEYAD ,
i don’t know if I understand you use-case correctly. You want the TP90 over the days with multpile events: maybe something liek this: ifelse(count(date,[date]) >=2, percentile({percentage},90,[date]),NULL)
or do you want the TP90-Calculation over the whole dataset but filter out the days with only one event. You could do a calculation like: ifelse(count({date},[{date}])>1, 1,0) and build filter.

I hope I could help you.

Regards Robert

3

yes i want in case there are two or more events occurred within same day to calculate percentile if not then null , let me try this one thanks alot

4

Hi @ZEYAD,

It’s been awhile since we last heard from you on this thread; did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

5

Hi @ZEYAD,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you