Hi,
I would recommend revising your underlying data table structure!
From a performance point of view, if you are interested in always comparing Annual/Yearly aggregates (Current vs. Previous vs. Penultimate), then I would recommend calculating theses values ahead of time in your ETL and save them as physical variables in your final table.
Benefits this approach could provide you includes:
- Less Run-Time calculations
- Less Visual Objects to present Annual Changes ----> Fewer Run-Time queries against the data ----> Better LASR server performance for concurrent users.
- Ability to place all three annual values in a single visual and perform %change calculations much easier than your current approach.
Remember, use VA Explorer and Report Designer to experiment with ideas and prototypes, then once you are set on a layout or Report content, make required data changes to optimize your reports for production.
Just my two cents, Hope it helps,
Ahmed
... View more