public void RefreshTableViz(Visual visual)
{
DataTable table = GetTableFromParameter("statResult");
string testPerformed = "";
if (table != null)
{
visual.As <TablePlot>().Data.DataTableReference = table;
TablePlot tablePlot = visual.As <TablePlot>();
DataColumnCollection dfColumns = visual.As <TablePlot>().Data.DataTableReference.Columns;
List <DataColumn> listOfCols = new List <DataColumn>();
DataValueCursor dv = DataValueCursor.CreateFormatted(table.Columns["test"]);
foreach (DataRow row in table.GetRows(dv))
{
testPerformed = dv.CurrentDataValue.ValidValue.ToString();
break;
}
for (int i = 0; i < dfColumns.Count(); i++)
{
if (!(dfColumns[i].Name == "W" && testPerformed == "t test") && !(dfColumns[i].Name == "t" && testPerformed == "Mann-Withney test") && !(dfColumns[i].Name == "degree_of_freedom" && testPerformed == "Mann-Withney test"))
{
listOfCols.Add(dfColumns[i]);
}
}
visual.As <TablePlot>().TableColumns.Clear();
visual.As <TablePlot>().TableColumns.AddRange(listOfCols);
}
}
public void RefreshBarChartViz(Visual visual)
{
DataTable table = GetTableFromParameter("inputTable");
if (table != null)
{
visual.As <BarChart>().Data.DataTableReference = table;
visual.As <BarChart>().XAxis.Expression = "<" + GetColumnExpression(Scope["inputTable"].ToString(), Scope["samples"].ToString()) + ">";
visual.As <BarChart>().YAxis.Expression = "Avg(" + GetColumnExpression(Scope["inputTable"].ToString(), Scope["values"].ToString()) + ")";
//visual.As<BarChart>().ColorAxis.Expression = "<" + GetColumnExpression(Scope["inputTable"].ToString(), Scope["condition"].ToString()) + ">";
visual.As <BarChart>().Data.WhereClauseExpression = GetColumnExpression(Scope["inputTable"].ToString(), Scope["features"].ToString()) + " = \"" + Scope["featureSelection"].ToString() + "\"";
}
}
public void RefreshScatterPlotViz(Visual visual)
{
DataTable table = GetTableFromParameter("inputTable");
if (table != null)
{
visual.As <ScatterPlot>().Data.DataTableReference = table;
visual.As <ScatterPlot>().XAxis.Expression = "<" + GetColumnExpression(Scope["inputTable"].ToString(), Scope["region"].ToString()) + ">";
visual.As <ScatterPlot>().YAxis.Expression = "Avg(" + GetColumnExpression(Scope["inputTable"].ToString(), Scope["values"].ToString()) + ")";
visual.As <ScatterPlot>().Data.WhereClauseExpression = GetColumnExpression(Scope["inputTable"].ToString(), Scope["features"].ToString()) + " = \"" + Scope["featureSelection"].ToString() + "\" and" + GetColumnExpression(Scope["inputTable"].ToString(), Scope["values"].ToString()) + " is not null";
visual.As <ScatterPlot>().MarkerByAxis.Expression = "<" + GetColumnExpression(Scope["inputTable"].ToString(), Scope["samples"].ToString()) + ">";
visual.As <ScatterPlot>().Trellis.PageAxis.Expression = "<" + GetColumnExpression(Scope["inputTable"].ToString(), Scope["marker"].ToString()) + ">";
visual.As <ScatterPlot>().ColorAxis.Expression = "<" + GetColumnExpression(Scope["inputTable"].ToString(), Scope["region"].ToString()) + ">";
visual.As <ScatterPlot>().LineConnection.ConnectionAxis.Expression = "<" + GetColumnExpression(Scope["inputTable"].ToString(), Scope["samples"].ToString()) + ">";
}
}
