Forum Discussion
Helper IISelect max value from the date slicer
Hi Ashish
Below is the data.Activity
MonthYear
Value
Monthly Clients Churn
Monday, 1 January 2024
0.052
Monthly Clients Churn
Thursday, 1 February 2024
0.022
Monthly Clients Churn
Friday, 1 March 2024
0.0515
Monthly Clients Churn
Monday, 1 April 2024
0.02255
Monthly Clients Churn
Wednesday, 1 May 2024
0.022
Monthly Clients Churn
Saturday, 1 June 2024
0.051
Monthly Clients Churn
Monday, 1 July 2024
0.04
Monthly Clients Churn
Thursday, 1 August 2024
0.051
Monthly Clients Churn
Sunday, 1 September 2024
0.015
Monthly Clients Churn
Tuesday, 1 October 2024
0.051
Monthly Clients Churn
Friday, 1 November 2024
0
Monthly Clients Churn
Sunday, 1 December 2024
0
Monthly Clients Churn
Wednesday, 1 January 2025
0
Monthly Clients Churn
Saturday, 1 February 2025
0
Monthly Clients Churn
Saturday, 1 March 2025
0
Monthly Clients Churn
Tuesday, 1 April 2025
0
Monthly Clients Churn
Thursday, 1 May 2025
0
Monthly Clients Churn
Sunday, 1 June 2025
0
When Selected in Slicer as Q1 or just July, the data should be displayed for July, if selected for Q1, should display data for Sept2024
Q1
Jul-24
Aug-24
Sep-24
Q2
Oct-24
Nov-24
Dec-24
Q3
Mar-24
Q4
Jun-25
Whole of 2024 as Year
Jun-25
Helper IIHi Ashish
Below is the data.
Activity | MonthYear | Value | |
Monthly Clients Churn | Monday, 1 January 2024 | 0.052 | |
Monthly Clients Churn | Thursday, 1 February 2024 | 0.022 | |
Monthly Clients Churn | Friday, 1 March 2024 | 0.0515 | |
Monthly Clients Churn | Monday, 1 April 2024 | 0.02255 | |
Monthly Clients Churn | Wednesday, 1 May 2024 | 0.022 | |
Monthly Clients Churn | Saturday, 1 June 2024 | 0.051 | |
Monthly Clients Churn | Monday, 1 July 2024 | 0.04 | |
Monthly Clients Churn | Thursday, 1 August 2024 | 0.051 | |
Monthly Clients Churn | Sunday, 1 September 2024 | 0.015 | |
Monthly Clients Churn | Tuesday, 1 October 2024 | 0.051 | |
Monthly Clients Churn | Friday, 1 November 2024 | 0 | |
Monthly Clients Churn | Sunday, 1 December 2024 | 0 | |
Monthly Clients Churn | Wednesday, 1 January 2025 | 0 | |
Monthly Clients Churn | Saturday, 1 February 2025 | 0 | |
Monthly Clients Churn | Saturday, 1 March 2025 | 0 | |
Monthly Clients Churn | Tuesday, 1 April 2025 | 0 | |
Monthly Clients Churn | Thursday, 1 May 2025 | 0 | |
Monthly Clients Churn | Sunday, 1 June 2025 | 0 | |
When Selected in Slicer as Q1 or just July, the data should be displayed for July, if selected for Q1, should display data for Sept2024 |
| ||
Q1 | Jul-24 | ||
Aug-24 | |||
Sep-24 | |||
Q2 | Oct-24 | ||
Nov-24 | |||
Dec-24 | |||
Q3 | Mar-24 | ||
Q4 | Jun-25 | ||
Whole of 2024 as Year | Jun-25 |
Super UserNot sure what you want but here is my attempt
- reddevil
Thanks Ashish, what if you select Q2 or Full Year.
- Ashish_Mathur
Try that yourself. If the result does not match your expectation, then clearly post back the result you are expecting.
- reddevil
What if you select Q1 and Q2 together, its showing up as blank.
- Ashish_Mathur
What answer are you expecting when you select Q2 of FY 2024-25? What answer are you expecting when you select FY 2024-25. Share the answers after reviewing my file.