I made two queries to build a bar chart with positive and negative values on one axis.
First query contains three columns: quarter, plan/fact and income/costs (with + and - values), bar chart that was build on this query looks good (what i exactly want), but it doesn’t show positive values on + axis.
Second query contains four columns: quarter, plan/fact, income and costs (only costs column has - values), and bar chart doesn’t show positive axis and values if i group values with plan/fact column in Visualization Editor/
Does anybody know how to solve this problem?