Deneb - Faceted Matrix with overall and row total
Seeking help to make the required faceted matrix with average in each row , and overall average of the last column (Avg.) appearing correctly in position. Currently seems the multiple values overlapping in the overall average score. Also, would require an expression as title to show the club name and average score for the each club for the relevant coaches. Number of coach in each club is variable (1-3), and position being assessed may vary as well. Sketch of desired outcome as below. Link to vega editor as the following: Link to Vega Editor
Deneb Stacked Bar Chart Group by Parameter with Pattern Fill
Hi, I just started out using deneb about a week ago and have the following use case. I want to display planned hours by period and project and group the projects that are smaller than a dynamic parameter value. This is my progress so far: I managed to make the grouping by parameter value, but as you can see in the screenshot, there is an issue with the periods '202510' and '202511'. The labels and bar are pushed on the edge of the visual. I noticed that these visual errors occur, if there is no project with values lower than the parameter value, but I don't know how to resolve this issue. This is how my deneb json code looks like: { "data": { "name": "dataset" }, "transform": [ { "calculate": "datum['Planned Hours'] >= datum['Parameter Value'] ? datum['Project'] + ', ' + format(datum['Planned Hours'], '.0f') : 'Z Merged < ' + datum['Parameter Value'] + ' Hours, ' + format(datum['Others Planned Hours'], '.0f')", "as": "Projects" }, { "calculate": "datum['Planned Hours'] >= datum['Parameter Value'] ? datum['Project'] : 'Z Merged <'", "as": "ProjectColor" } ], "layer": [ { "mark": { "type": "bar", "tooltip": true, "stroke": "black" }, "encoding": { "y": { "field": "Planned Hours", "type": "quantitative", "title": null, "stack": true, "aggregate": "sum" }, "color": { "field": "ProjectColor", "legend": null } } }, { "mark": { "type": "text" }, "encoding": { "text": { "field": "Projects" }, "y": { "field": "Planned Hours", "type": "quantitative", "aggregate": "sum", "title": null, "stack": true, "bandPosition": 0.5 } } } ], "encoding": { "x": { "field": "Period", "type": "nominal", "title": null, "axis": { "labelAngle": 0 } } } } Another requirement that I have is to differentiate the projects between rough and detailed planning, depending on the Flag "IsDetailedPlanning" in the "factPlanning" table. I want to achieve for the projects with rough planning part to be shown in a dottet pattern. The detailed planning part of the project should have no pattern fill. The color of the bars should be dependent on the project (as it is now). Is this achievable? Thank you very much for your help in advance! If you need further information don't hesitate to ask. Report with example data: https://we.tl/t-tj8mLUFi38
Custom Matrix
Hi, I would build a matrix like this including 2 measures (assume costs and % of each class at category level). Is there any way to build something like this? Consider that categories are dynamic while classes are static: At the moment I have no idea about how to develop this, problably deneb could be a way... Thanks in advance
