Toggle navigation
Settings
Cancel changes
ID
A unique ID for the visualisation, used in the link
Title
Title displayed on top of the application
Logo
Data Source
AWS_Project_Analysis1.csv
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
AWS Spend Jul'17
Level
Dept
140421
L4
GIS
103389
L4
BlazeMeter
97927
L4
NBI US DevOps
48389
L3
CPO Other
41875
L4
RallyDev
31095
L3
CPO Other
26958
L4
RallyDev
21701
L3
CPO Other
14829
L3
CPO Other
13881
L4
GIS
10746
L4
RallyDev
8895
L3
CPO Other
8259
L3
CPO Other
5799
L4
RallyDev
5552
L3
NBI US DevOps
4831
L4
GIS
4655
L3
CA Services
4307
L4
RallyDev
4140
L2
Xceedium Presales
3266
L4
BlazeMeter
3246
L4
BlazeMeter
2574
L4
GIS
2298
L4
CPO Other
2136
L4
US PIM Dev
2126
L3
CPO Other
1915
L3
CPO Other
1376
L2
Xceedium Presales
1356
L2
Security Presales
1298
L2
EU & APJ Sales
1238
L2
Xceedium Presales
1204
L4
GIS
1157
L4
BlazeMeter
1121
L4
Automic
1087
L3
CA Services
1070
L3
US PIM Dev
1018
L4
CPO Other
895
L4
CPO Other
884
L3
US PIM Dev
817
L2
EU & APJ Sales
741
L2
EU & APJ Sales
647
L4
CPO
644
L2
Sales
598
L3
CPO
587
L4
BlazeMeter
536
L4
CPO
536
L2
Sales
524
L4
BlazeMeter
507
L2
Sales
489
L3
CPO
488
L3
CPO
Dynamic Columns
(Optional: can be used to create new columns based on the available columns in data)
Column Name
Formula
Add New Column
Date column
No date
Allowed time periods
Day
Week
Month
MTD
Quarter
QTD
Year
YTD
From start
Period
Group by columns
Level
Dept
AWS Spend Jul'17
Filter columns
AWS Spend Jul'17
Level
Dept
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
AWS Spend Jul'17
Level
Dept
count
sum
nunique
min
max
first
last
mean
median
1,000
1,000.0
1,000.00
100%
100.0%
100.00%
-
thousands
lakhs
millions
crores
billions
000 crores
trillions
lakh crores
milli
micro
AWS Spend Jul'17
Level
Dept
count
sum
nunique
min
max
first
last
mean
median
1,000
1,000.0
1,000.00
100%
100.0%
100.00%
-
thousands
lakhs
millions
crores
billions
000 crores
trillions
lakh crores
milli
micro
Add Size Metric
Colours
(ratios derived from metrics)
Name
Numerator
Denominator
Display format
Units
Colour
Min
Max
Stop values
Stop points
Ignore Outliers%
1
Total Departments
Total Spending
1
Total Departments
Total Spending
1,000
1,000.0
1,000.00
100%
100.0%
100.00%
-
thousands
lakhs
millions
crores
billions
000 crores
trillions
lakh crores
milli
micro
Add Color Field
Additional options »
Max. boxes
Max boxes in a treemap. Keep under 200 for speed.
Max. filter entries
Number of top entries to show in filter dropdown
Cache time (min)
Report won't be refreshed for this long
Screen width
Width of the screen. 0 for auto layout.
Treemap height %
Total height as a % of width.
Aspect ratio
Wider boxes (>1) or taller boxes (<1)
Max font size
Text inside boxes will not exceed this size
Roles with access
Space seperated
roles
that can view the data
Admin roles
Space seperated
roles
that can change this page (
admin
always can)
Calendar uses size
Instead of colouring calendar by colour metric, use size metric
Colour scale
Colours of the low, medium, high and invalid entries
Top and bottom tables
Show the top X and bottom Y items
Theme
v3
slate
flatly
Colour theme
Submit
Cancel changes
Delete application
(no undo)