how to compare the current string value with the previous year string value?
Hi @rebecca000827 – Please review string functions available in quicksight. If you can share more details on what you are exactly looking for, we can see which one the functions here will fit your usecase.
I have some information about the strata and its insurance records. some strata have few insurance records in different years, for example, 2022 from company A, 2023 from company B, 2025 from company C.
I try to flag those record when the strata change their broker, for example, from A to B, or B tp C. I want to flag all those changes to analyze why they change.
i always encounter the mismatched aggregation error and don’t know how to compare the current data with the previous data
Hi @rebecca000827 – This post might give you ideas on how to proceed with your use case.
Thank you! Here is a sample of my data, is there any way we could process for the dataset with multiple layers?
Hi @rebecca000827 - One approach here is to use calculated field and conditional formatting on the table visual to highlight the strata who changed broker. I used your example sample data and created a calculated field “brokerchanged” with following formula.
ifelse(previous=‘’,0,ifelse(broker=previous,0,1))
Then, i used conditional formatting on the table visual as shown in screenshot below to highlight the strata where broker changed.
1 Like