date(date#()) function

diana_ — Fri, 15 Mar 2019 22:19:55 GMT

Hi,

In my dataset I have column Period with dates 01/01/2018, 01/02/2018 in a format of Jan-18, Feb-18 etc. and another column with numeric months (1, 2,...12).

When I prepare a combo chart I would like to have month abbreviations (Jan-2018, Feb-2018, etc) on x-axis, however I can only get desired visualization with numeric month values, when applying function =date(Period,'MMM-YYYY'), the chart looks not the way I wish (stacked columns look like lines),the formula for date does not give intended result (MMM-YYY) (picture 2). I have no problem with the same date function in other charts though. Could you please advise the solution?

Picture 1Picture 2

Re: date(date#()) function

Vegar — Fri, 15 Mar 2019 22:28:05 GMT

In your X-axis chart properties, try to disable the continuous axis. (Disable auto handling and uncheck "use continuous axis")

Re: date(date#()) function

diana_ — Fri, 15 Mar 2019 22:32:02 GMT

Thanks a lot. It worked!

topic Re: date(date#()) function in App Development

date(date#()) function

Re: date(date#()) function

Re: date(date#()) function