Forum Discussion

reddevil's avatar
reddevil
Icon for Helper II rankHelper II
1 year ago
Solved

Select max value from the date slicer

Hello everyone, I have a date slicer which shows the Year, Quarters and Months as shown below:   Scenario: When I select Quarters or Months, I want the last value of the corresponding quart...
Need Help
  • reddevil's avatar
    reddevil
    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

reddevil's avatar
reddevil
Icon for Helper II rankHelper II
1 year ago

Thanks Ashish, what if you select Q2 or Full Year.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    1 year ago

    Try that yourself.  If the result does not match your expectation, then clearly post back the result you are expecting.

    • reddevil's avatar
      reddevil
      Icon for Helper II rankHelper II
      1 year ago

      What if you select Q1 and Q2 together, its showing up as blank.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    1 year ago

    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.