Creating reports and dashboards | Stimulsoft community forum

I have a simple datsource which looks like this:
Now I would like to have a chart with horiziontal bars, where the X-axis is the customer_count and the Y-axis is the time.
But the Y-axis should be:
So this means, the arguments must be grouped and the values must be summed by hour.

Here's a sample XML:

test.xml
test.xsd

Can you please help me with this?

Tobias

Hello,

Unfortunately, to make this chart means only the designer is not possible.
You should prepare your application data first (group by time interval), and then send these data into a report for rendering a chart.

Thank you.

Ok. Please considere this a feature request:

Grouping and Sorting for Charts

Another problem I have with the Charts is, that I'm unable to format the arguments. Same sample as before: time (a DataTime) is the argument and customer_count (an int) is the value.
I configured the argument to be "{record.time.Hour}", but it still displays a full datetime on the axis.



Here's the sample: charttest.zip

Tobias

Hello,

Please use the Chart.Area.YAxis.Labels.Format property for this. We have changed your report, please see the attached file.

Thank you.

Ok. Thx! This works.

But is there no way to use a custom expression here? Let's say I want the DateTime to be shown in UTC, while the dataset contains local time.

Tobias

Hello,

Unfortunately, no. You can use any date or numbers format for axis labels.

Thank you.