Multi Pass Aggregation on non-Numeric Data

Comments

11 comments

  • Avatar
    Tal Admon

    Hi James,

    You can use the "contribution" quick function and get the % of total - 

    see example here (the source table has Id and dosage columns - 10 rows in total)

    0
    Comment actions Permalink
  • Avatar
    IT Department

    Thanks - I did just get that to work!

    Not sure why the Contribution Total isn't 100%, but I can live with that :)

    0
    Comment actions Permalink
  • Avatar
    Tal Admon

    Strange though...

    You can show the grand total by clicking on the dosage row menu and select "Grand Totals" - it should be adding up to 100% - maybe you have pagination and you don't see the entire table?

    0
    Comment actions Permalink
  • Avatar
    IT Department

    Apparently, percentage columns show their AVERAGE on the Grant Total row.

    I guess that makes sense.

    Would be nice to have a check box for each Value "Include in Grant Total"

    0
    Comment actions Permalink
  • Avatar
    IT Department

    The more I look at Contribution, the more I suspect it has some bugs.  The above scenario worked just fine.  Then I got this mess:

    Follow Up Call Response
     
    # of Responses
     
    Contribution to # of response
     
     
    Follow Up - Call Back in 2 Hours
    4
    2.94%
     
    Follow Up - Confirms Receipt
    5
    3.68%
     
    Follow Up - Left VM - Max Attempts
    11
    8.09%
     
    Follow Up - Manual Deferral
    1
    0.74%
     
    Follow Up - No Followup Required
    4
    2.94%
     
    Follow Up - Pending Pickup
    1
    0.74%
     
    Total
    26
    70.27%
    0
    Comment actions Permalink
  • Avatar
    IT Department

    Seems to be not recognizing the Widget Filter - when I shut off the filter I get:

     
     
     
    Follow Up Call Response
     
    # of Responses
     
    Contribution to # of response
     
     
    Customer Service - No Prescription in Hand
    1
    0.74%
     
    Customer Service - Other
    3
    2.21%
     
    Customer Service - Verify Information
    1
    0.74%
     
    File Maintenance
    3
    2.21%
     
    Follow Up - Call Back in 2 Hours
    4
    2.94%
     
    Follow Up - Confirms Receipt
    5
    3.68%
     
    Follow Up - Left VM - Max Attempts
    11
    8.09%
     
    Follow Up - Manual Deferral
    1
    0.74%
     
    Follow Up - No Followup Required
    4
    2.94%
     
    Follow Up - Pending Pickup
    1
    0.74%
     
    Queue Maintenance - Passing Pharmacy Locator
    25
    18.38%
     
    Queue Maintenance - System Issues
    2
    1.47%
     
    Response Pending - Send to queue
    29
    21.32%
     
    Search Complete - Additional Search Requested - Send To Queue
    16
    11.76%
     
    Search Complete - Left Voicemail
    12
    8.82%
     
    Search Complete - Pt Accepted
    18
    13.24%
     
    Total
    136
    16.77%
    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Also remember, that Grand Total line is calculated on it's own for each measure. If you click on the hamburger menu for each measure you will notice an option saying how grand total should be calculated for given measure:

    If Auto is selected that means, that given measure behavior will be replicated on the grand total line, and sometimes it might create strange results. In your case ensure you have selected Sum, that should work then.

    Regards,

    Michał

    0
    Comment actions Permalink
  • Avatar
    Percy Chiang (Edited )

     I've seen for Multi-Pass Aggregation demonstrate it being used directly on numeric data as well. So I just used  this case as  an example. If I have two layers for dosage, the contribution method doesn't work properly, meaning they show 100% in each dosage (50, 100 mg...etc) which is not my requirement.  Any one have related solutions on that.

    0
    Comment actions Permalink
  • Avatar
    Andrew Block

    Darrell could you attach a screenshot of your issue? Is the Dosage a dimension in the row field?

    0
    Comment actions Permalink
  • Avatar
    Percy Chiang

    0
    Comment actions Permalink
  • Avatar
    Andrew Block (Edited )

    Darrell,

    You should be able to use a value formula to calculate your wanted "percentage" using sum for the count and all for the dosage in the following:

    (Count) / (Count, ALL(Dosage))

    What this is saying is take the count from the dosage and divide that from the count of all dosages , which should eliminate the issue of it calculating the contribution of the similar dosage types like 100mg, and 50mg etc. 

    Let me know if this works for you


    Thanks

    0
    Comment actions Permalink

Please sign in to leave a comment.