Hi @ErikG ,
I’ve reviewed the document you shared. I’m encountering an issue with the percentDifference() function where I’m not receiving any value. I’m unsure if I’m utilizing the function correctly. Additionally, I want to use this %change field in the Columns in the Field Well. Could you please provide detailed guidance on how to accomplish this?
Here’s the percentDifference() function I’m currently using:
percentDifference(
sum(timeinterval),
[sum(timeinterval) ASC],
1,
[years]
)
I also have a question: Do I need to create separate calculated fields for each time interval, count of categories, and average number of products fields to calculate the percentage difference between the current year and the previous year? If so, how can I replicate something similar to the image provided above:
Looking forward to your guidance. Thank you!