It's ya boi.
Thought I was done, not so. Not even close (if anyone remembers anyways).
Thankfully I got most of the work done myself, not that complex.
Anyways, I got this query:
Code:
SELECT TableMonth.Provider, Count(TableMonth.[IncidentID]) AS Amount
FROM TableMonth
GROUP BY TableMonth.Provider, TableMonth.[Type]
HAVING (((TableMonth.Provider)="CANTV" Or (TableMonth.Provider)="MOVISTAR") AND ((TableMonth.[Type])="Total"));
It's not the actual query, had to translate from spanish to keep things consistent. But what that displays is something like this:
Provider |
Amount |
CANTV |
25 |
MOVISTAR |
75 |
What I want is to modify the query so it shows the percentage of amounts. Like, in the example, then the first one would be 25% of all incidents, and the second would be 75%.