Skip to content

Widget Designer

yzhang921 edited this page Jan 3, 2017 · 2 revisions

Configuration->Widget->new

Load Data

Load Data from query or DataSet

case 0-switchdataload

Use Exist Cube

Reuse predefined calculated measures

Use JDBC DataSource

Default dataload from dataset, switch to new query by click New Query button, then select a datasource type SQL TEXT to experience "Type SQL, Get Chart"
image

Use Saiku Reporter

Input the repository path of save Saiku Reporter

Saiku Repository CBoard Saiku Query

Slice Dice and Filter

Click editor icon of the Selects at Row or Column to filter data Put the select at Filter to do cube data filter

Line/Bar Chart

Row: X Axis
Value: Put the measures column
Column: Add group to measures Switch Vertical/Horizontal of Axis
Add New Axis to support double value axis

Pie Chart

One pie per column

Table

Sort header to merge same cells with same value

KPI

refer to numbro do data format

Funnel

One Funnel per row

Sanky

Use row header and column header as node, value as weight of links

Radar

One Radar per column

Clone this wiki locally