Skip to main content
B
brunowallacel0001
March 28, 2022
Solved

Creating a reporting grouping data by day

  • March 28, 2022
  • 8 replies
  • 0 views

Hi there !

Trying to create a report based on counting register and group by date. So, the result should something like that:

Records    Day
      10        25
      4          26
      9          27
      25        28
      16        29

Looking for a solution, I find out this function that handler month and year, but nothin for day.

Is it possible to do that in another way ? Dunno, a workaround using a expression, for example.

Thanks anyway for read till here!

    Best answer by peter.lewis

    It looks like you're using a!queryEntity() - can you use a!queryRecordType() instead?

    8 replies

    stefanhelzle0001
    stefanhelzle0001
    March 28, 2022

    Syncronized records support custom fields which allow you to get the date from a dateTime field. Then you can aggregate on this custom field.

    B
    brunowallacel0001Author
    March 28, 2022

    Thanks for reply so fast! 

    looks like this doesn't work, since aggregationFields cannot be used with custom record field expressions, according the documentation. 

    Or there's another option ?

    peter.lewis
    peter.lewis
    Employee
    March 28, 2022

    Which version are you using? Assuming you're on 21.2 or later, The grouping function supports grouping by lots of things, including DAY_OF_MONTH, DATE, etc.Can you share a sample of the query you created?

    B
    brunowallacel0001Author
    March 28, 2022

    We're using Appian version 21.4. 

    According the documentation, only YEAR and MONTH could be used in this situation. Is there another approach ?

    peter.lewis
    peter.lewisAnswer
    Employee
    March 28, 2022

    It looks like you're using a!queryEntity() - can you use a!queryRecordType() instead?

      Terms & ConditionsAccessibility statement