Forum Discussion
Select max value from the date slicer
- 1 year ago
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
Try that yourself. If the result does not match your expectation, then clearly post back the result you are expecting.
What if you select Q1 and Q2 together, its showing up as blank.