Visokio website     Downloads     Video tutorials     KnowledgeBase  
Idea: Formulae - Specifying ALL DATA subset in a formula? - Visokio Forums
Idea: Formulae - Specifying ALL DATA subset in a formula?
  • VoteVote Up4Vote Down        mohamed July 27, 2012 6:15AM
    How can I have a formula to look at the ALL DATA instead of the filtered data? For example, SUBSET_SINGLETON([Latest month]) in my file always returns May. But if the filtered data is zero, it returns "no value". Is there way of telling the function to look at the ALL data, so something like this SUBSET_SINGLETON([Latest month], subsetAll())
  •        CRead August 8, 2012 8:59AM
    With issues like this, I find de-query (from the data subset menu for the view) will often solve the problem. This stops filters on certain fields affecting the view.

    There are, however, cases where the ability to de-query within a formula would be useful.
  •     steve August 8, 2012 12:55PM
    Regular formula fields are calculated in terms of ALL DATA already. There is a need to allow you to configure formulas to calculate for the view's (typically filtered) data instead.


    But this is the opposite of what you're asking. I assume you must be using one of the following places you can apply formulas:
    • In-view aggregation, with "(formula result)" selected (as per workarounds described here)
    • Formulas in Content View, and also view headers/footers and page headers/footers
    • Formula measures in the Bar/Line view and other forthcoming new views in 2.8

    In all these cases, formulas are recalculated in terms of the view's data. Bar/Line formula measures are further restricted to the 'bucket' of data being 'measured'.

    There is currently no way in such a formula to "reach outside" of the data subset being calculated and obtain results from filtered-out data, aside from changing the view's "Data Subset".

    I have reclassified this as an Idea - the ability to access data outside of the calculation context, through some extension of formula functions.
  •     Bart April 9, 2013 12:03PM
    This is exactly what I would need for my tables. Are you still considering this option ?
  •     steve April 9, 2013 12:12PM
    Yes, although it doesn't have much popularity. More likely earlier is the ability to configure a view to recalculate its formulas, instead of the workaround here:


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

Sign In Apply for Membership