topic Re: Line graph with Cumulative figures in App Development

Line graph with Cumulative figures

madnanansari — Wed, 15 Feb 2017 07:25:32 GMT

I have developed a line graph where I plot the Running Sales & Target for the month for each day. So as u progress the month; the chart shows an increasing sales vs target lines.

The formula for sales is as below:

RangeSum(Above(Sum(Sales)),0, RowNo(TOTAL)))

The graph was perfect.

The user comes with a requirement that he need to show sales with green color and the target with blue color. So I tried to develop the graph using value list. Value list dont bring the right graph. I observe that the RangeSum function in not working properly in the value list.

Any suggestions?

Re: Line graph with Cumulative figures

sarvesh — Wed, 15 Feb 2017 10:14:13 GMT

Hi..Adnan,

Write this type "if(Year='2014',Red(),Green())" of syntax in expression.

Regard's

Sarvesh Srivastava

Re: Line graph with Cumulative figures

Chanty4u — Wed, 15 Feb 2017 10:17:26 GMT

or try this

sum(Sales) / Sum(TOTAL <$(=GetCurrentField(Dimension))> sales)

Re: Line graph with Cumulative figures

sunny_talwar — Wed, 15 Feb 2017 10:19:09 GMT

Would you be able to share a sample to look at what you had initially and what you have now?

Re: Line graph with Cumulative figures

madnanansari — Wed, 15 Feb 2017 15:38:05 GMT

issue is not coloring. Issue is that the RangeSum function returns wrong values. The graph is not cumulative.

Re: Line graph with Cumulative figures

sarvesh — Thu, 16 Feb 2017 03:49:31 GMT

Try this syntax if you have problem in Range sum function

RangeSum(first_expr[, Expression])

Re: Line graph with Cumulative figures

madnanansari — Sat, 18 Feb 2017 12:12:26 GMT

how to copy the App here?

Re: Line graph with Cumulative figures

sunny_talwar — Sat, 18 Feb 2017 14:18:32 GMT

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Re: Line graph with Cumulative figures

madnanansari — Sun, 19 Feb 2017 12:01:28 GMT

I dont have the option to attach a file here. I have openned another discussion where I am able to attach the file.