Skip to Content

Calendar Month Characteristic (Analytics - C4C) - Showing Created On?

resolved-on-date-plus-calendar-month.pngsettings-for-characteristics.pngresolved-on-date.pngHi

I am trying to create a dashboard that shows the number of tickets, per agent that were resolved during a given calendar month.

I have the following elements in my column chart:

Selection: Resolved On: Last 3 Months to Today

Rows: Calendar Month

Columns: Key Figure: Counter and Agent

This is showing me the number of tickets per agent per month that were created not resolved. Furthermore it is showing me items which were created in October, November and December when the selection criteria should be filtering this out.

Can someone please explain whether the Calendar Month characteristic is permanently positioned to count Created On time stamp or whether I am doing something incorrect? Or can someone explain how I can make Resolved On Date group the entries into Months rather than individual dates.

Screen shots will show the chart elements above and I have included the table count view where you can see examples where resolved on date was in February however its being counted against Calendar Month January as that's when the ticket was created.

Many thanks

Jess

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 16 at 07:42 PM

    Hello Jessica,

    The characteristic "Calendar Month" seems to be counting based on "Created On" date, just as you suggested.

    If my understanding is correct, you are looking to display in a dashboard the total Tickets per each month they were Resolved, rather than created. To achieve this, you should use a characteristic that counts based on "Resolved On" date. If there is not a standard characteristic which brings you this data, you may then need to create a custom field to achieve this - in this case your Implementation Partner could help.


    Hope this helps clarifying the scenario a little further.

    Cheers,
    Marlon

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 16 at 03:52 PM

    @felipe.fraga - my account is saying you updated my question. Did you have an answer or was it just a terminilogy adjustment?

    Thanks

    Jess

    Add comment
    10|10000 characters needed characters exceeded