Forum Discussion
Helper ICreating a 3 Axis Line Chart
Here's something to get you going. Still needs coloring, smoothing etc.
The key is the "resolve" instruction at the bottom.
{ "data": { "name": "dataset" }, "encoding": { "x": { "field": "PERIOD_YEAR", "type": "nominal" } }, "layer": [ { "mark": { "type": "line" }, "encoding": { "y": { "field": "QTY ", "type": "quantitative" } } }, { "mark": { "type": "line" }, "encoding": { "y": { "field": "GM % ", "type": "quantitative" } } }, { "mark": { "type": "line" }, "encoding": { "y": { "field": "GM $/unit ", "type": "quantitative", "axis": {"offset":50} } } } ], "resolve": {"scale": {"y": "independent"}} }
Helper IHi Ibendlin- thank you! I havne't heard of Deneb before, though I'm very new to PBI. Below is the table that the graph is build off of. I hope this is in the correct usable format. I've modified the amounts so none is sensitive information. Ideally, the left y-axis shows both "GM%" and "QTY" each as it's own axis scale with GM% as a percentage and QTY as a number, the right secondary axis shows "ASP$" and "GM $/unit", both in dollar. Picture below. I really hope I've supplied enough information.
| PERIOD_YEAR | QTY | GM $/unit | GM % | ASP $ |
| 2019 | 1,080 | $6,950.00 | 41.15% | $16,650.00 |
| 2020 | 950 | $7,010.00 | 42.00% | $16,680.00 |
| 2021 | 1,145 | $6,250.00 | 36.50% | $17,500.00 |
| 2022 | 1,050 | $5,540.00 | 32.22% | $17,200.00 |
| 2023 | 970 | $4,680.00 | 26.50% | $17,700.00 |
| 2024 | 830 | $4,840.00 | 27.00% | $17,800.00 |
THANK YOU THANK YOU THANK YOU
Super UserHere's something to get you going. Still needs coloring, smoothing etc.
The key is the "resolve" instruction at the bottom.
{
"data": {
"name": "dataset"
},
"encoding": {
"x": {
"field": "PERIOD_YEAR",
"type": "nominal"
}
},
"layer": [
{
"mark": {
"type": "line"
},
"encoding": {
"y": {
"field": "QTY ",
"type": "quantitative"
}
}
},
{
"mark": {
"type": "line"
},
"encoding": {
"y": {
"field": "GM % ",
"type": "quantitative"
}
}
},
{
"mark": {
"type": "line"
},
"encoding": {
"y": {
"field": "GM $/unit ",
"type": "quantitative",
"axis": {"offset":50}
}
}
}
],
"resolve": {"scale": {"y": "independent"}}
}- JST15
This is amazing! I've got it working and is great. Thank you for the help and introducing me to Deneb.
- JST15
Sorry, I'm stuck again.
The intervals ticks for my right side y-axis are using the exact value rather than round whole values intervals like the x-axis. This is causing my the two lines I'm expecting for the right side y-axis to merge into one. I tried changing my formats but it isn't working. I also tried reading the vega light documentation but couldn't figure it out. Do you know how to change this so my right side y-axis uses round whole values rather than the exact? Below is the code I'm using as well. Thank you!!!
{"data": {"name": "dataset"},"encoding": {"x": {"field": "PERIOD_YEAR","type": "nominal"}},"layer": [{"mark": {"type": "line"},"encoding": {"y":{"field": "QTY","type": "quantitative"}}},{"mark": {"type": "line"},"encoding": {"y":{"field": "GM%_Less LC__formatted","sort":"-y"}}},{"mark": {"type": "line"},"encoding": {"y": {"field": "GM $/unit_Less LC__formatted","sort":"-y","axis": {"offset":70}}}}],"resolve": {"scale": {"y":"independent"}}}- lbendlin
Not sure what your concern is. Do you want to manually provide the values for the tick marks?
- JST15
I'd rather the ticks be even even intervals like 0, 20%, 25%... rather than showing the exact value. I'll read the documents you send as those look like they will help solve the issue. No need to reply and THANK YOU so much for all of the help! This was very appreciated and I learned a ton.