License File Note
The Logi Info Server license file lgx120102.lic for this computer expired on 2025-07-08. Running under a grace period until 2025-07-15.
Click here
to visit Logi DevNet and learn more.
Getting Started
Layout
Containers
Grid
Media
Navigation
Content
Typography
Images and Figures
Tables
Components
Alerts
Badges
Breadcrumb
Buttons
Cards
Carousel
Collapse
Form Elements
Icons
Input Groups
KPIs
Lists
Modals
Progress Bars
Slide Panel
Tabs
Validation
Utilities
Borders
Display
Flex
Position
Sizing
Spacing
Extend
Animate Css
Bootstrap Select
Bootstrap TagsInput
Clipboard.js
DateRange Picker
Flipster
Lazy Data Table
Select2
Wait Panel
Charts
Bar
Bubble
Area
Combined
Crosstab
Funnel
Heatmap
Line
Pie
Polar
Pyramid
Scatter
Spline
Waterfall
Whisker
Sparkline
Gauges
Arc
Bar
Dial
Indicator
Maps
Google
Leaflet
Data Tables
Calculated Column
Basic Table
Crosstab Table
Data Grouping
User Inputs
Table Filter
Checkbox
Checkbox List
Combo List
Date Picker
Format
Grid
Radio Button
Related Select
Select List
Slider
Text
Logi Info Sample Center
Bootstrap 4.1 Theme
Bootstrap 4.1
Material
Data Groupings
Example
Ungrouped Data
Order ID
Cust ID
Ship To
Country
City
Freight
10248
VINET
Vins et alcools Chevalier
France
Reims
$32.38
10249
TOMSP
Toms Spezialitäten
Germany
Münster
$11.61
10250
HANAR
Hanari Carnes
Brazil
Rio de Janeiro
$65.83
10251
VICTE
Victuailles en stock
France
Lyon
$41.34
10252
SUPRD
Suprêmes délices
Belgium
Charleroi
$51.30
10253
HANAR
Hanari Carnes
Brazil
Rio de Janeiro
$58.17
10254
CHOPS
Chop-suey Chinese
Switzerland
Bern
$22.98
10255
RICSU
Richter Supermarkt
Switzerland
Genève
$148.33
10256
WELLI
Wellington Importadora
Brazil
Resende
$13.97
10257
HILAA
HILARION-Abastos
Venezuela
San Cristóbal
$81.91
10258
ERNSH
Ernst Handel
Austria
Graz
$140.51
10259
CENTC
Centro comercial Moctezuma
Mexico
México D.F.
$3.25
10260
OTTIK
Ottilies Käseladen
Germany
Köln
$55.09
10261
QUEDE
Que Delícia
Brazil
Rio de Janeiro
$3.05
Data grouped by Customer ID and counted
Cust ID
Ship To
Country
City
# Orders
ALFKI
Alfreds Futterkiste
Germany
Berlin
6
ANATR
Ana Trujillo Emparedados y helados
Mexico
México D.F.
4
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
7
AROUT
Around the Horn
UK
Colchester
13
BERGS
Berglunds snabbköp
Sweden
Luleå
18
BLAUS
Blauer See Delikatessen
Germany
Mannheim
7
BLONP
Blondel père et fils
France
Strasbourg
11
BOLID
Bólido Comidas preparadas
Spain
Madrid
3
BONAP
Bon app'
France
Marseille
17
BOTTM
Bottom-Dollar Markets
Canada
Tsawassen
14
BSBEV
B's Beverages
UK
London
10
CACTU
Cactus Comidas para llevar
Argentina
Buenos Aires
6
CENTC
Centro comercial Moctezuma
Mexico
México D.F.
1
CHOPS
Chop-suey Chinese
Switzerland
Bern
8
Data grouped by Customer ID and summed
Cust ID
Ship To
Country
City
Total
ALFKI
Alfreds Futterkiste
Germany
Berlin
$4,273.00
ANATR
Ana Trujillo Emparedados y helados
Mexico
México D.F.
$1,402.95
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$7,023.98
AROUT
Around the Horn
UK
Colchester
$13,390.65
BERGS
Berglunds snabbköp
Sweden
Luleå
$24,927.58
BLAUS
Blauer See Delikatessen
Germany
Mannheim
$3,239.80
BLONP
Blondel père et fils
France
Strasbourg
$18,534.08
BOLID
Bólido Comidas preparadas
Spain
Madrid
$4,232.85
BONAP
Bon app'
France
Marseille
$21,963.24
BOTTM
Bottom-Dollar Markets
Canada
Tsawassen
$20,801.61
BSBEV
B's Beverages
UK
London
$6,089.90
CACTU
Cactus Comidas para llevar
Argentina
Buenos Aires
$1,814.80
CENTC
Centro comercial Moctezuma
Mexico
México D.F.
$100.80
CHOPS
Chop-suey Chinese
Switzerland
Bern
$12,348.88
Data grouped by Customer ID, with all rows retained
Order ID
Cust ID
Ship To
Country
City
Freight
10643
ALFKI
Alfreds Futterkiste
Germany
Berlin
$29.46
10692
ALFKI
Alfred's Futterkiste
Germany
Berlin
$61.02
10702
ALFKI
Alfred's Futterkiste
Germany
Berlin
$23.94
10835
ALFKI
Alfred's Futterkiste
Germany
Berlin
$69.53
10952
ALFKI
Alfred's Futterkiste
Germany
Berlin
$40.42
11011
ALFKI
Alfred's Futterkiste
Germany
Berlin
$1.21
10308
ANATR
Ana Trujillo Emparedados y helados
Mexico
México D.F.
$1.61
10625
ANATR
Ana Trujillo Emparedados y helados
Mexico
México D.F.
$43.90
10759
ANATR
Ana Trujillo Emparedados y helados
Mexico
México D.F.
$11.99
10926
ANATR
Ana Trujillo Emparedados y helados
Mexico
México D.F.
$39.92
10365
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$22.00
10507
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$47.45
10535
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$15.64
10573
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$84.84
Data grouped by Customer ID, with only distinct rows retained
Order ID
Cust ID
Ship To
Country
City
Freight
10643
ALFKI
Alfreds Futterkiste
Germany
Berlin
$29.46
10308
ANATR
Ana Trujillo Emparedados y helados
Mexico
México D.F.
$1.61
10365
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$22.00
10355
AROUT
Around the Horn
UK
Colchester
$41.95
10278
BERGS
Berglunds snabbköp
Sweden
Luleå
$92.69
10501
BLAUS
Blauer See Delikatessen
Germany
Mannheim
$8.85
10265
BLONP
Blondel père et fils
France
Strasbourg
$55.28
10326
BOLID
Bólido Comidas preparadas
Spain
Madrid
$77.92
10331
BONAP
Bon app'
France
Marseille
$10.19
10389
BOTTM
Bottom-Dollar Markets
Canada
Tsawassen
$47.42
10289
BSBEV
B's Beverages
UK
London
$22.77
10521
CACTU
Cactus Comidas para llevar
Argentina
Buenos Aires
$17.22
10259
CENTC
Centro comercial Moctezuma
Mexico
México D.F.
$3.25
10254
CHOPS
Chop-suey Chinese
Switzerland
Bern
$22.98
Data in hierarchical groupings, on Customer ID and Order ID
Cust ID
Customer Name
Customer Total
Order ID
Order Date
Order Total
Product ID
Unit Price
Quantity
Unit Total
ALFKI
Alfreds Futterkiste
$4,596.20
10643
8/25/2011
$1,086.00
28
$45.60
15
$684.00
39
$18.00
21
$378.00
46
$12.00
2
$24.00
10692
10/3/2011
$878.00
63
$43.90
20
$878.00
10702
10/13/2011
$330.00
3
$10.00
6
$60.00
76
$18.00
15
$270.00
10835
1/15/2012
$851.00
59
$55.00
15
$825.00
77
$13.00
2
$26.00
10952
3/16/2012
$491.20
28
$45.60
2
$91.20
6
$25.00
16
$400.00
11011
4/9/2012
$960.00
58
$13.25
40
$530.00
71
$21.50
20
$430.00
ANATR
Ana Trujillo Emparedados y helados
$1,402.95
10308
9/18/2010
$88.80
69
$28.80
1
$28.80
70
$12.00
5
$60.00
10625
8/8/2011
$479.75
14
$23.25
3
$69.75
42
$14.00
5
$70.00
60
$34.00
10
$340.00
10759
11/28/2011
$320.00
32
$32.00
10
$320.00
10926
3/4/2012
$514.40
11
$21.00
2
$42.00
13
$6.00
10
$60.00
19
$9.20
7
$64.40
72
$34.80
10
$348.00
ANTON
Antonio Moreno Taquería
$7,515.35
10365
11/27/2010
$403.20
11
$16.80
24
$403.20
10507
4/15/2011
$881.25
43
$46.00
15
$690.00
48
$12.75
15
$191.25
10535
5/13/2011
$2,156.50
11
$21.00
50
$1,050.00
40
$18.40
10
$184.00
57
$19.50
5
$97.50
59
$55.00
15
$825.00
10573
6/19/2011
$2,082.00
17
$39.00
18
$702.00
34
$14.00
40
$560.00
53
$32.80
25
$820.00
10677
9/22/2011
$956.90
26
$31.23
30
$936.90
33
$2.50
8
$20.00
10682
9/25/2011
$375.50
33
$2.50
30
$75.00
66
$17.00
4
$68.00
75
$7.75
30
$232.50
10856
1/28/2012
$660.00
2
$19.00
20
$380.00
42
$14.00
20
$280.00
Data grouped first by Country and then by City
Order ID
Cust ID
Ship To
Country
City
Freight
10258
ERNSH
Ernst Handel
Austria
Graz
$140.51
10252
SUPRD
Suprêmes délices
Belgium
Charleroi
$51.30
10253
HANAR
Hanari Carnes
Brazil
Rio de Janeiro
$58.17
10256
WELLI
Wellington Importadora
Brazil
Resende
$13.97
10250
HANAR
Hanari Carnes
Brazil
Rio de Janeiro
$65.83
10261
QUEDE
Que Delícia
Brazil
Rio de Janeiro
$3.05
10251
VICTE
Victuailles en stock
France
Lyon
$41.34
10248
VINET
Vins et alcools Chevalier
France
Reims
$32.38
10260
OTTIK
Ottilies Käseladen
Germany
Köln
$55.09
10249
TOMSP
Toms Spezialitäten
Germany
Münster
$11.61
10259
CENTC
Centro comercial Moctezuma
Mexico
México D.F.
$3.25
10254
CHOPS
Chop-suey Chinese
Switzerland
Bern
$22.98
10255
RICSU
Richter Supermarkt
Switzerland
Genève
$148.33
10257
HILAA
HILARION-Abastos
Venezuela
San Cristóbal
$81.91
Data grouped and summarized, with all rows retained and group subtotals
Order ID
Cust ID
Ship To
Country
City
Freight
10643
ALFKI
Alfreds Futterkiste
Germany
Berlin
$29.46
10692
ALFKI
Alfred's Futterkiste
Germany
Berlin
$61.02
10702
ALFKI
Alfred's Futterkiste
Germany
Berlin
$23.94
10835
ALFKI
Alfred's Futterkiste
Germany
Berlin
$69.53
10952
ALFKI
Alfred's Futterkiste
Germany
Berlin
$40.42
11011
ALFKI
Alfred's Futterkiste
Germany
Berlin
$1.21
SubTotal
$225.58
10308
ANATR
Ana Trujillo Emparedados y helados
Mexico
México D.F.
$1.61
10625
ANATR
Ana Trujillo Emparedados y helados
Mexico
México D.F.
$43.90
10759
ANATR
Ana Trujillo Emparedados y helados
Mexico
México D.F.
$11.99
10926
ANATR
Ana Trujillo Emparedados y helados
Mexico
México D.F.
$39.92
SubTotal
$97.42
10365
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$22.00
10507
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$47.45
10535
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$15.64
10573
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$84.84
10677
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$4.03
10682
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$36.13
10856
ANTON
Antonio Moreno Taquería
Mexico
México D.F.
$58.43
SubTotal
$268.52
Total
$591.52
© Logi Analytics
Interested to see how this application was built?
Download Source