Hey! I have a lookup where we manually enter in a number to a corresponding day. It looks something like this.
Monday | 2
Tuesday | 3
Wednesday | 2
Thursday | 5
Friday | 3
Is there a way to make this into a column chart where the x axis is the days of the week and the y axis is the corresponding number?
I tried to just put it in a column chart but it defaults to flipping the x/y axis, I then tried to transpose but along it still doesnt format correctly.
This should work as long as your fields are returned in the correct order, i.e. day name followed by the numerical value. You can always add
| fields weekday, number
to ensure that.
This should work as long as your fields are returned in the correct order, i.e. day name followed by the numerical value. You can always add
| fields weekday, number
to ensure that.
Thank you!