Forum Discussion
Need help with creating dual Y axis Graph with Parameter Table
Hi There,
I have a parameter table that has the below data points I would like in a dual axes line graph.
2020 $
2020 Units
2020 ASP (Average Selling Price) I got this metric by dividing $/Unit
2021 $
2021 Units
2021 ASP
2022 $
2022 Units
2022 ASP
I would like to be able to have either $ or Units on the left Y Axis, and ASP on the right Y Axis.
My X axis (included in the example file linked below) are the WKs (1 through 52) in the "adj_week" column.
My goal is to be able to filter between what is shown on the FIRST Y axis of the graph with the below options.
2020 $
2020 Units
2021 $
2021 Units
2022 $
2022 Units
My issue is I have the parameter table at the first y axis, but I don't really know what to put as the second y axis to make it ONLY include the ASP data below on the SECOND Y Axis.
2020 ASP
2021 ASP
2022 ASP
Drop Box Link to Data
https://www.dropbox.com/scl/fo/voqb3irjjbu41mpq7q1vj/h?dl=0&rlkey=05if1v1wbv9d4ply42ndq6zdy
1 Reply
Hi Anonymous ,
There is a bit of confusion, there seems to be no crossover in the data, would you be willing to tell how to get these data points?
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data