How to change KPI visual default behaviour from last and second last to first and last value

Question & Answer
,
1

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?

2

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

3

Hi @matgbs,
It’s been awhile since we last heard from you on this thread, was the information provided in the prior response helpful for your case or did you have additional questions?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @matgbs,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!