Creating Chart with formula of running total of group?
Creating Chart with formula of running total of group?
(OP)
I was wondering if there is a good work around for creating a chart that is from a formula (%) from 2 running totals. I know the issue is that with charts you can't create graphs from the formulas of running totals since charts are rendered beforehand.
I currently have couple of groups already setup in which I'm counting the running total for. Then using the running totals to get a percentage that I want to graph by month.
Group 1 - Name
I can chart the running totals but not able to chart the percentage in a graph and get the value is a variable error.
I currently have couple of groups already setup in which I'm counting the running total for. Then using the running totals to get a percentage that I want to graph by month.
Group 1 - Name
Group 2 - Mo/Yr
Running total x & y
x / y * 100 = percent
I can chart the running totals but not able to chart the percentage in a graph and get the value is a variable error.
RE: Creating Chart with formula of running total of group?
-LB
RE: Creating Chart with formula of running total of group?
Example.
My grouping in the initial post was incorrect.
Group 1: mo/yr
Footer 1: Formula 1 / Formula 2 = Percent.
RE: Creating Chart with formula of running total of group?
RE: Creating Chart with formula of running total of group?
Please answer these questions and then show some sample data with column labels at the detail section.
If you are using formulas, show the actual contents of the formulas. If you are using running totals, show how they are set up--summary field, type of summary, evaluation section, reset section.
-LB
RE: Creating Chart with formula of running total of group?
Name Month IsValid Name Count (formula)
Joe Jan 1 1
Joe Jan 1 0
Bill Jan 0 1
Jeff Jan 1 1
Jeff Jan 1 0
Jeff Jan 1 0
Mary Jan 0 1
Mary Jan 0 1
Leon Jan 1 1
Need sum of IsValid and Name Count to create a percentage. IsValid / Name Count = percent. I would only count the IsValid where Name Count = 1.
RE: Creating Chart with formula of running total of group?
-LB