Value on data points different than expression result

[#1]

Hello,

I have a graph with one dimension and 2 expressions:

Expression 1 = % of Open Invoice/Order

count({<STATUS = {'Open'}>} ID) / count(ID)

Expression 2 = % of Closed Invoice/Order

count({<STATUS = {'Closed'}>} ID) / count(ID)

I want to display in the bars, the count of Open Invoice/Order and Closed Invoice/Order.

I know how to do it when I have one expression but it does not work with multiple expressions. I tried the "show value" attribute of expressions but it only allows to decide if the value should be displayed or not, I cannot put a different calculation.

Anybody would know how I can achieve below result without changing the dimension/expression implementation?

Thanks,

jc

[jagan]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[#3]

Hello Jagan,

Unfortunately my real application is more complicated and I cannot add a second dimension to my graph.

Any other way to get what I am looking for?

Thanks,

jc

[#4]

The only way I can see you achieving this is to add two more expressions that are the count of the closed and open and then split the Axis .. as attached

[jagan]

Hi,

I think it is not possible with 1 Dimension.

Regards,

Jagan.

[sudeepkm]

please take a look at the example.

[#7]

I do not think it is very readable.

If the graph behaviour is under total control, I thought of adding "Text in chart" on each bar. Otherwise I will need to review my dimension/expressions organization.

Thanks for trying guys.

[#8]

The user wants the Y-axis to be in % but this is an interesting workaround.

[jagan]

Hi,

Instead you can create two charts for showing % in one chart and numbers in another chart.

Regards,

jagan.

[sudeepkm]

if you want both the numbers and % then you ca split axis in same chart to have both displays in two sections. top  and bottom.