Help in customizing chart

Anonymous — Wed, 29 Aug 2018 04:21:25 GMT

Hi Folks,

I am trying to create a comparision report. That said i am trying to compare the volume of tickets between 2 calendar years

(Aug2016 to Aug 2017 and Aug 2017 to Aug 2018). I have created two seperate bar charts, Refer attached picture.

How do i combine both or customise the charts to show the comparison report ?

I need to get any of the following combination

Display ticket volume as comparison b/w calendar year in the same report. E.G. ticket volume for C2016-08 follwed by ticket volume by C2017-08, and so on. In other words, 1st bar of the 2nd graphs follwed by 1st bar of the 1st graph etc.
Dispaly a bar chart with tickets volume for this year and a trend graph ( incorporated in the same graph ) for previous year for comparison

I am not sure how to apply the filter because both the graphs have different date ranges.

Re: Help in customizing chart

v-chuncz-msft — Thu, 30 Aug 2018 08:44:20 GMT

@Anonymous,

You may use clustered column chart and take advantage of the Legend field.

Anonymous — Fri, 31 Aug 2018 00:15:57 GMT

Hi,

Tried then and no good . As i am comparing a unit value with two different date ranges.