topic Re: Show Month on x-axis (VizLib Line Chart) in App Development

Show Month on x-axis (VizLib Line Chart)

sunny_talwar — Sat, 16 Nov 2024 05:04:55 GMT

Hi All -

I am trying to create a line chart where I am trying to show daily information while displaying only Month on the x axis...and I am using VizLib chart for this. Here is what I have tried so far.

Step 1: Created a new field in the script using DATE

Date(SetDateYear(DATE, Year(Today())), 'DD-MMM') as MONTHDATE,

Step2: Created a line chart With

Dimension

MONTHDATE YEAR

Expression

Sum(VALUE)

By default, it shows 6 tick marks like this

Now, I tried to increase it to 12 ticks, but that still try to space out based on the days

If I try to use a calculated dimension like this

=Dual(Month(MONTHDATE), MONTHDATE)

I get a chart like this

Now the x-axis looks exactly how I want, but the chart doesn't display the same day level information. All I need is the axis like the third image and plot as in 1st/2nd chart.

I hope someone can advice on this.

Best,

Sunny

Re: Show Month on x-axis (VizLib Line Chart)

sunny_talwar — Fri, 02 Aug 2019 19:25:01 GMT

I was able to get it partially working by enabling Timeaware option after changing the number of ticks to be 12

Now, I am not sure why this begins with 2019 and not January? Any help is greatly appreciated.

Best,
Sunny

Re: Show Month on x-axis (VizLib Line Chart)

Marcos_rv — Fri, 02 Aug 2019 20:39:01 GMT

using a hierarchy that contains the date per day next to the year month? I would say as one more dimension, and you add whatever you want, anyway I would create a field in the calendar that is dual (year & '-' & month, year * 12 + month) as year-month.

regards!!!