Forum Discussion
Invert x axis
Hi,
My graph is displaying itself the wrong way around. I want it to be chronological according to date, but instead its counting backwards in time, like this:
How can I invert the axis so that is displays it the other way around? 2018 20, 2018 21, etc. This is a week-on-week-trend, and I want the newest week furthest to the right. The field itself is not a date field, but made by this formule Yr Wk = YEAR (field) & " " & WEEKNUM(field). So I am guessing it is stored as text and not date. But still, I should be able to flip/invert the axis, right?
Understood! Then I would create a date table, set the relationship up and use the new date table column as the sort by. I believe that should work.
Alright, I'll try that. Thanks!
8 Replies
Hi,
As my column is text, I cannot sort by date. I only get the option to sort by other columns.
If I am in the graph itself, I the "sort by" column is grey and I cannot select that.
Can you not use the 'sort by' option to sort it by the original date column you extract WEEKNUM and YEAR from?