Hello everyone,


I'm using ColumnChart in order to display a chart in webpage. This chart should have in its X axis the dates on which event occurred, then the number of events with a particular status, where the number is displayed on the Y axis and the status on the subtitles (with a diferent column for each status).


So, first I did a query that returns the following 

Then, I initialized each data point and inserted into my ChartList .

This is the result of the ChartList after all the iteration.


But then, my graph stays like this. And the correct dates don't show up.

Any help?


Thank you

Pedro Francisco

Show the chart proprieties to see how did you map that dataPoints



Thanks

Hello, here's the Chart properties:


I just mapped the DataPoint List(ChartObligationReportStatus) to the chart, is there anything I still need to do? Like format the XAxis or something?

 I also tried to mess with the AdvancedFormat as seen in:

[Charts Date Scale] 

But couldn't make it work.

Thank you


EDIT: When I use the Inspect on Chrome I get the following:


He is changing the dates to 2018 and 2019, even though I don't even have any date with 2019 on it ( so he is not rounding it up). 


If I force my query to return only one record, like so:

He shows the correct date :

Solution

Hello, I ended up solving it by adding this to the properties


Not sure if its the best way to tackle the problem though. I'll mark the question as solved for now.


Thank you

Solution

Pedro Francisco wrote:

Hello, I ended up solving it by adding this to the properties


Not sure if its the best way to tackle the problem though. I'll mark the question as solved for now.


Thank you

I don't know if is the best practice, i was expecting with your list was already prepared to mount the chart.


Best regards