Clustered colum chart with two category groups

[Tobias]

Hello,

I want to create a clustered column chart which will depict how many tickets are sold in a month for events in the current and the next few months as you can see on the attached image chart.jpg. Is that possible with Telerik Reporting? Do I have to use two category groups to get the chart I want? I tried but with no luck.

My data source is an array of items of the following class:

public class Report1Model
{
    public string Titel { get; set; }
    public DateTime OrderDateTime { get; set; }
    public DateTime EventDateDateTime { get; set; }
    public int TicketCount { get; set; }
}

The second attached picture chart-properties.png is a screenshot of the properties of my chart.

Please help. I don't get any further.

Greetings from Germany,

Tobias

[Stef]

Hello Tobias,

You will need to create a Column chart with CategoryGroups per event title and month. Depending on which is the parent grouping you can get a parent month slot with list of events in , or parent event slot with list of months in it.

The attache TRDX illustrates examples how both types of groupings look. the parent category group has set ToggleVisibilityAction which expands the hidden child group. The TRDX file can be previewed with the Standalone Designer tool of Telerik Reporting Q3 2015.


Let us know if you have any further questions.

Regards,
Stef
Telerik

[Tobias]

Hello Stef,

thank you for your reply but your examples does not match my criteria at all. Your example CSV data in your example report only consists of 3 columns. I deliberately added my class definition to my initial question. My records consist of 4 columns.

Maybe my english wording is not good enough. I try to explain my requirements again with more details. My customers are theaters. They play each event (maybe show is a better word for it?) multiple times over many month. For example "Event 1" will be played multiple times in September, October and ​November... Now take a look at chart.jpg, please. ​The chart depict how many orders, which are placed in ​September, are for the ​"Event 1" played in ​Sept​/Oct/Nov/Dec/Jan/Feb. Furthermore the chart depicts how many orders a placed in ​October for the shows in Oct/Nov/Dec/Jan/Feb/Mar/April and so on.

Is it not clear what chart.jpg depicts? Is it possible to create such a chart with the column diagram by using the grouping feature?

Best Regards from Germany,

Tobias

[Stef]

Hi Tobias,


If I understand correctly, the chart must display data as follows:
Month of purchase (category group)
Months in which an event is hold (category sub group)
Number of purchased tickets per month in which an event is hold (value)/ Event (series)

The attached demo project illustrates the result with such settings in the Graph item.


If you need further help, please post test data that can be used for a demo.

Regards,
Stef
Telerik

[Tobias]

Hello Stef,

thank you so much! And if I now set the visibility of the category child group to TRUE I have exactly what I want!

Regards,

Tobias