MS4BI HELP 2022

by MS4script
4-DASHBOARD\Basic
406-01-DashBoardSimple.ms4
406-DashBoardFormKSimple.ms4
406-DashBoardFormKSimpleTesting.ms4
406-DashBoardNOTabChartSimple.ms4
406-NOTabChartSimple.ms4
407-NOTabChartSimpleFormSandI.ms4
407-NOTabFormKandPchart.ms4
408-NOTabChartSimpleSetting.ms4
408-NOTabFormKSETTING.ms4
409-NOTabChartSimpleHeigthWith.ms4
409-NOTabFormKHeigthWidth.ms4
410-02-NOTabALLFORM-4cols.ms4
416-NOTabFormExcelSimple.ms4
440-TabFormKSimpleALL.ms4
456-TabForm-ReportAll.ms4
472-DashboardReportEXCELScriptWeb.ms4
480-01-ReportDesignSimpleTabDrawReport.ms4
480-ReportDesignSimpleTab.ms4
481-ReportDesignnoTabstrip.ms4
721-DashBoardFrameWindowMore.ms4
4-DASHBOARD
455-TabFormAll-IMPORTANT.ms4
1300-10-UI-ThemeDashboard.ms4
472-DashboardReportEXCELScriptWeb.ms4
1300-98-00-DashboardProto1Responsive.ms4
823-RWD-ChartStandard.ms4
1300-70-UI-Widgets.ms4
GET-08-02DashboardRWD.ms4
MS4BI Trial Version
MG Planete :
https://getms4bi.com

MS4BI by Mandragore Planete - CHINA - Population by Province (example !) 07/15/22 16:17:53

Nb Province :
26




HIGHEST PROVINCE: Guangdong

26135

(thousand people)

LOWEST PROVINCE: Qinghai

1070

(thousand people)
New messages

260




Population by Province

( GEOMAP ) China

TOP 10

China

Population by City

( GEOMAP LEAFLET ) China

Population by Province

( PIE )

China

Population by Province

China

TOP 10

New messages

26

  A B C D E F G
1 SNO 都市名 英語 Population 備考 Latitude Longitude
2 1 上海市 Shanghai 23,019,000 仏山市を含む 31.267401 121.522179
3 2 広州市 Canton 15,300,000 仏山市を含む 23.1166700 113.2500000
4 3 北京市 Beijing 21,500,000 仏山市を含む 39.913818 116.363625
5 4 深セン市 Shenzhen 9,400,000 仏山市を含む 22.731857 114.255753
6 5 武漢市 Wuhan 9,000,000 仏山市を含む 30.5833300 114.2666700

Basic Panel & Body & Footer YELLOW

×Info! This message box could provide info or require positive action.
Warning! You should read this message
×

Analysis ... the latest information

# Date Time Amount
fuller 10/21/2013 3:29 PM $321.33
leverling 10/21/2013 3:03 PM $724.17
Davolio 10/21/2013 3:00 PM $23.71
Peacock 10/21/2013 2:49 PM $8345.23
King 10/21/2013 2:23 PM $245.12
Callahan 10/21/2013 2:15 PM $5663.54
leverling 10/21/2013 2:13 PM $943.45

  • My Aggregate Report
  • Pie
  • My Excel Consolidation
  • Radar
  • My Report Design 2
  • My Grid: Nb City/Province ..
  • My Grid: Nb City,Popula..
  • My Grid AVG Population..
  • Informations
×

Step 5 : Aggregate Reporting : hierarchy Win&Web

UNICODE : by city --> Drag & Drop : Column
Aggregate Functions

Toolbar : Export

MS4 DB : ms4LangConsolidation China/Japan : 英語 = b.city :Drag & Drop Column
RADAR Line by province
×

Step 7 : Design Reporting :
Level & Automatic calculation Win&Web


TOTAL CITY :

66

TOTAL PROVINCE :

26

TOTAL POPULATION : people

189204000
Generate by Mandragore Planete

Mandragore Planete - Trial Version : Report : Population by Country

07/15/2216:17:56 ( update style Css : \MandragorePlanete\MS4BI\zInclude\css\StyleReportDesign\xxxxxxxxxxxx.css)

HEADER GROUP LEVEL 01 :

01 Province ..: AnhuiAnhui

End_Group_Break 02 :

02 City : Huainan$Total01 : 1190000 total City/Province : 1

End_Group_Break 02 :

02 City : Suzhou$Total01 : 2500000 total City/Province : 2

End_Group_Break01 :

01 Province : Total Population : Anhui 3690000total city2
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: Běijīng ShìBěijīng Shì

End_Group_Break 02 :

02 City : Beijing$Total01 : 21500000 total City/Province : 1

End_Group_Break01 :

01 Province : Total Population : Běijīng Shì21500000total city1
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: FujianFujian

End_Group_Break 02 :

02 City : Fuzhou$Total01 : 3225000 total City/Province : 1

End_Group_Break 02 :

02 City : Quanzhou$Total01 : 2200000 total City/Province : 2

End_Group_Break 02 :

02 City : Xiamen$Total01 : 1990000 total City/Province : 3

End_Group_Break01 :

01 Province : Total Population : Fujian 7415000total city3
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: GansuGansu

End_Group_Break 02 :

02 City : Lanzhou$Total01 : 2300000 total City/Province : 1

End_Group_Break01 :

01 Province : Total Population : Gansu 2300000total city1
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: GuangdongGuangdong

End_Group_Break 02 :

02 City : Dongguan$Total01 : 5600000 total City/Province : 1

End_Group_Break 02 :

02 City : Huizhou$Total01 : 1400000 total City/Province : 2

End_Group_Break 02 :

02 City : Jiangmen$Total01 : 1160000 total City/Province : 3

End_Group_Break 02 :

02 City : Shantou$Total01 : 4075000 total City/Province : 4

End_Group_Break 02 :

02 City : Shenzhen$Total01 : 9400000 total City/Province : 5

End_Group_Break 02 :

02 City : Zhanjiang$Total01 : 1100000 total City/Province : 6

End_Group_Break 02 :

02 City : Zhongshan$Total01 : 1960000 total City/Province : 7

End_Group_Break 02 :

02 City : Zhuhai$Total01 : 1440000 total City/Province : 8

End_Group_Break01 :

01 Province : Total Population : Guangdong26135000total city8
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: GuangxiGuangxi

End_Group_Break 02 :

02 City : Liuzhou$Total01 : 1300000 total City/Province : 1

End_Group_Break 02 :

02 City : Nanning$Total01 : 2075000 total City/Province : 2

End_Group_Break01 :

01 Province : Total Population : Guangxi 3375000total city2
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: GuizhouGuizhou

End_Group_Break 02 :

02 City : Guiyang$Total01 : 2350000 total City/Province : 1

End_Group_Break01 :

01 Province : Total Population : Guizhou 2350000total city1
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: HainanHainan

End_Group_Break 02 :

02 City : Haikou$Total01 : 1240000 total City/Province : 1

End_Group_Break01 :

01 Province : Total Population : Hainan 1240000total city1
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: HebeiHebei

End_Group_Break 02 :

02 City : Baoding$Total01 : 1100000 total City/Province : 1

End_Group_Break 02 :

02 City : Shijiazhuang$Total01 : 2375000 total City/Province : 2

End_Group_Break 02 :

02 City : Tangshan$Total01 : 1970000 total City/Province : 3

End_Group_Break 02 :

02 City : Zhangjiakou$Total01 : 1030000 total City/Province : 4

End_Group_Break01 :

01 Province : Total Population : Hebei 6475000total city4
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: HeilongjiangHeilongjiang

End_Group_Break 02 :

02 City : Daqing$Total01 : 1320000 total City/Province : 1

End_Group_Break 02 :

02 City : Harbin$Total01 : 4375000 total City/Province : 2

End_Group_Break 02 :

02 City : Jixi$Total01 : 1060000 total City/Province : 3

End_Group_Break 02 :

02 City : Mudanjiang$Total01 : 1040000 total City/Province : 4

End_Group_Break 02 :

02 City : Qiqihar$Total01 : 1520000 total City/Province : 5

End_Group_Break01 :

01 Province : Total Population : Heilongjiang 9315000total city5
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: HenanHenan

End_Group_Break 02 :

02 City : Luoyang$Total01 : 1540000 total City/Province : 1

End_Group_Break 02 :

02 City : Pingdingshan$Total01 : 1050000 total City/Province : 2

End_Group_Break 02 :

02 City : Zhengzhou$Total01 : 3125000 total City/Province : 3

End_Group_Break01 :

01 Province : Total Population : Henan 5715000total city3
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: HubeiHubei

End_Group_Break 02 :

02 City : Wuhan$Total01 : 9000000 total City/Province : 1

End_Group_Break 02 :

02 City : Yichang$Total01 : 1050000 total City/Province : 2

End_Group_Break01 :

01 Province : Total Population : Hubei10050000total city2
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: HunanHunan

End_Group_Break 02 :

02 City : Changsha$Total01 : 2650000 total City/Province : 1

End_Group_Break 02 :

02 City : Yueyang$Total01 : 1020000 total City/Province : 2

End_Group_Break 02 :

02 City : Zhuzhou$Total01 : 1010000 total City/Province : 3

End_Group_Break01 :

01 Province : Total Population : Hunan 4680000total city3
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: Inner MongoliaInner Mongolia

End_Group_Break 02 :

02 City : Baotou$Total01 : 1870000 total City/Province : 1

End_Group_Break01 :

01 Province : Total Population : Inner Mongolia 1870000total city1
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: JiangsuJiangsu

End_Group_Break 02 :

02 City : Changzhou$Total01 : 1760000 total City/Province : 1

End_Group_Break 02 :

02 City : Taizhou$Total01 : 1500000 total City/Province : 2

End_Group_Break 02 :

02 City : Wuxi$Total01 : 2175000 total City/Province : 3

End_Group_Break 02 :

02 City : Xuzhou$Total01 : 1620000 total City/Province : 4

End_Group_Break 02 :

02 City : Yancheng$Total01 : 1090000 total City/Province : 5

End_Group_Break 02 :

02 City : Yangzhou$Total01 : 1010000 total City/Province : 6

End_Group_Break01 :

01 Province : Total Population : Jiangsu 9155000total city6
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: JiangxiJiangxi

End_Group_Break 02 :

02 City : Nanchang$Total01 : 2175000 total City/Province : 1

End_Group_Break01 :

01 Province : Total Population : Jiangxi 2175000total city1
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: JilinJilin

End_Group_Break 02 :

02 City : Changchun$Total01 : 3425000 total City/Province : 1

End_Group_Break 02 :

02 City : Jilin$Total01 : 1880000 total City/Province : 2

End_Group_Break01 :

01 Province : Total Population : Jilin 5305000total city2
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: LiaoningLiaoning

End_Group_Break 02 :

02 City : Anshan$Total01 : 2225000 total City/Province : 1

End_Group_Break 02 :

02 City : Fushun$Total01 : 1420000 total City/Province : 2

End_Group_Break 02 :

02 City : Shenyang$Total01 : 5150000 total City/Province : 3

End_Group_Break01 :

01 Province : Total Population : Liaoning 8795000total city3
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: QinghaiQinghai

End_Group_Break 02 :

02 City : Xining$Total01 : 1070000 total City/Province : 1

End_Group_Break01 :

01 Province : Total Population : Qinghai 1070000total city1
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: ShaanxiShaanxi

End_Group_Break 02 :

02 City : Xianyang$Total01 : 1430000 total City/Province : 1

End_Group_Break01 :

01 Province : Total Population : Shaanxi 1430000total city1
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: ShandongShandong

End_Group_Break 02 :

02 City : Jinan$Total01 : 3375000 total City/Province : 1

End_Group_Break 02 :

02 City : Jining$Total01 : 1030000 total City/Province : 2

End_Group_Break 02 :

02 City : Linyi$Total01 : 1380000 total City/Province : 3

End_Group_Break 02 :

02 City : Tai'an$Total01 : 1090000 total City/Province : 4

End_Group_Break 02 :

02 City : Weifang$Total01 : 1470000 total City/Province : 5

End_Group_Break 02 :

02 City : Yantai$Total01 : 1570000 total City/Province : 6

End_Group_Break 02 :

02 City : Zaozhuang$Total01 : 1030000 total City/Province : 7

End_Group_Break 02 :

02 City : Zibo$Total01 : 2325000 total City/Province : 8

End_Group_Break01 :

01 Province : Total Population : Shandong13270000total city8
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: Shanghai ShìShanghai Shì

End_Group_Break 02 :

02 City : Shanghai$Total01 : 23019000 total City/Province : 1

End_Group_Break01 :

01 Province : Total Population : Shanghai Shì23019000total city1
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: ShanxiShanxi

End_Group_Break 02 :

02 City : Datong$Total01 : 1230000 total City/Province : 1

End_Group_Break 02 :

02 City : Taiyuan$Total01 : 3175000 total City/Province : 2

End_Group_Break01 :

01 Province : Total Population : Shanxi 4405000total city2
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: YunnanYunnan

End_Group_Break 02 :

02 City : Kunming$Total01 : 3175000 total City/Province : 1

End_Group_Break01 :

01 Province : Total Population : Yunnan 3175000total city1
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: ZhejiangZhejiang

End_Group_Break 02 :

02 City : Ningbo$Total01 : 2125000 total City/Province : 1

End_Group_Break 02 :

02 City : Wenzhou$Total01 : 1970000 total City/Province : 2

End_Group_Break01 :

01 Province : Total Population : Zhejiang 4095000total city2
**************************************

HEADER GROUP LEVEL 01 :

01 Province ..: autonomousautonomous

End_Group_Break 02 :

02 City : Hong Kong$Total01 : 7200000 total City/Province : 1

End_Group_Break01 :

01 Province : Total Population : autonomous 7200000total city1
**************************************

TOTAL CITY :

66

TOTAL PROVINCE :

26

TOTAL POPULATION : people

189204000
MS4 DB : View 2: nb city/province : Drag & Drop Column
MS4 DB : View 3 : nb city ,province,population
MS4 DB : View 4 : average population

Trial Version : Informations

Execution Time

START : 2022-07-1516:17:55
END : 2022-07-1516:17:59

mgplanete.com



contact@mgplanete.com



    ' The About Tab will not appear on the licensed product

400

10

420

462

610

New messages

260

PBE

Founder of Groupe MS4 BI profile
100 Tweets | 350 Following | 610 Followers

Contact Mandragore Planete

Lorem Ipsum is simply dummy text of the printing and typesetting industry.

HIGHEST PROVINCE: Guangdong

26135

(thousand people)

XXXXXXXXXXX

Province

612

Thunder

amount

MG PLANETE

  • contact@mgplanete.com
  • 15 rue des Halles 75001 PARIS FR
  • Contact: 00 33 (0)1 76 46 09 83

47

Notification

Error detected

520

Likes

amount

Alarm

Do

something

TOP 10

Total messages Posts Comments
News Likes Notifications
Albums Groups Permissions
Memory 10/200 GB
Bandwidth 20 GB
Activity 73%


HeadQuarter

( GEOMAP LEAFLET ) MG