
它看起来几乎像艺术品——但它是数据!
来自: Fraunhofer ISE:德国每箱太阳能/风能/化石能源的发电量为15毫秒到几个小时*)。
Y 轴上显示的是化石能源发电量,X 轴上显示的是风能(左)和太阳能(右)的分布。
通过右键单击 - 新建公式列/日期时间/年份

可以添加一些颜色——使用像Hue 这样的循环方案。
色调默认不可用,但很容易生成:
Color Theme(
{"Hue", {"Continuous", "Categorical", "Chromatic"}, {{248, 10, 254}, {0,
0, 255}, {0, 127, 255}, {0, 255, 255}, {127, 255, 127}, {255, 255, 0},
{255, 127, 0}, {255, 0, 0}, {254, 5, 235}, Missing( {120, 120, 124} )}}
)
通过增加一些透明度,人们可以感受到数据点的密度:

图例也采用了透明度,这使得它难以阅读。
要解决该问题,只需添加另一列作为“颜色”并将其用作图例...并隐藏原始图例。

总计:
Graph Builder(
Transform Column( "Day of Year 2", Formula( Day Of Year( :date ) ) ),
Transform Column( "Day of Year", Formula( Day Of Year( :date ) ) ),
Transform Column( "Year", Nominal, Formula( Year( :date ) ) ),
Transform Column(
"fossile ->",
Formula(
Sum( :Braunkohle, :Steinkohle, :Öl, :Kohlegas, :Erdgas ) / :Last // Last = consumption
)
),
Transform Column( "dummy", Formula( . ) ),
Transform Column(
"<- wind / solar ->",
Formula( (:Solar - (:Wind Offshore + :Wind Onshore)) / :Last)
),
Variables(
X( :"<- wind / solar ->"n ),
X( :dummy, Position( 1 ) ),
Y( :"fossile ->"n ),
Wrap( :Year ),
Color( :Day of Year ),
Color( :Day of Year 2 )
),
Elements(
Points( X( 1 ), Y, Legend( 1 ) ),
Points( X( 2 ), Y, Legend( 2 ) )
),
SendToReport(
Dispatch( {}, "400", ScaleBox,
{Legend Model(
1,
Properties(
0,
{Transparency( 0.05 ),
gradient(
{Color Theme(
{"Hue_3", {"Continuous", "Categorical",
"Chromatic"}, {{248, 10, 254}, {0, 0, 255}, {0,
127, 255}, {0, 255, 255}, {127, 255, 127}, {255,
255, 0}, {255, 127, 0}, {255, 0, 0}, {254, 5, 235
}, Missing( {120, 120, 124} )}}
), Scale Values( [0 365] ), N Labels( 2 )}
)},
Item ID( "Day of Year", 1 )
),
), Legend Model(
2,
Properties(
0,
{gradient(
{Color Theme(
{"Hue", {"Continuous", "Categorical",
"Chromatic"}, {{248, 10, 254}, {0, 0, 255}, {0,
127, 255}, {0, 255, 255}, {127, 255, 127}, {255,
255, 0}, {255, 127, 0}, {255, 0, 0}, {254, 5, 235
}, Missing( {120, 120, 124} )}}
), Scale Values( [0 365] ), N Labels( 2 ),
Label Format( "Fixed Dec", 12, 0 )}
)},
Item ID( "Day of Year", 1 )
)
)}
)
)
);