Skip to content

razorflow in pentaho #17

Description

@techie-anu

hi,
i am trying to bring in razorflow in pentaho.
intead of the usual javascript i have given the razorflow codes.
my very first doubt is how to parameterize value in razorflow.say if i am giving an input eg:Saless with a value=1234 how to get the value in the add series line of code given below:

in the below code i want to replace the1234 with someting likesales.getvalue() which will inturn fetch 1234.. can anyone please help me do it.. i am new to this entirely

<!doctype html >

<title>RazorFlow Quick Start</title> <script type="text/javascript" src="D:\Program Files\server\biserver-ee\tomcat\webapps\pentaho\dashboard_quickstart\js\jquery.min.js"></script> <script type="text/javascript" src="D:\Program Files\server\biserver-ee\tomcat\webapps\pentaho\dashboard_quickstart\js\razorflow.min.js"></script> <script type="text/javascript" src="D:\Program Files\server\biserver-ee\tomcat\webapps\pentaho\dashboard_quickstart\js\razorflow.devtools.min.js"></script> <script type="text/javascript" src="D:\Program Files\server\biserver-ee\tomcat\webapps\pentaho\dashboard_quickstart\js\check.js"></script>
    <!-- Don't delete this div. This is where RazorFlow will get rendered. -->
    <div id="dbTarget" style="position:relative;" class="rf">
    <script language="javascript">

StandaloneDashboard(function(db){
var chart = new ChartComponent ("chart");
chart.setDimensions (8, 6);
chart.setCaption ("Annual Sales Summary (2010 - 2013)");
chart.setLabels (["2010", "2011", "2012", "2013"]);
chart.addSeries ("sales", "Sales",1234, 1040000, 1020000, 1160000]);

chart.setYAxis("Sales", {
    numberPrefix: "$",
    numberHumanize: true
});

var selectedYear;
var labelsForQuarters = {
    "Q1": ["January", "February", "March"],
    "Q2": ["April", "May", "June"],
    "Q3": ["July", "August", "September"],
    "Q4": ["October", "November", "December"]
};
var yearData = {
    "2010": {
        "Q1": [110000, 76000, 88000],
        "Q2": [116000, 92000, 62000],
        "Q3": [114000, 86000, 11800],
        "Q4": [92000, 102000, 105000],
        data:  [274000, 270000, 318000, 299000]
    },
    "2011": {
        "Q1": [370000, 290000, 320000],
        "Q2": [370000, 290000, 320000],
        "Q3": [370000, 290000, 320000],
        "Q4": [370000, 290000, 320000],
        data: [306000, 203000, 270000, 264000]
    },
    "2012": {
        "Q1": [87000, 89000, 65000],
        "Q2": [13000, 44000, 106000],
        "Q3": [85000, 103000, 67000],
        "Q4": [59000, 69000, 113000],
        data: [241000, 280000, 255000, 241000]
    },
    "2013": {
        "Q1": [105000, 76000, 88000],
        "Q2": [116000, 92000, 62000],
        "Q3": [114000, 86000, 118000],
        "Q4": [92000, 102000, 105000],
        data: [269000, 270000, 318000, 299000]
    }
}

chart.addDrillStep (function (done, params, updatedComponent) {
    var label = selectedYear = params.label;
    updatedComponent.setLabels (["Q1", "Q2", "Q3", "Q4"]);
    updatedComponent.addSeries ("sales", "Sales", yearData[label].data);
    done();
});

chart.addDrillStep (function (done, params, updatedComponent) {
    var label = params.label;
    updatedComponent.setLabels (labelsForQuarters[label]);
    updatedComponent.addSeries ("sales", "Sales", yearData[selectedYear][label]);
    done();
});

db.addComponent (chart);

});

        </script>

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions