Chart with two y axis [solved]

Hi there

When two values are mentioned in view, y axis are combined, how can i show two y axis in the chart

Regards
Jayanthan

Create one question for each rather than combining them in one.
Then, add one to the dashboard.
Once added, you’ll see this at the top right of the question:
image
Click the line with Edit and you can add the other question.

1 Like

Hi Andrew

It works. Amazing

Thank you

Regards
Jayanthan

hi all

when we add multiple questions, there are some issues,

E.g . one question is limited to top 10 Cash Sales, another question is limited top 10 credit sales, when these two charts are combined, it shows incorrect results, please advise

What results do you get?

it shows top 10 cash sales, where credit sales not shown for those customers

if the see below pic, there is no blue bars for middle chart lines(but there are values for that customers)
Red - Credit
Blue - Cash

image

It looks like it’s showing what you asked for (rather than what you want) - the top 10 customers by credit sales and the top 10 customers by cash.
Only thing I can think of is to create a view that calculates the top 10 customers by total sales and use that to filter the customers for the credit and cash calculations.
You might be able to use the view to create a segment within customers (not tried much with that yet).

how to create segment for top 10 customers by total sales, please advise

I think you’ll need to do something on the database with a view or SP.