Count of Days with Fractile function

[shyamcharan]

Hi Experts,

I have data which has the ID, week, dates in the week, the response time in seconds and minutes as shown below.

ID	Week	Date	ResponseTime_Secondds	Min
1	1	01-01-2017	819	13.65
2	1	01-01-2017	495	8.25
3	1	01-01-2017	768	12.8
4	1	01-01-2017	587	9.783333
5	1	01-01-2017	489	8.15
6	1	01-01-2017	510	8.5
7	1	01-01-2017	975	16.25
8	1	01-01-2017	638	10.63333
9	1	01-01-2017	872	14.53333
10	1	01-01-2017	814	13.56667
11	1	01-01-2017	554	9.233333
12	1	01-01-2017	216	3.6
13	1	02-01-2017	529	8.816667
14	1	02-01-2017	945	15.75
15	1	02-01-2017	241	4.016667
16	1	02-01-2017	761	12.68333

As shown in the attached QVW, chart 1 has the 50th percentile values calculated for each individual day using the Fractile function.

In chart 2, I would need to show the count of days in a week that had the 50th percentile value >= 10.5.

The expected result from the data in attached QVW should be Week 1 = 3 and Week 2 = 5 days.

However, I am unable to get it worked.

Can you please help. Appreciate your response.

Regards,

Shyam

[sunny_talwar]

That makes sense

tresesco‌ - I am unable to send you a private message (you have not followed me)... I have thought about connecting with you outside of these threads, but was never really able to send you a message... Do you mind sending me a private message or following me

[Kushal_Chawda]

tresesco‌, me also not able to send message to you. Please do the needful . Sometimes it is good to reach out legend privately

[tresesco]

Sunny, Kushal,

I have just sent you message. If I could, you too should be able to. I am not very good at these community rules. Sorry, if I am wrong.

[sunny_talwar]

tresesco‌ - This changed around 1 and half year ago when connecting logic changed.... earlier when I added someone else as a connection, it was a two way thing... but around 1 and half year ago, it changed to just one way thing.... If I add you as a connection... then you can message me but I can't. I can only message you if you add me as a connection.

I think this might have done to save the privacy of people where they can accept to be a connection but they still don't want to get unnecessary private messages

[shyamcharan]

@kush141087, Thanks for the suggestion.

I would be using the below solution.

=Count(DISTINCT {<Date={"=Fractile(Min,0.5)>10.5"}>}Date)

Thanks again all!