4 Replies Latest reply on Dec 29, 2017 9:36 AM by Jassi Kul

# Bar Graph Percentage

Hi Friends, I am having trouble converting my Bar graph to display total %.

Instead it is showing cumulative values.

I would like to convert it to % instead of cumulative values.

Desired result like below

Thanks

.

• ###### 1. Re: Bar Graph Percentage

Good morning

Not sure I full understand the expectation but it this what you want?

the formula is

RUNNING_SUM([PIVOT_DISTINCT_COUNT]/window_sum([PIVOT_DISTINCT_COUNT]))

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: Bar Graph Percentage

Thanks Jim,

If you look at worksheet, Distinct Counts are cumulative where as what i am looking for is Non-Cumulative Bar graph representation in %.

Thanks

• ###### 3. Re: Bar Graph Percentage

like this ?

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 4. Re: Bar Graph Percentage

I think i am not clear about what is creating problem. If you look at below graph,

My total distinct counts are 18,127.

What i am getting below is cumulative values for each bar.

So technically my last bar shouldn't be 18,126. It should be 18126 - 404 = 17726.

Thanks