SSRS report - 100% stacked bar base on one column

Question

I need to show a chart like this:

Can I show it with this data:

Name Count

ABC 30

where green is 30% and black is 70% to make it 100%.

Thanks.

Answer 1

One way is to calculate the rest up to 100 already in the SQL query.
Imagine "test" is your table with the figures, then this should work.

;with test as
    (select 'ABC' AS Name, 30 AS Cnt)

SELECT *
FROM test

UNION ALL

-- Calculate the rest up to 100
SELECT 'ZZZ',
       100.0 - (SELECT SUM(cnt) FROM test)