nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Bar Chart Question

Sachin0025

Hi All,
I have bar chart with each bar is divided into two parts say " yes and no " , I have shown total of each "Yes" and each "No" on that bar my question is I want to show grand total of all "Yes + No" on each bar .

e.g : X axis : Poll Type
Y axis : Number of users
Secondary Y axis : Answer i.e Yes or No

Thanks in Advance,

Find more posts tagged with

Comments

Hans_vd

Is this how you want it?

Sachin0025

Exactly

Sachin0025

Exactly

Hans_vd

Okay, 
 
I suppose you have a query like this: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
SELECT POLL_TYPE,
ANSWER
FROM your_table
</pre>
 
and in the graph, you have a count aggregation on the value Y series. 
 
Now, in that case, you can modify your query like this: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
SELECT POLL_TYPE,
ANSWER
FROM YOUR_TABLE
UNION ALL
SELECT POLL_TYPE,
'Y + N' AS ANSWER
FROM YOUR_TABLE
</pre>
 
And that will do 
 
Hope this helps 
Hans

Sachin0025

Thanks for help Hans ,
It's working now

Thanks to this forum also........