Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
My current database doesn't store the amount of open incidents on daily base. I would like to store this information in a qvd file.
Currently i have a straight table wich displays the amount of open tickets.
Calculated dimension = if(TICKETSTATUS_title ='Open', 'Open tickets:')
Expression = count(TICKET_fullname)
I would like to store this like:
Table name= Opentickets
Field 1= date
Filed 2= opentickets
If any more information is needed, let me know.
Thanks, regards, Harry
You'll have to create a summary table with that information in the script:
Summary:
LOAD
today() as date,
count(TICKET_fullname) as opentickets
FROM ...
WHERE match(TICKETSTATUS_title , 'Open','Open tickets')
Concatenate Summary:
LOAD * FROM MyQVD.qvd (qvd);
STORE Summary INTO MyQVD.qvd (qvd);
You'll have to create a summary table with that information in the script:
Summary:
LOAD
today() as date,
count(TICKET_fullname) as opentickets
FROM ...
WHERE match(TICKETSTATUS_title , 'Open','Open tickets')
Concatenate Summary:
LOAD * FROM MyQVD.qvd (qvd);
STORE Summary INTO MyQVD.qvd (qvd);
Thanks for the help! i got it working!
Regards,
Harry