Find 'column ratio' per value in another column (date bucket)

[Jake Litchfield]

In Atlassian Analytics I'm trying to create a stacked bar graph which shows a set of values as a proportion of the total for the bar.

I've actually managed to create this view by adjusting some of the chart settings, but when you hover over the chart, the values shown remain the raw sum, as opposed to the proportion which would be preferable.

I assume in order to achieve this I need to get the result table to a state where the values represent the 'column ratio' per my date buckets, but I haven't been able to figure out how to calculate that with the formulas/tools provided.

Any suggestions would be much appreciated!

[Inder Singh · Accepted solution]

@Jake Litchfield : Assuming your query output columns are named as shown below:

You can use window function to calculate the proportion. You can apply this formula:

"Count of issues"*1.0/(sum("Count of issues") over (partition by "Quarter of Created at"))

Let us know if this works

Cheers,

Inder

[Jake Litchfield]

Thank you @Inder Singh, that's worked perfectly!

[Jessie Turpin]

In addition to Inder's solution, we have a feature request open for the ability to have the values displayed in the tooltip be formatted as a percentage as well. I'd highly recommend that you watch and vote for the feature request! 

[Jake Litchfield]

Thanks for the heads up @Jessie Turpin, I have just voted for that very useful feature request!