Datylon uses cookies

We use cookies to ensure you get the best experience in your interaction with our website. Cookies help to provide a more personalized experience and relevant advertising for you, and web analytics for us. To learn more, and to see a full list of cookies we use, check out our Cookie Policy.
Manage settingsAllow all cookies
Manage settings

Cookies are small text files that can be used by websites to make a user's experience more efficient.

The law states that we can store cookies on your device if they are strictly necessary for the operation of this site. For all other types of cookies we need your permission.

This site uses different types of cookies. Some cookies are placed by third party services that appear on our pages.

You can at any time change or withdraw your consent via the Cookie Policy on our website.

Learn more about who we are, how you can contact us and how we process personal data in our Privacy Policy.

Please state your consent ID and date when you contact us regarding your consent.



Your consent applies to the following domains: www.datylon.com, help.datylon.com, insights.datylon.com

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.Preference cookies enable a website to remember information that changes the way the website behaves or looks, like your preferred language or the region that you are in.Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.
Allow selection
Dataset
 
A
B
C
D
E
F
G
H
I
J
1
MeasuresWinter ValueWinter TargetSpring ValueSpring TargetSummer ValueSummer TargetAutumn ValueAutumn Target
2
02100016700226001720026200198002370018400
3
15000
4
20000
5
25000
6
30000
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
 
A
B
C
D
E
F
G
H
I
J
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
 
[{"postScriptName":"PTSans-Bold","fullname":"PT Sans Bold","style":"Bold","family":"PT Sans"}] Winter Spring Summer Autumn Seasonal water consumption 0 litres15000 litres20000 litres25000 litres30000 litres21000 litres16700 litres{"id":"com.datylon.bulletchart2","version":"1.8","name":"Winter","style":{"x":64.5,"y":191.9999999999991,"width":287.5,"height":576,"margin":{"top":20,"right":100,"bottom":20,"left":100},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0}},"plot-background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0}},"chart-orientation":"vertical","ranges":{"ranges":"Values From Data","color":{"type":"palette","solid":{"type":"RGBA","cmyka":{"c":0,"m":0,"y":0,"k":0,"a":1},"rgba":{"r":255,"g":255,"b":255,"a":1}},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":195,"g":196,"b":201,"a":1},"cmyka":null},"direction":0},"palette":{"applying-type":"NORMAL","palette":[{"type":"RGBA","rgba":{"r":247,"g":251,"b":255,"a":0.94},"cmyka":null},{"type":"RGBA","rgba":{"r":195,"g":219,"b":238,"a":0.94}},{"type":"RGBA","rgba":{"r":109,"g":174,"b":213,"a":0.94}},{"type":"RGBA","rgba":{"r":34,"g":113,"b":180,"a":0.94}},{"type":"RGBA","rgba":{"r":8,"g":48,"b":107,"a":0.94}}],"reversed":true,"type":"SEQUENTIAL","numerical":null}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"horizontal-rounding":0,"vertical-rounding":0,"round-all-corners":false,"size":{"type":"relative","width":100},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"labels":{"visible":true,"horizontal-offset":5,"vertical-offset":0,"rotation":0,"horizontal-alignment":"left","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"show":"all","anchor-point":"Bar: bottom","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"bar":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":63,"g":81,"b":181,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":0,"g":150,"b":136,"a":1},"cmyka":null},"direction":0}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":120,"g":120,"b":120,"a":1},"cmyka":null}},"width":0,"dash":"none"},"horizontal-rounding":0,"vertical-rounding":0,"round-all-corners":true,"size":{"type":"relative","width":30},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"labels":{"visible":true,"horizontal-offset":-50,"vertical-offset":0,"rotation":0,"horizontal-alignment":"right","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"anchor-point":"start","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"target":{"visible":true,"symbols":{"icon":"Line","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":131,"g":207,"b":205,"a":1},"cmyka":null}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":229,"g":229,"b":229,"a":1},"cmyka":null},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":195,"g":196,"b":201,"a":1},"cmyka":null},"direction":0}},"width":2.9999,"dash":"none"},"size":{"width":18,"height":18,"linked":false},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"line-size":{"type":"relative","length":100}},"labels":{"visible":true,"horizontal-offset":-50,"vertical-offset":0,"rotation":0,"horizontal-alignment":"right","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"target-mark-anchor":"center","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"numerical-axis":{"visible":false,"reverse":false,"flip-location":false,"locate-at-zero":false,"offset":0,"hide-zero":false,"ticks-number":5,"line":{"visible":true,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":1.0001,"dash":"none"}},"major-ticks-and-grid":{"visible":false,"ticks":{"visible":false,"length":0,"offset":0,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"grid":{"visible":false,"above":false,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"custom-ticks-amount":{"visible":false,"ticks-interval":0}},"minor-ticks-and-grid":{"visible":false,"ticks":{"visible":false,"length":0,"offset":0,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"grid":{"visible":false,"above":false,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"amount":0},"labels":{"visible":true,"horizontal-offset":0,"vertical-offset":0,"rotation":0,"horizontal-alignment":"center","vertical-alignment":"center","font":{"family":"PTSans-Regular","size":16,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":"","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}}},"number-format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false},"type":"numerical"}},"dataSourceView":{"dataSource":{"name":"main template datasheet container","type":"com.datylon.dbidatasource.workbookdatasource","location":""},"viewDefinition":{"name":"view","from":"Dataset","orientation":1,"header":true,"series":[{"name":"New series 1","data":[{"name":"measures","from":0,"datatype":1,"fromIx":0},{"name":"value","from":1,"datatype":1,"fromIx":1},{"name":"target","from":2,"datatype":1,"fromIx":2},{"name":"custom-range-labels","from":-1,"datatype":0,"fromIx":-1}],"properties":{}}]}}} 0 litres15000 litres20000 litres25000 litres30000 litres22600 litres17200 litres{"id":"com.datylon.bulletchart2","version":"1.8","name":"Spring","style":{"x":353.5,"y":191.4999999999991,"width":286.5,"height":576,"margin":{"top":20,"right":100,"bottom":20,"left":100},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0}},"plot-background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0}},"chart-orientation":"vertical","ranges":{"ranges":"Values From Data","color":{"type":"palette","solid":{"type":"RGBA","cmyka":{"c":0,"m":0,"y":0,"k":0,"a":1},"rgba":{"r":255,"g":255,"b":255,"a":1}},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":195,"g":196,"b":201,"a":1},"cmyka":null},"direction":0},"palette":{"applying-type":"NORMAL","palette":[{"type":"RGBA","rgba":{"r":255,"g":247,"b":251,"a":1},"cmyka":null},{"type":"RGBA","rgba":{"r":206,"g":209,"b":230,"a":1}},{"type":"RGBA","rgba":{"r":105,"g":168,"b":207,"a":1}},{"type":"RGBA","rgba":{"r":11,"g":128,"b":139,"a":1}},{"type":"RGBA","rgba":{"r":1,"g":70,"b":54,"a":1}}],"reversed":true,"type":"SEQUENTIAL","numerical":null}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"horizontal-rounding":0,"vertical-rounding":0,"round-all-corners":false,"size":{"type":"relative","width":100},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"labels":{"visible":true,"horizontal-offset":5,"vertical-offset":0,"rotation":0,"horizontal-alignment":"left","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"show":"all","anchor-point":"Bar: bottom","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"bar":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":63,"g":81,"b":181,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":0,"g":150,"b":136,"a":1},"cmyka":null},"direction":0}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":120,"g":120,"b":120,"a":1},"cmyka":null}},"width":0,"dash":"none"},"horizontal-rounding":0,"vertical-rounding":0,"round-all-corners":true,"size":{"type":"relative","width":30},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"labels":{"visible":true,"horizontal-offset":-50,"vertical-offset":0,"rotation":0,"horizontal-alignment":"right","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"anchor-point":"start","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"target":{"visible":true,"symbols":{"icon":"Line","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":131,"g":207,"b":205,"a":1},"cmyka":null}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":229,"g":229,"b":229,"a":1},"cmyka":null},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":195,"g":196,"b":201,"a":1},"cmyka":null},"direction":0}},"width":2.9999,"dash":"none"},"size":{"width":18,"height":18,"linked":false},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"line-size":{"type":"relative","length":100}},"labels":{"visible":true,"horizontal-offset":-50,"vertical-offset":0,"rotation":0,"horizontal-alignment":"right","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"target-mark-anchor":"center","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"numerical-axis":{"visible":false,"reverse":false,"flip-location":false,"locate-at-zero":false,"offset":0,"hide-zero":false,"ticks-number":5,"line":{"visible":true,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":1.0001,"dash":"none"}},"major-ticks-and-grid":{"visible":false,"ticks":{"visible":false,"length":0,"offset":0,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"grid":{"visible":false,"above":false,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"custom-ticks-amount":{"visible":false,"ticks-interval":0}},"minor-ticks-and-grid":{"visible":false,"ticks":{"visible":false,"length":0,"offset":0,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"grid":{"visible":false,"above":false,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"amount":0},"labels":{"visible":true,"horizontal-offset":0,"vertical-offset":0,"rotation":0,"horizontal-alignment":"center","vertical-alignment":"center","font":{"family":"PTSans-Regular","size":16,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":"","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}}},"number-format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false},"type":"numerical"}},"dataSourceView":{"dataSource":{"name":"main template datasheet container","type":"com.datylon.dbidatasource.workbookdatasource","location":""},"viewDefinition":{"name":"view","from":"Dataset","orientation":1,"header":true,"series":[{"name":"New series 1","data":[{"name":"measures","from":0,"datatype":1,"fromIx":0},{"name":"value","from":3,"datatype":1,"fromIx":3},{"name":"target","from":4,"datatype":1,"fromIx":4},{"name":"custom-range-labels","from":-1,"datatype":0,"fromIx":-1}],"properties":{}}]}}} 0 litres15000 litres20000 litres25000 litres30000 litres26200 litres19800 litres{"id":"com.datylon.bulletchart2","version":"1.8","name":"Summer","style":{"x":640.5,"y":191.9999999999991,"width":286,"height":576,"margin":{"top":20,"right":100,"bottom":20,"left":100},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0}},"plot-background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0}},"chart-orientation":"vertical","ranges":{"ranges":"Values From Data","color":{"type":"palette","solid":{"type":"RGBA","cmyka":{"c":0,"m":0,"y":0,"k":0,"a":1},"rgba":{"r":255,"g":255,"b":255,"a":1}},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":195,"g":196,"b":201,"a":1},"cmyka":null},"direction":0},"palette":{"applying-type":"NORMAL","palette":[{"type":"RGBA","rgba":{"r":255,"g":255,"b":229,"a":1},"cmyka":null},{"type":"RGBA","rgba":{"r":254,"g":225,"b":141,"a":1}},{"type":"RGBA","rgba":{"r":251,"g":153,"b":44,"a":1}},{"type":"RGBA","rgba":{"r":201,"g":78,"b":5,"a":1}},{"type":"RGBA","rgba":{"r":102,"g":37,"b":6,"a":1}}],"reversed":true,"type":"SEQUENTIAL","numerical":null}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"horizontal-rounding":0,"vertical-rounding":0,"round-all-corners":false,"size":{"type":"relative","width":100},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"labels":{"visible":true,"horizontal-offset":5,"vertical-offset":0,"rotation":0,"horizontal-alignment":"left","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"show":"all","anchor-point":"Bar: bottom","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"bar":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":63,"g":81,"b":181,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":0,"g":150,"b":136,"a":1},"cmyka":null},"direction":0}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":120,"g":120,"b":120,"a":1},"cmyka":null}},"width":0,"dash":"none"},"horizontal-rounding":0,"vertical-rounding":0,"round-all-corners":true,"size":{"type":"relative","width":30},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"labels":{"visible":true,"horizontal-offset":-50,"vertical-offset":0,"rotation":0,"horizontal-alignment":"right","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"anchor-point":"start","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"target":{"visible":true,"symbols":{"icon":"Line","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":131,"g":207,"b":205,"a":1},"cmyka":null}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":229,"g":229,"b":229,"a":1},"cmyka":null},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":195,"g":196,"b":201,"a":1},"cmyka":null},"direction":0}},"width":2.9999,"dash":"none"},"size":{"width":18,"height":18,"linked":false},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"line-size":{"type":"relative","length":100}},"labels":{"visible":true,"horizontal-offset":-50,"vertical-offset":0,"rotation":0,"horizontal-alignment":"right","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"target-mark-anchor":"center","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"numerical-axis":{"visible":false,"reverse":false,"flip-location":false,"locate-at-zero":false,"offset":0,"hide-zero":false,"ticks-number":5,"line":{"visible":true,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":1.0001,"dash":"none"}},"major-ticks-and-grid":{"visible":false,"ticks":{"visible":false,"length":0,"offset":0,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"grid":{"visible":false,"above":false,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"custom-ticks-amount":{"visible":false,"ticks-interval":0}},"minor-ticks-and-grid":{"visible":false,"ticks":{"visible":false,"length":0,"offset":0,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"grid":{"visible":false,"above":false,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"amount":0},"labels":{"visible":true,"horizontal-offset":0,"vertical-offset":0,"rotation":0,"horizontal-alignment":"center","vertical-alignment":"center","font":{"family":"PTSans-Regular","size":16,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":"","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}}},"number-format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false},"type":"numerical"}},"dataSourceView":{"dataSource":{"name":"main template datasheet container","type":"com.datylon.dbidatasource.workbookdatasource","location":""},"viewDefinition":{"name":"view","from":"Dataset","orientation":1,"header":true,"series":[{"name":"New series 1","data":[{"name":"measures","from":0,"datatype":1,"fromIx":0},{"name":"value","from":5,"datatype":1,"fromIx":5},{"name":"target","from":6,"datatype":1,"fromIx":6},{"name":"custom-range-labels","from":-1,"datatype":0,"fromIx":-1}],"properties":{}}]}}} 0 litres15000 litres20000 litres25000 litres30000 litres23700 litres18400 litres{"id":"com.datylon.bulletchart2","version":"1.8","name":"Autumn","style":{"x":928,"y":191.9999999999991,"width":288,"height":576,"margin":{"top":20,"right":100,"bottom":20,"left":100},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0}},"plot-background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0}},"chart-orientation":"vertical","ranges":{"ranges":"Values From Data","color":{"type":"palette","solid":{"type":"RGBA","cmyka":{"c":0,"m":0,"y":0,"k":0,"a":1},"rgba":{"r":255,"g":255,"b":255,"a":1}},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":195,"g":196,"b":201,"a":1},"cmyka":null},"direction":0},"palette":{"applying-type":"NORMAL","palette":[{"type":"RGBA","rgba":{"r":255,"g":245,"b":240,"a":1},"cmyka":null},{"type":"RGBA","rgba":{"r":252,"g":186,"b":161,"a":1}},{"type":"RGBA","rgba":{"r":249,"g":105,"b":76,"a":1}},{"type":"RGBA","rgba":{"r":203,"g":28,"b":30,"a":1}},{"type":"RGBA","rgba":{"r":103,"g":0,"b":13,"a":1}}],"reversed":true,"type":"SEQUENTIAL","numerical":null}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"horizontal-rounding":0,"vertical-rounding":0,"round-all-corners":false,"size":{"type":"relative","width":100},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"labels":{"visible":true,"horizontal-offset":5,"vertical-offset":0,"rotation":0,"horizontal-alignment":"left","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"show":"all","anchor-point":"Bar: bottom","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"bar":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":63,"g":81,"b":181,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":0,"g":150,"b":136,"a":1},"cmyka":null},"direction":0}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":120,"g":120,"b":120,"a":1},"cmyka":null}},"width":0,"dash":"none"},"horizontal-rounding":0,"vertical-rounding":0,"round-all-corners":true,"size":{"type":"relative","width":30},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"labels":{"visible":true,"horizontal-offset":-50,"vertical-offset":0,"rotation":0,"horizontal-alignment":"right","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"anchor-point":"start","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"target":{"visible":true,"symbols":{"icon":"Line","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":131,"g":207,"b":205,"a":1},"cmyka":null}},"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":229,"g":229,"b":229,"a":1},"cmyka":null},"gradient":{"color-1":{"type":"RGBA","rgba":{"r":255,"g":255,"b":255,"a":1},"cmyka":null},"color-2":{"type":"RGBA","rgba":{"r":195,"g":196,"b":201,"a":1},"cmyka":null},"direction":0}},"width":2.9999,"dash":"none"},"size":{"width":18,"height":18,"linked":false},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"line-size":{"type":"relative","length":100}},"labels":{"visible":true,"horizontal-offset":-50,"vertical-offset":0,"rotation":0,"horizontal-alignment":"right","vertical-alignment":"center","font":{"family":"PTSans-Bold","size":12,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":" litres","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}},"target-mark-anchor":"center","format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false}}},"numerical-axis":{"visible":false,"reverse":false,"flip-location":false,"locate-at-zero":false,"offset":0,"hide-zero":false,"ticks-number":5,"line":{"visible":true,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":1.0001,"dash":"none"}},"major-ticks-and-grid":{"visible":false,"ticks":{"visible":false,"length":0,"offset":0,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"grid":{"visible":false,"above":false,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"custom-ticks-amount":{"visible":false,"ticks-interval":0}},"minor-ticks-and-grid":{"visible":false,"ticks":{"visible":false,"length":0,"offset":0,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"grid":{"visible":false,"above":false,"stroke":{"color":{"type":"link"},"width":1.0001,"dash":"none"}},"amount":0},"labels":{"visible":true,"horizontal-offset":0,"vertical-offset":0,"rotation":0,"horizontal-alignment":"center","vertical-alignment":"center","font":{"family":"PTSans-Regular","size":16,"weight":"normal","style":"normal","stretch":"normal","text-decoration":"none","color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":0,"g":0,"b":0,"a":1},"cmyka":null}},"tracking":0},"shadow":{"visible":false,"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":85,"g":85,"b":85,"a":1},"cmyka":null}},"dx":4,"dy":4,"stdeviation":4},"prefix":"","suffix":"","paragraph":{"visible":false,"width":100,"horizontal-align":"center","justify":false,"leading":1.1},"background":{"visible":false,"color":null,"stroke":{"color":{"type":"solid","solid":{"type":"RGBA","rgba":{"r":100,"g":100,"b":100,"a":1},"cmyka":null}},"width":0,"dash":"none"},"rounding":{"top-left":0,"top-right":0,"bottom-right":0,"bottom-left":0},"size":{"linked":false},"padding":{"top":0,"right":0,"bottom":0,"left":0}}},"number-format":{"absolute-values":false,"decimal-separator":".","thousand-separator":"","short-notation":"none","precision":null,"add-plus":false},"type":"numerical"}},"dataSourceView":{"dataSource":{"name":"main template datasheet container","type":"com.datylon.dbidatasource.workbookdatasource","location":""},"viewDefinition":{"name":"view","from":"Dataset","orientation":1,"header":true,"series":[{"name":"New series 1","data":[{"name":"measures","from":0,"datatype":1,"fromIx":0},{"name":"value","from":7,"datatype":1,"fromIx":7},{"name":"target","from":8,"datatype":1,"fromIx":8},{"name":"custom-range-labels","from":-1,"datatype":0,"fromIx":-1}],"properties":{}}]}}} {"name":"main template datasheet container","type":"com.datylon.dbidatasource.workbookdatasource","location":"","data":[{"name":"Dataset","data":[["Measures","Winter Value","Winter Target","Spring Value","Spring Target","Summer Value","Summer Target","Autumn Value","Autumn Target"],["0","21000","16700","22600","17200","26200","19800","23700","18400"],["15000",null,null,null,null,null,null,null,null],["20000",null,null,null,null,null,null,null,null],["25000",null,null,null,null,null,null,null,null],["30000",null,null,null,null,null,null,null,null]]}]}
Winter Help

Dataset

First row are headings

Data is in

Series

New series 1