In the line graph, I am trying to switch Y axis to X axis. In the screenshot, values 2021, Jan 22, Feb 22 and Mar 22 are in the Y axis (values). I am trying to switch it to X axis. The goal of this is to have a line chart. Thanks for your help in advance!
have you tried bringing your data into QS in a different format using these four columns of data:
- date (Jan 1, 2022, Feb 1, 2022, Mar 1, 2020 for example)
- Avg VHC metric
- HC per rack installed metric
- Rack Installed metric.
When you you drag the date field into the X Axis field well and the three metric fields into the Value field well, the line graph should work.