I have a dataset with dates (start of the week), diseases, and their respective sample positivity (per_cent_positive) as follows:
![NikhileshUnnikrishnan_0-1680678398391.png NikhileshUnnikrishnan_0-1680678398391.png](https://community.esri.com/t5/image/serverpage/image-id/67298i3E915BFB8CCCBF43/image-size/medium?v=v2&px=400)
This dataset gets updated every week, I want to use this data as an indicator in the ArcGIS dashboard. Still, I need this in the format below where city_pos_t is the latest sample positivity and city_pos_t-1 is the week before the latest.
![NikhileshUnnikrishnan_2-1680678799141.png NikhileshUnnikrishnan_2-1680678799141.png](https://community.esri.com/t5/image/serverpage/image-id/67300iFFE6436B4613A25D/image-size/medium?v=v2&px=400)
It would be very helpful if anyone helps me with the arcade expression that can be used to get the above format. Thanks!