SpagoBI - Rotation | ||
![]() |
||
Parameters | Description | Default |
value | The name of the value attribute | value |
paramWidth | Set table width | 300 |
paramHeight | Set table height | 300 |
refreshRate | Set the delay between two consecutive request to server | 15000 |
dataurl | Specify the URL of the servlet that returns data | http://localhost:8080/openlaszlo/OpenLaszloEngineDash |
minValue | Set the min value displayed by the dashboard | 100 |
lowValue | Set the value that corresponds to the upper edge of the first arc and the lower of the second one | 295 |
highValue | Set the value that corresponds to the upper edge of the second arc and the lower of the third one | 340 |
maxValue | Set the max value displayed by the dashboard | 400 |
numOfDivisions | Set the number of the main divisions | 10 |
showMainDiv | Set the main divisions visible | true |
showSecDiv | Set the secondary divisions visible | true |
showMainText | Set the main division label visible | true |
showSecText | Set the secondary division label visible | 10 |
colorArc1 | Set the color of the first arc (between minValue and lowValue) | 0x9cff00 |
colorArc2 | Set the color of the second arc (between lowValue and highValue) | 0xfff999 |
colorArc3 | Set the color of the third arc (between highValue and maxValue) | 0xff5454 |
How to feed this movie | |
---|---|
Using a script |
The script must return a String like: "<rows><row {value parameter}='{numeric value}' /></rows>". Script example (assuming that the value parameter is as default): StringBuffer buf = new StringBuffer(); buf.append('<rows>'); buf.append('<row value=\''); float f = .... [numeric value calculation] buf.append(f); buf.append('\' />'); buf.append('</rows>') return buf; |
Using a query |
The query must return a row with an attribute with the key represented by the value parameter and with a numeric value: select {something} as {value parameter} from {table} .... Query example (assuming that the value parameter is as default): select store_efficiency as value from stores where store_id = 3 |