topic Re: YoY Growth in Table Chart in App Development

YoY Growth in Table Chart

rp1366nc — Thu, 12 Dec 2024 09:50:14 GMT

I have try to create a YoY Growth in a table chart.

I try a expression to get the previous year value:

Sum( {<SalesYear=${year(SalesYear)-1}>} SalesAmount )

But the value have no change which same as the current value.

May I know what is the problems?

Thank you.

rupeshshah888 — Thu, 12 Dec 2024 10:34:25 GMT

Please try:

Sum( {<SalesYear={'$(=year(max(SalesYear))-1)'}>} SalesAmount )

Kushal_Chawda — Thu, 12 Dec 2024 10:41:32 GMT

@rp1366nc If you have year as dimension set analysis won't work. You need to use above function

=above(sum(SalesAmount))