Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I am trying to create a multichart with four lines (created, closed, resolved and updated) from a list of tickets. I have this data (see the attached image). I create a new combo chart and I configure the following:
dimension 1: Month(created_at) //X axe = Jan, Feb, Mar...
dimension 2: Month(resolved_at) //X axe = Jan, Feb, Mar...
dimension 3: Month(updated_at) //X axe = Jan, Feb, Mar...
dimension 4: Month(closed_at) //X axe = Jan, Feb, Mar...
expression 1: count(created_at)
expression 2: count(resolved_at)
expression 3: count(updated_at)
expression 4: count(closed_at)
But the result is not the expected, of course. I do not know how get for each expression their appropiate month. I stay the whole day trying to fix the problem. Any idea?
first of all...
in combo chart all the expressions have the same dimensions;) (all you can do is prepare combo with two (or more) expressions (one on the left axe and second on the right axe) but it would be still the same dimension for both expressions (the only diference will be teh scale)
as for your question... if all your dimensions give the same range (Jan to Dec) why do you want to use four dimensions? not just one of them? for example Month(created_at) (if task isn't create it could be not resolved/updated/closed, so created_at contain max range of months in your database)
I have one table with all tickets, i.e. 50,000 (see screenshot attached). I want to visualize the amount of created, resolved, closed and updated tickets, per month (Jan...Dec). I decided to use combochart because I want this info all-in-one, i.e. in the same chart. Is possible to do it that I want?