I am looking to implement a gauge into the apex. I have a ticket table that has a status column. the value in the column are open, closed. I want to count the number of the open ticket status and use that value into the gauge visualization. I used this code
SELECT ticket_id, count(case when status is null
when status is not null then 1
where lower(status) = 'closed'
group by rollup(ticket_id)
this will return the value of the status with total statis in the table
When I use this in the gauge I get a return of value 2
I suppose to get 4 as a total value. can someone help?
I mean still use group by, but without the rollup
group by ticket
I've never seen rollup used in a chart like this.
That being said, you may be interested in