Chart with argument grouping

[Tobias]

I have a simple datsource which looks like this:

Code: Select all

time               ; customer_count
2000-01-01T10:00:00; 5
2000-01-01T10:30:00; 6
2000-01-01T11:00:00; 10
2000-01-01T11:30:00; 8
2000-01-01T12:00:00; 3

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:

Code: Select all

10:00-10:59
11:00-11:59
12:00-12:59

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

[Andrew]

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.

[Tobias]

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

[Vladimir]

Hello,

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

Thank you.

[Tobias]

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

[Vladimir]

Hello,

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

Thank you.