Joined: 21 Nov 2017
Online Status: Offline
Posts: 1
Topic: Charts with Group Data Posted: 05 Dec 2017 at 5:19am
I have two groups created in my Report.
1) ticket origin (email, phone, self-service,Skype and walk-in)
2) Create Date grouped by Month
I inserted a chart with this group data and it is displaying the data that I want. However, I can't figure out how to have a gap between the months. The bars are all equally spaced regardless and it makes it difficult to determine where one month stops and the next one begins. Is there a way to group the 5 bars for Origin together for each month and have a space between each month?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 07 Dec 2017 at 5:58am
Not entirely following your process but perhaps your issue is that you have a data set that has missing months for different Origins and you want to make sure you show all possible months?
If so the easier answer is to adjust your data set so that you have at a row per month per Origin type. YOU would need nulls for the ticket number field so your counts would not be impacted. Then when you group you don't skip any months.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
