Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enhancement: Additional Summary Statistic #16

Open
clareprice opened this issue Apr 28, 2016 · 3 comments
Open

Enhancement: Additional Summary Statistic #16

clareprice opened this issue Apr 28, 2016 · 3 comments
Assignees

Comments

@clareprice
Copy link
Contributor

Similar to average report but for other summary statistic, such as min and max values, range, etc Workflow example: for each census tract what is the max upload and download speed in the area, .

FYI @MikeMillerGIS @pLeBlanc93

@pLeBlanc93 pLeBlanc93 self-assigned this May 2, 2016
@MikeMillerGIS
Copy link
Member

Based on the conversation today.
Support a new report type of Statistics. In this report. Let the user specify AVERAGE, MIN, MAX, instead of Value in the expressions. This will allow them to map any stat to any field with the use of expression to custom format it. The existing report type of Average will need to continue to work for those implementation that do not migrate to the new report type.
@pLeBlanc93 @clareprice

@pLeBlanc93
Copy link
Contributor

Instead of using {Value} to refer to the average, the new report type can reference any number of statistics inside the expression.
For example:

{
    "Type" : "STATISTIC",   
    "AverageToResultFieldMap" : [
        {
          "FieldName": "AVERAGE",            
          "Expression": "round({MEAN},2)"
        },
        {
          "FieldName": "CAPCOST",
          "Expression": "round(float(908.22) - (float({MEAN}) * (float(float(908.22) - float(0.0)) * float(float(1.0) / float(37.0)))),2)"
        },
        {
            "FieldName": "test",
            "Expression": "'The average is {} and {} - {} should be {}'.format({MEAN}, {MAX}, {MIN}, {RANGE})"
        }
    ]
}
Average Age: Capital Cost: test
37.94 -23.02 The average is 37.9379157428 and 50.0 - 2.0 should be 48.0
16.6 500.63 The average is 16.6046511628 and 18.0 - 15.0 should be 3.0
18.06 464.99 The average is 18.0567514677 and 44.0 - 3.0 should be 41.0
17.53 477.83 The average is 17.5335892514 and 44.0 - 10.0 should be 34.0

@MikeMillerGIS
Copy link
Member

nice!

@pLeBlanc93 pLeBlanc93 mentioned this issue May 3, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants