% of total

Options
Unknown
Unknown
edited May 2020 in Platform
How to calculate Value/(total value in column), %

------------------------------
Vasily Feofanov
Analyst
Limited Liability Company "Super Brands"
Russian Federation
------------------------------

Answers

  • Sebastian Gurt
    Sebastian Gurt Employee
    First Anniversary DACH Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights
    edited May 2020
    Options
    Hi @Vasily Feofanov,

    you can either add an alogrithm where you calculate a/dt(a) . The formula dt(a) takes the downtotal of block a. Or you add a ranking function Vertical % which gives you the same result. Check this out: Ranking functions.

    BR

    Sebastian

    ------------------------------
    Sebastian Gurt
    Consultant Team Leader
    Board International
    Germany
    ------------------------------
    -------------------------------------------
  • Jon De Leon
    Jon De Leon Customer
    First Comment First Anniversary Photogenic
    edited August 2020
    Options
    Hi @Sebastian Gurt ,
    Is there somewhere I can see all of the algorithm structures/shortcuts (i.e. "dt" means downtotal)? 

    Thanks!

    ------------------------------
    Jon De Leon
    Manager, Financial Analytics

    United States
    ------------------------------
    -------------------------------------------
  • Unknown
    Unknown
    edited August 2020
    Options
    Hi @Jon De Leon,

    yes that's right, dt means downtotal.

    Here you can find information about  column algorithm.

    You may also need information about the reverse algorithm

    Kind regards
    Tobias


    ------------------------------
    Tobias Hahn-Wiltschek
    Junior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------
  • Jon De Leon
    Jon De Leon Customer
    First Comment First Anniversary Photogenic
    edited August 2020
    Options
    Thank you @Tobias Hahn-Wiltschek !
    That was very helpful!

    ------------------------------
    Jon De Leon
    Manager, Financial Analytics

    United States
    ------------------------------
    -------------------------------------------
  • Catalina
    Catalina Customer
    Name Dropper First Comment
    Options

    Hello!

    Thank you for these explanations! I have an additional situation for which I need help. I need to have in the same table a top 10 ranking and also a column showing the % of the top 10 in the total. When I put the dt formula in a table where I already have the top 10, it does only the addition of the top 10 but not of the whole table.

    thank you!

    Catalina

    Project Manager, France

  • Leone Scaburri
    Leone Scaburri Employee
    First Anniversary First Comment Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights
    Options

    Hello @Catalina,

    you can't get it calculated on the fly on your layout. You should calculate the % through a dataflow on the whole population, then you can show just top 10 members.

  • Catalina
    Catalina Customer
    Name Dropper First Comment
    Options

    Hello @Leone Scaburri,

    Thank you for your quick reply, it helps.

    Catalina

  • Gary Beardsley
    Gary Beardsley Employee
    Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights First Comment 5 Likes
    Options

    Hi @Vasily Feofanov,

    Another commonly used formula would be rt(a), which uses the row total value.

    I thought I would mention this as it is one of my personal favourites :)

    Gary

Categories