Visokio website     Downloads     Video tutorials     KnowledgeBase  
Graph View: Scatter Plot to display only top 10 values? - Visokio Forums
Graph View: Scatter Plot to display only top 10 values?
  •     OmarKhan June 25, 2013 9:49AM
    Scatter plot should be showing Masterbrands

    Y axis is YoY change
    X axis is SOV%

    Size of bubble is the expenditure aggregated on a yearly basis

    What would be perfect would be to have only the top ten brands shown depending on the filters on the side:

    Category
    Market
    Gender
    Focus Competitors


    But it is empty when you try the filters.
  • 1 Comment
  •     paola June 25, 2013 11:16AM
    Several changes needed, in addition to making sure that your fields are correctly formatted (Text/Category/Integer/Dec).

    YOY change% =
    IF([LY Spend]>0,
    ([TY Spend]-[LY Spend])/[LY Spend],
    null)

    For all formulas where field you're dividing with might be empty (null) or contain zero value, please use IF condition.

    RANK([TY Spend], [TY Spend], SUBSET([Masterbrand]))

    I assumed here you wish to group Spend by Masterbrand, but you can customise this format, also consider ranking Subsetsum of a field.

    [Top 10]=
    IF([Rank]<=10,
    [TY Spend],
    "0")

    Again here you can use SubsetSum instead of [TY Spend].
    The problem with your formula was that it was placing category value and was effectively a text field, so you could not use it for visualisation e.g. size by this field.

    Now you can tick the option not to display zero values, as this formula will create zeros for those records outside of Top10.

Welcome!

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

Sign In Apply for Membership