Visokio website     Downloads     Video tutorials     KnowledgeBase  
Current selected filters value in formula field - Visokio Forums
Current selected filters value in formula field
  •     enrico68 May 24, 2012 10:05AM
    Is there a way to use current selected filter values in formula fields?

    This is the situation: the database is formed by records representing monthly income from different sellers.
    There are many records for each month and for each seller, representing incomes from selling different kind of products.

    In the filters users can select a range of months (es: from 1 to 3) and in a bar chart the corresponding sum of incomes for each seller for that range of months will be shown.

    I'd like to add another view on which to show the perspective income for the whole year for each seller (calculated simply dividing the total income for the selected records for each seller by the number of months selected - in the example, 3 -and multiply it by 12)

    In this way depending on the time interval filtered, different perspective incomes will be dinamically calculated.

    So, I'd like to find a way to include into the formula the fact that I have selected only the records with months 1, 2 and 3.

    Thanks and bye
  • 1 Comment
  •     michael May 24, 2012 12:33PM
    Hi Enrico,

    If you need to use different filtered subsets of data in views, please, see:
    http://www.visokio.com/queries-subsets

    If you need to have access to variables from formulas, can you have a look to:
    http://www.visokio.com/formula-fields
    http://www.visokio.com/defining-variables

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership