A Solution that makes Applications & Business Intelligence Real
Data visualisation
Creates a TABstrip type dashboard, including charts and reports
BEGIN_DASHBOARD
option :
BEGIN
type : $TABSTRIP , title : ""
END
TabTitle Optinal..
TabTitle : 'title 1 ', Ms4Script_Import : .......
TabTitle : 'title 2 ', FormMS4 : DrawGrid .......
FormPlus : theme : "blueopal" DrawPIE.......
TabTitle : "title 3 " , FormPlus : theme : "bootstrap" DrawRADAR, .......
....
END_DASHBOARD ;
| ##Break Employee : | 1 | Davolio | Total Price Units : | 1691.40 | Total Quantity : | 1620.00 | Total business : | 38789.00 | total Orders: | 26 | Total country | 14 |
| ##Break Employee : | 2 | Fuller | Total Price Units : | 822.20 | Total Quantity : | 1085.00 | Total business : | 22834.70 | total Orders: | 16 | Total country | 9 |
| ##Break Employee : | 3 | Leverling | Total Price Units : | 812.60 | Total Quantity : | 940.00 | Total business : | 19231.80 | total Orders: | 18 | Total country | 12 |
| ##Break Employee : | 4 | Peacock | Total Price Units : | 2340.40 | Total Quantity : | 2212.00 | Total business : | 53114.80 | total Orders: | 31 | Total country | 14 |
| ##Break Employee : | 5 | Buchanan | Total Price Units : | 701.70 | Total Quantity : | 778.00 | Total business : | 21965.20 | total Orders: | 11 | Total country | 8 |
| ##Break Employee : | 6 | Suyama | Total Price Units : | 778.30 | Total Quantity : | 963.00 | Total business : | 17731.10 | total Orders: | 15 | Total country | 10 |
| ##Break Employee : | 7 | King | Total Price Units : | 631.10 | Total Quantity : | 455.00 | Total business : | 17864.80 | total Orders: | 11 | Total country | 8 |
| ##Break Employee : | 8 | Callahan | Total Price Units : | 1352.30 | Total Quantity : | 923.00 | Total business : | 23161.40 | total Orders: | 19 | Total country | 11 |
| ##Break Employee : | 9 | Dodsworth | Total Price Units : | 272.20 | Total Quantity : | 575.00 | Total business : | 11365.70 | total Orders: | 5 | Total country | 5 |
TOTAL ORDERS: 152 | ||||||||||||
TOTAL EMPLOYEE: 9 | ||||||||||||
$TOTAL03: Business | $TOTAL01: Price Unit | $TOTAL02: qte |
Definition
Creates a non-tabstrip style dashboard, including charts and reports
BEGIN_DASHBOARD
option :
BEGIN
type : $NOTABSTRIP , title : ""
END
TabTitle : 'title 1 ', Ms4Script_Import : .......
TabTitle : 'title 2 ', FormMS4 : DrawGrid .......
FormPlus : theme : "blueopal" DrawPIE.......
TabTitle : "title 3 " , FormPlus : theme : "bootstrap" DrawRADAR, .......
....
END_DASHBOARD ;
Creates an RWD type dashboard including charts and reports (RWD : RESPONSIVE WEB DESIGN)
Use RESPONSIVE (RWD) instructions :
RWD_ROW,RWD_COL,<DIV...
SEE HELP UI
<Rwd_Row : 2 /* 2 : optional */
<Rwd_Col : lg:4 ,"text-left" :
<div $widget + $bg_primary + "no-padding" :
<div "class='p-m " :
<Text : "" , " Population by Province " > ,
<Text : "" , " China " > ,
> /* end div */
DBconnect {Ms4DB} (Lcurrentdb) ,
FormMorris : DrawPIE, title :"" ,
TYPE : $DONUT, FORMAT: "Th" use View ("[ms4TotalPopulByProvince]")
> /* end div */
> /* end col lg:4 */
<Rwd_Col : lg:8 ,"text-left" :
<div $widget + $bg_info + "no-padding" :
<div "class='p-m " :
<Text : "" , " Population by Province (TOP 15) " >
<Text : "" , " (BAR ) " >
<Text : "" , " China " >
> /* end div */
DBconnect{Ms4DB}(Lcurrentdb),
Ms4_Query{ms4db} option : into $MS4DBTMP
(" SELECT * from [ms4TotalPopulByProvince] order by "+
"TOTALThousandPopulationByProvince desc limit 15 " ) , ** TOP 15
DBconnect{Ms4DB}($MS4DBTMP),
FormMorris : DrawBar , title :"" ,TYPE : $BAR , FORMAT :"Th"
use View ($MS4VIEWDBTMP) >, /* end div */
> /* end col lg:8 */
>; /* end Row */
| Total messages | Posts | Comments |
| News | Likes | Notifications |
| Albums | Groups | Permissions |
| News | Likes | Notifications |
| Views | Followers | Charts |