User Profile
AndreasMEG
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Legend that shows all vs filterede name
Can someone help me showing all values, and one in legend at same time in Deneb? It works now like this methood, but i cant use that solution i report mode. Help me develop a filter that replace: !Turbine Filter = 'Query1'[TurbineName] IN {"Borre 4"}, so i can just pick one name instead of manually writing it. EX. Green is filtered value and the rest is same park Deneb Visual { "$schema": "https://vega.github.io/schema/vega-lite/v5.json", "data": { "name": "dataset" }, "resolve": { "scale": { "color": "independent" } }, "transform": [ { "calculate": "toNumber(datum.Windspeed)", "as": "WindNum" }, { "calculate": "toNumber(datum.Production)", "as": "PowerNum" }, { "calculate": "toNumber(datum['Turbine Wind'])", "as": "TWNum" }, { "calculate": "toNumber(datum['Turbine Power'])", "as": "TPNum" } ], "layer": [ /* Baggrund: målepunkter */ { "transform": [ { "filter": "isValid(datum.PowerNum) && isFinite(datum.PowerNum)" }, { "filter": "isValid(datum.WindNum) && isFinite(datum.WindNum)" } ], "mark": { "type": "point", "filled": true, "size": 18, "opacity": 0.35 }, "encoding": { "x": { "field": "WindNum", "type": "quantitative", "title": "Vindhastighed (m/s)" }, "y": { "field": "PowerNum", "type": "quantitative", "title": "Effekt (kW)" }, "color": { "value": "#1f5ca8" }, "tooltip": [ { "field": "Model", "type": "nominal", "title": "Model" }, { "field": "WindNum", "type": "quantitative", "title": "Vind (m/s)" }, { "field": "PowerNum", "type": "quantitative", "title": "Effekt (kW)" } ] } }, /* Overlay: valgt turbine (hvis kolonnerne findes) */ { "transform": [ { "filter": "isValid(datum.TWNum) && isFinite(datum.TWNum)" }, { "filter": "isValid(datum.TPNum) && isFinite(datum.TPNum)" } ], "mark": { "type": "point", "filled": true, "size": 46, "stroke": "white", "strokeWidth": 0.8, "opacity": 0.95 }, "encoding": { "x": { "field": "TWNum", "type": "quantitative", "title": "Vindhastighed (m/s)" }, "y": { "field": "TPNum", "type": "quantitative", "title": "Effekt (kW)" }, "color": { "field": "Overlay", "type": "nominal", "legend": { "title": "", "orient": "top" }, "scale": { "range": ["#2ca02c"] } }, "tooltip": [ { "field": "Model", "type": "nominal", "title": "Model" }, { "field": "TWNum", "type": "quantitative", "title": "Vind (m/s)" }, { "field": "TPNum", "type": "quantitative", "title": "Effekt (kW)" } ] } }, /* Kurve: fra WindBinIndex/5 og Curve_kW (mean pr. vind & model) */ { "transform": [ { "filter": "isValid(datum.Curve_kW)" }, { "calculate": "toNumber(datum.WindBinIndex)/5", "as": "WindCurve" }, { "aggregate": [ { "op": "mean", "field": "Curve_kW", "as": "CurveMean" } ], "groupby": ["WindCurve", "Model"] } ], "mark": { "type": "line", "interpolate": "monotone", "strokeWidth": 2, "opacity": 0.95, "color": "#d62728" }, "encoding": { "x": { "field": "WindCurve", "type": "quantitative", "title": "Vindhastighed (m/s)" }, "y": { "field": "CurveMean", "type": "quantitative", "title": "Teknisk kurve (kW)" }, "order": { "field": "WindCurve", "type": "quantitative" }, "detail": [{ "field": "Model" }], "tooltip": [ { "field": "Model", "type": "nominal", "title": "Model" }, { "field": "WindCurve", "type": "quantitative", "title": "Vind (m/s)" }, { "field": "CurveMean", "type": "quantitative", "title": "Kurve (kW)" } ] } }, /* Usynligt lag som kun leverer Model-legend (valgfrit) */ { "mark": { "type": "point", "opacity": 0, "size": 1 }, "encoding": { "color": { "field": "Model", "type": "nominal", "title": "Model", "legend": { "orient": "right" } } } } ] } Values: Production Windspeed WindBinIndex Curve_kW Model Turbine Wind Turbine Power !Turbine Filter = 'Query1'[TurbineName] IN {"Borre 4"} Turbine Power = IF ( [!Turbine Filter], 'Query1'[Production], BLANK() ) Turbine Wind = IF ( [!Turbine Filter], 'Query1'[Windspeed], BLANK() )Sort data over period and count - Multi Row Card
I wish to sort and count the data as below. I have Availability data from 01-01-2023 - 01-02-2024 and wish to know the average and sort it as shown in the left MultirowCard. I also wish to know the average Availability for the period sorted by age. (Right - MultirowCard)
