Adding Calculations on Custom Reports

Follow

Comments

5 comments

  • Avatar
    Nicholas McCormick

    Having a true average function would make a huge difference for custom reports.  They're very interesting and promising but as-is they pale in comparison to excel, google sheets, and other external report options.  When will we see some resources dedicated to this portion of Illuminate?  I want to use it more! =)

  • Avatar
    Brittany Bishop

    I would like an average function as well. My averaging isn't always accomplished through using the window column. I would also like to see some examples of formulas that can be used using this function. 

  • Avatar
    Chris Moggia

    I agree Brittany!  I would love to see a dozen or more examples of this calculation feature as it is used in other districts.  This section of the support documents seems incomplete with just a single example provided.  Looks like for now it is limited to just simple mathematical notation (addition, subtraction,multiplication, division).  But could be much more powerful, as Nicholas mentions.

  • Avatar
    Chris Moggia

    Actually, you can do more than simple math, which makes the need to develop this section out even greater!    I found this link: https://support.illuminateed.com/hc/en-us/community/posts/115000236234-Reporting-How-can-I-get-just-the-student-s-middle-initial-in-my-custom-report-

    Which shows the use of an "excel" like feature "Substring"  Who knew? :)

  • Avatar
    Chris Moggia

    I'd also like to figure out how to calculate the following:

    I have 3 data fields each with a value between 1 and 4.  I want to set a conditional flag to "Met" if all 3 fields have a value greater than 2.

    Is this possible with conditional columns?

     

     

Please sign in to leave a comment.