reporting services - Centering a group label in a chart in SSRS -
i have chart in report in ssrs display ticket counts. there 3 groups: submitted, closed - fcr, open. each group has 4 ticket types of submitted, closed, fcr, open. submitted , open groups want labels on graph centered on bar. when counts 0, type not shown. chart looks now: 
this switch statement added ticket type series group order types:
=switch( fields!ticketgroup.value = "submitted" , fields!tickettype.value = "submitted", 1, fields!ticketgroup.value = "submitted" , fields!tickettype.value = "closed", 2, fields!ticketgroup.value = "submitted" , fields!tickettype.value = "open", 3, fields!ticketgroup.value = "submitted" , fields!tickettype.value = "fcr", 4, fields!ticketgroup.value = "closed" , fields!tickettype.value = "open", 1, fields!ticketgroup.value = "closed" , fields!tickettype.value = "closed", 2, fields!ticketgroup.value = "closed" , fields!tickettype.value = "fcr", 3, fields!ticketgroup.value = "closed" , fields!tickettype.value = "submitted", 4, fields!ticketgroup.value = "open" , fields!tickettype.value = "submitted", 1, fields!ticketgroup.value = "open" , fields!tickettype.value = "closed", 2, fields!ticketgroup.value = "open" , fields!tickettype.value = "open", 3, fields!ticketgroup.value = "open" , fields!tickettype.value = "fcr", 4) the closed - fcr centering correct. submitted , open centering needs corrected.
syntax wrong in switch statement? don't see why not centering
update adding column sort in each group still not work. order sorted using first group. also, tried using same value each ticket type. submitted, closed , open set 2 , fcr 3 not work either. values identified submitted = 3, closed = 1, fcr = 4, open = 2.
update trying use lookup function concatenate columns correct sort order each group. still not working. submitted , closed = 2, fcr = 3 , open = 4. sort values have different? can not same sort value in different groups?
update there way vary distance in x-axis labels?
i've put chart , seems work, assuming i've understood correctly is!
i built dummy dataset using following query
declare @data table(ticketgroup varchar(20), tickettype varchar(20), amount int) insert @data values ('submitted', 'submitted', 10), ('submitted', 'submitted', 11), ('submitted', 'closed', 9), ('submitted', 'closed', 12), ('submitted', 'closed', 13), ('submitted', 'open', 8), ('submitted', 'fcr', 14), ('closed - fcr', 'open', 7), ('closed - fcr', 'open', 6), ('closed - fcr', 'closed', 10), ('closed - fcr', 'closed', 11), ('closed - fcr', 'closed', 12), ('closed - fcr', 'fcr', 3), ('closed - fcr', 'submitted', 8), ('open', 'submitted', 4), ('open', 'closed', 5), ('open', 'open', 6), ('open', 'open', 7), ('open', 'fcr', 9), ('open', 'fcr', 10) select * , case when d.ticketgroup = 'submitted' 1 when d.ticketgroup = 'closed - fcr' 3 when d.ticketgroup = 'open' 3 end sortlevel1 , case when d.ticketgroup = 'submitted' , d.tickettype = 'submitted' 1 when d.ticketgroup = 'submitted' , d.tickettype = 'closed' 2 when d.ticketgroup = 'submitted' , d.tickettype = 'open' 3 when d.ticketgroup = 'submitted' , d.tickettype = 'fcr' 4 when d.ticketgroup = 'closed - fcr' , d.tickettype = 'open' 1 when d.ticketgroup = 'closed - fcr' , d.tickettype = 'closed' 2 when d.ticketgroup = 'closed - fcr' , d.tickettype = 'fcr' 3 when d.ticketgroup = 'closed - fcr' , d.tickettype = 'submitted' 4 when d.ticketgroup = 'open' , d.tickettype = 'submitted' 1 when d.ticketgroup = 'open' , d.tickettype = 'closed' 2 when d.ticketgroup = 'open' , d.tickettype = 'open' 3 when d.ticketgroup = 'open' , d.tickettype = 'fcr' 4 end sortlevel2 (select ticketgroup, tickettype, sum(amount) amount @data group ticketgroup, tickettype) d i created simple column chart.here's design.
then 2 category groups, click drop down in designer , click category group properties.
go sorting tab , set sort sortlevel1 or sortlevel 2 respectively.
the final output (in need of tidying!) looks this.



Comments
Post a Comment