AdvancedSQL and Charts

  

Dear gurus,


i have an AdvSQL

SyntaxEditor Code Snippet

select a.label, a.val, a.series, a.tooltips, a.color 
from 
(
    /* Opened Tickets */
    SELECT 
    datename(month, {Ticket}.[CreatedAt]) label , count(1) val, 'Opened' Series, 'Tip 1' tooltips, 'Red' color
    FROM {Ticket}
    WHERE {Ticket}.[TicketStatusId] = 3
    group by datename(month, {Ticket}.[CreatedAt])
    

    union

    /* Closed Tickets */
    SELECT 
    datename(month, {Ticket}.[ClosedAt]) label, count(1) val, 'Closed' Series, 'Tip 2' tooltips, 'Yellow' color
    FROM {Ticket}
    WHERE {Ticket}.[TicketStatusId] = 1
    group by datename(month, {Ticket}.[ClosedAt])
) a
order by a.series, MONTH(a.label + ' 1 2000') 


It act as data source for my pie and bar charts https://weiliesc.outsystemscloud.com/Workflow/

But how come the chart results are different?


Hi Weilies,

Couldn't see those results. Your workflow app asks for credentials (that web screen should have the 'anonymous' ticked to avoid that login request).

Tiago Neves wrote:

Hi Weilies,

Couldn't see those results. Your workflow app asks for credentials (that web screen should have the 'anonymous' ticked to avoid that login request).


Ops! Tiago, sorry coz I switched my public dashboard screen to a private upload test screen ^^. Will swap back when I get home later