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
Deficit.xlsx
CSV
Excel
Database
DB Type
MySQL
Postgress
Oracle
SQL Server
Host
Port
Database
Username
Password
Table
Test Connection
Combined State
Andhra Pradesh
% Increase
AP Fiscal Deficit
Telangana
% Increase.1
TS Fiscal Deficit
161348.0
93582
nan
12255
67766
nan
8874
nan
111824
19.5
12064
100637
48.5
17000
nan
113049
1.09
17584
115689
14.95
16969
nan
135689
20.02
20457
130415
12.73
23467
nan
157000
15.7
23054
149646
14.75
26096
nan
191000
21.66
24205
174453
16.58
29077
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
Combined State
Andhra Pradesh
% Increase
AP Fiscal Deficit
Telangana
% Increase.1
TS Fiscal Deficit
Filter columns
Combined State
Andhra Pradesh
% Increase
AP Fiscal Deficit
Telangana
% Increase.1
TS Fiscal Deficit
Metrics
(can be used for size, and to derive colours)
Name
Field
Aggregation
Display format
Units
Combined State
Andhra Pradesh
% Increase
AP Fiscal Deficit
Telangana
% Increase.1
TS Fiscal Deficit
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
abc
1
abc
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)