Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've been trying to get closed and open tickets in a month in the same table so I can calculate a queue rate of # of closed tickets versus opened by month.
Using "autocalendar" of either opened or closed tickets seems to give the wrong data unless the date is a manual calculation like this
=monthstart(today()-80) //this is great... and returns 2018-05-01(may) ..
but now I need multiple dates not just 1 . as you see in the pivot only 1 column is generated with the formula above .. but I want a range of dates instead of a single date. Is it possible?
I was hoping to do it via expression .. something like last 6 months dates from today for example?
solved via this (based off the thread above) Chart expression - closed dates
I realized this can be done by just appending to the code section rather than unlocking.
It is a new table , which is a drawback in a way I guess, but it works well !
RequestsTimeLine_QueueRate:
LOAD
[request] AS [Slide70_RequestClosed.request],
[request.opened_at] as Date,
'created' as DateType,
1 as CreatedCount
FROM [lib://Report Automation/ITSM Process Slides-May2018-Elton_vChg - massive before pivotredo.xlsx]
(ooxml, embedded labels, table is Slide70_RequestClosed);
Concatenate(RequestsTimeLine_QueueRate)
LOAD
[request] AS [Slide70_RequestClosed.request],
[request.closed_at] as Date,
'closed' as DateType,
1 as ClosedCount
FROM [lib://Report Automation/ITSM Process Slides-May2018-Elton_vChg - massive before pivotredo.xlsx]
(ooxml, embedded labels, table is Slide70_RequestClosed);
Chart expression - closed dates
my question is very similar to this one.. but hoping to implement the solution
solved via this (based off the thread above) Chart expression - closed dates
I realized this can be done by just appending to the code section rather than unlocking.
It is a new table , which is a drawback in a way I guess, but it works well !
RequestsTimeLine_QueueRate:
LOAD
[request] AS [Slide70_RequestClosed.request],
[request.opened_at] as Date,
'created' as DateType,
1 as CreatedCount
FROM [lib://Report Automation/ITSM Process Slides-May2018-Elton_vChg - massive before pivotredo.xlsx]
(ooxml, embedded labels, table is Slide70_RequestClosed);
Concatenate(RequestsTimeLine_QueueRate)
LOAD
[request] AS [Slide70_RequestClosed.request],
[request.closed_at] as Date,
'closed' as DateType,
1 as ClosedCount
FROM [lib://Report Automation/ITSM Process Slides-May2018-Elton_vChg - massive before pivotredo.xlsx]
(ooxml, embedded labels, table is Slide70_RequestClosed);