Forum Discussion

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
3 years ago
Solved

max value for that day

Hi,

 

How do I show the max value for that specific day? Right now on my visual it is summing up all the three values for the day, but I need to see just the latest that's the max value for the day...

 

for eg - Rental should just show "28828"

          - Owner should just show "11328"

 

DTDRentalOwner
9/14/2022 12:00:00 AM2763611328
9/14/2022 12:00:00 AM2852810481
9/14/2022 12:00:00 AM2882810734

 

Is there anyway I can do this?

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please try changing the aggregation type to Maximum, something like below.

     

     

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Please try changing the aggregation type to Maximum, something like below.