Question

Photo of DJ Grick

0

Adding up metrics

2

I am working to build out our metrics and wanted to see if I understood the best way to do it. We have 2 services and want to be able to see attendance, giving, and some other items as individual services but also see them added together to see a total. To just focus on attendance, this metric will need entered manually for both services. Do we then need to run a SQL query and have a third metric for totals? Is there any other way to add these up? 

Along the same lines is there a way to have multible values on a line graph? 

  • Photo of DJ Grick

    0

    This got resolved with updates to 6.0 for metrics. 

  • Photo of Kelley Langkamp

    0

    I did that with workflows and workflow triggers. Each service at each campus is it's own metric also each campus has a metric then the overall total is a metric. Then I have workflows that run sql to add the weekend totals for each campus and the overall total and insert the rows into the metric table. There is a workflow post save trigger that fires when they save attendance for each service and updates all the totals for that campus and that overall totals.

    • DJ Grick

      DJ Grick

      That sounds awesome. Any chance you could screen shot it and/or send the sql as a template?

      • Kelley Langkamp

        Kelley Langkamp

        I just realized that the workflow is broken and no one told me... Something in the 4.0 update appears to have broken it. Let me get it working again and I'll paste some screen caps.