How to format date in dd-MM-yy format in chart axis

Support
#1

the date in axis is presently showing with time. How can i format in only date like dd-MM-yy. As per echart for ‘time’ type axis a formatter like formatter: '{yyyy}-{MM}-{dd}' // gets labels like '2020-12-02' should work, but it is not working for me.

chart1.addXAxis(new XAxis().withAxisLabel(new AxisLabel().withFormatter("{dd}-{MM}-{yy}")));

Am I missing something. Please advice.

#3

Hi!

The ECharts formatter for the time axis type works for me. Can you share a test project that reproduces the problem?

Regards,
Dmitriy

#5

I am using following code -

Chart chart1 = uiComponents.create(Chart.class);
        BarSeries bar = new BarSeries();
        chart1.addSeries(bar);
        chart1.addXAxis(new XAxis().withAxisLabel(new AxisLabel().withFormatter("{dd}-{MM}-{yy}")));
        chart1.addYAxis(new YAxis().withAxisLabel(new AxisLabel().withFormatter("{value}")));
        chart1.setTitle(new Title().withText("Observation By Time"));
        chart1.withTooltip(new Tooltip());
        chart1.setWidth("100%");
        chart1.setHeight("100%");
        chart1.setDataSet(
                new DataSet().withSource(
                        new DataSet.Source<EntityDataItem>()
                                .withDataProvider(new ContainerChartItems<>(bBSObservationsDc))
                                .withCategoryField("date")
                                .withValueFields("totalUnsafe")
                )
        );

The result i am getting -
image

Here category file is date type.

Am I missing something? Please give code of time formatter which is working.

Thanks

#6

The XAxis object has a AxisType#CATEGORY type by default. Formatting is only applied to axes with a AxisType#TIME type.

In your case it should be:

new XAxis().withType(AxisType.TIME)
    .withAxisLabel(new AxisLabel().withFormatter("{dd}-{MM}-{yy}"));
#7

Adding axistype to time cause blank chart.

I am getting data from data container and the date attribute is of date datatype. Is this causing problem?

#8

Attaching test project
untitled.zip (105.8 KB)

#9

Hi!

I created an issue to fix this problem: Date datatype can't be formatted for Axes · Issue #3620 · jmix-framework/jmix · GitHub

As a temporary workaround you can try to use LocalDate datatype.

Regards,
Dmitriy