YoY Growth

I am creating an application where I have to show YoY growth of every expense present in dataview. What's the best approach I can perform to add YoY growth percent below every expense without adding that member in the entity already used.
Attaching the screenshot for the reference.

Answers

  • Hamza Mesbahi
    Hamza Mesbahi Employee
    5 Answers Second Anniversary 10 Comments Board Advanced Developer
    edited March 11

    Hi @Divya Kohli,

    Based on the screenshot you provided, achieving this layout would require some configuration. In a data view layout, each row is associated with an entity member. To calculate the % change on the fly without involving backend changes/processes, I recommend one of the following approaches:

    1. Have your business entity by row, with % change values for each metric as block algorithms (as shown below, for example).

    2. Alternatively, you could align your blocks vertically, with the business metric entity in the columns and the values and % changes in the rows.

    Both options can be implemented directly in your layout without any backend configuration.

    Hope this helps,

    Kind regards,

    Hamza