Alpha Video Training
Page 2 of 2 FirstFirst 12
Results 31 to 32 of 32

Thread: Google Charts - Prompting For SQL Agruments

  1. #31
    Real Name
    Join Date
    Apr 2011
    SF Bay Area

    Default Re: Google Charts - Prompting For SQL Agruments

    Based on the component from post #16 in this chain, what is the code using either RGraph or Google Charts to pass data from the click of a bar in the chart so that it can be used in a second drill down chart?
    Here is what I am trying to do:
    1. user selects a supplier (for example: New England Seafood Cannery) and presses the Refresh Chart button
    2. user then clicks on bar (for example: "Boston Crab Meat")
    3. The "Boston Crab Meat" value is then used in the xbasic script as a filtering parameter in a second chart

    I am trying to figure out step #3 above for how to pass the value from the click on the chart to an xbasic session or page variable so that the parameter can be used in an xbasic sql script to get data for a second chart.

  2. #32
    Real Name
    Join Date
    Dec 2019

    Default Re: Google Charts - Prompting For SQL Agruments

    Help Frank,
    I am very new to Alpha Software. My use case is as mentioned below.

    Use case: Pie chart showing how much business the company has bound with the different carriers we work with. The pie chart should be capable of being drilled down. For example if you double click one of the carriers in the pie chart it opens a pie chart that shows the percentage of each coverage is bound with that carrier including the total limits and total premium. Ex. GIG -> LPIG -> 16%, $39,00,000 in limits, $1,900,00 in premium.

    Please help me to set a working approach.


Similar Threads

  1. Google charts API - using a CSV or a dbf file as data source
    By jcarrallo in forum Mobile & Browser Applications
    Replies: 0
    Last Post: 10-06-2013, 05:14 PM
  2. Report agruments on a tabbed ui
    By Sparticuz in forum Application Server Version 11 - Web/Browser Applications
    Replies: 6
    Last Post: 02-07-2012, 03:18 PM
  3. Another Fusion Charts Genie: Single-Series for SQL
    By Steve Workings in forum Announcements
    Replies: 0
    Last Post: 12-21-2011, 10:40 AM
  4. Google Charts API with POST
    By Peter.Wayne in forum Alpha Five Version 10 - Desktop Applications
    Replies: 0
    Last Post: 05-30-2011, 05:16 PM
  5. Google Charts API
    By koga101 in forum Application Server Version 10 - Web/Browser Applications
    Replies: 8
    Last Post: 04-02-2011, 06:52 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts