Annual Averages

Marco Kuemmel
Marco Kuemmel Customer
Second Anniversary First Comment
edited November 2020 in Platform
Hello,
I would like to display the annual averages for several years per block and year.
How can I do that?

greetings
Marco

------------------------------
Marco Kuemmel
Administrator BI
Landkreis Vorpommern-Greifswald
Germany
------------------------------
Tagged:

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited November 2020
    Hi @Marco Kuemmel,

    did you have a look at the time functionalities in the block definition?

    image


    This will help you take your first steps. Additionally, I'd recommend our next "Tips & Tricks Tuesdays" Webinar series about the Average Functionality using Dataflows (taking place today at 16:00 CET).

    image




    Kind Regards,
    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------
  • Marco Kuemmel
    Marco Kuemmel Customer
    Second Anniversary First Comment
    edited November 2020
    Hello,
    Thanks for the answer. I've tried all possible combinations. Unfortunately without success. Can you describe a specific way for me?

    Thank you

    ------------------------------
    Marco Kuemmel
    Administrator BI
    Landkreis Vorpommern-Greifswald
    Germany
    ------------------------------
    -------------------------------------------
  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited November 2020
    Hi Marco,

    Of course, I could guide you along. But, first of all--, I'd need to know precisely what you would like to achieve. Can you describe that please with some screenshots and/or XLS examples? How did you build up your DataView so far? What challenges do you encounter?

    Kind Regards,
    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------
  • Marco Kuemmel
    Marco Kuemmel Customer
    Second Anniversary First Comment
    edited November 2020
    Hello,

    Thanks for the answer.
    In picture 2 is the solution.

    Thank you

    ------------------------------
    Marco Kuemmel
    Administrator BI
    Landkreis Vorpommern-Greifswald
    Germany
    ------------------------------
    -------------------------------------------
  • Ashley Coxon
    Ashley Coxon Active Partner
    Second Anniversary First Comment
    edited November 2020
    Hi Marco,

    Would this be a case of wanting to display a monthly average by year?  So you would have years on the columns and another entity on the rows and you wanted to show the monthly average for that particular year?  You can use the divide by option to divide the value by a certain number. 

    I'll cover this on the next Tips & Tricks session (today!) which is on averages.  Sign up here: community.board.com/events/calendar

    If you have any further questions, then please let me know.

    Thanks
    Ash

    ------------------------------
    Ashley Coxon
    Consultant
    Board Community
    Swaziland
    ------------------------------
    -------------------------------------------
  • Marco Kuemmel
    Marco Kuemmel Customer
    Second Anniversary First Comment
    edited November 2020
    Hi Ash,

    Would this be a case of wanting to display a monthly average by year? 
    That's right.
    Divide by 12 is not correct.
    In some lines there are not 12 values.
    There has to be a better solution.

    Thanks
    Marco

    ------------------------------
    Marco Kuemmel
    Administrator BI
    Landkreis Vorpommern-Greifswald
    Germany
    ------------------------------
    -------------------------------------------
  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited November 2020
    Hi Marco,

    since your screenshots show only part of the picture I could only assume some things. Below is an example I've build.

    image


    Is this what you had in mind?
    If yes, it can be achieved with the following definitions in the data block:

    imageThe average is calculated by using this constellation:


    image


    I hope, this helps.

    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------
  • Marco Kuemmel
    Marco Kuemmel Customer
    Second Anniversary First Comment
    edited November 2020
    Hi Helmut,

    Thanks for the answer.
    I have monthly data for the years 2018 to 2021 and would like to determine the average per year.
    Is that possible?

    Marco

    ------------------------------
    Marco Kuemmel
    Administrator BI
    Landkreis Vorpommern-Greifswald
    Germany
    ------------------------------
    -------------------------------------------
  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited November 2020
    Hi Marco,

    yes, that's possible. My example was built for one year only--but, that can be adopted.
    It'll take a little to adopt, but I'll get back to you.

    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------
  • Marco Kuemmel
    Marco Kuemmel Customer
    Second Anniversary First Comment
    edited November 2020

    Hi Helmut,

     

    thank you very much

    I'm curious.

     

    Marco

     



    -------------------------------------------
  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited November 2020
    Hi @Marco Kuemmel,

    here you go:


    image


    This was achieved by the same analytical function as above but each block refers to another year.

    image

    For example, the last block is defined with a "Refer to" 2019:

    image


    This is static. If you want to make the reference dynamically you'd need a procedure to set the block reference accordingly.

    Kind Regards,
    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------
  • Marco Kuemmel
    Marco Kuemmel Customer
    Second Anniversary First Comment
    edited November 2020
    Hi Helmut,
    Thank you very much, that was the solution.
    I'm excited.

    greetings
    Marco

    ------------------------------
    Marco Kuemmel
    Administrator BI
    Landkreis Vorpommern-Greifswald
    Germany
    ------------------------------
    -------------------------------------------

Categories