Hello, for wanting to compare between the first and last value in a given period, how do you change default behaviour which only allows a comparison between the last and the second last value please?
Hi @matgbs and welcome to the QuickSight community!
The best way to manipulate a KPI, would be to create a calculated field to run the comparison that you’re looking to make.
If you’re looking to compare the first and last values, you can do that with using max and min; although if looking to partition by a given period, you may need to explore maxOver and minOver.
Let me know if you have any additional questions