Skip to main content
Known Participant
Dec 10, 2022 12:37 PM UTC
Solved

I am trying to create one expression rule to get count of records created by Tester_Group. In table, we have CreatedBy column.

Hi All,

I am trying to create one expression rule to get count of records created by  Tester_Group. In table, we have CreatedBy column.

Requirement is to display the count in UI by using a!gaugeField(). Please help with some ideas.

Regards,
Sandeep

    stefanhelzle0001
    Brainy
    Dec 10, 2022 6:40 PM UTC

    Using the query editor, this should be pretty simple. There is also an similar example in the queries recipes.

    https://docs.appian.com/suite/help/22.4/Query_Recipes.html#aggregate-data-from-a-field

    8 replies

    stefanhelzle0001
    Brainy
    Dec 10, 2022 6:40 PM UTC

    Using the query editor, this should be pretty simple. There is also an similar example in the queries recipes.

    https://docs.appian.com/suite/help/22.4/Query_Recipes.html#aggregate-data-from-a-field

    Known Participant
    Dec 12, 2022 5:16 AM UTC

    Thanks Stefan Helzle

    Participating Frequently
    Dec 10, 2022 10:49 PM UTC

    create a query entity that gets all the records from the created_by column than you can use count() to get the count and display it in your ui. 

    stefanhelzle0001
    Brainy
    Dec 11, 2022 12:07 PM UTC

    It is never a good idea to load all data into Appian and then aggregate it. Just takes up more CPU cycles and memory. Do that in the database.