71305 - no subject - #Records Hi, we are trying to create a b

kdimitrov over 12 years ago

#Records Hi, we are trying to create a bar graph in the new SAIL interface, which shows new records by month (i.e. {January, 56}, {February, 25}, etc..... We are storing the date of the record's insertion (i.e. 18/06/2013 for example). Is it possible to convert these dates to a month value and aggregate the data over it? We are currently using the queryrecord() and type!Query as the tutorial has recommended, but it does not seem to allow that use case....

Discussion posts and replies are publicly visible

Parents

0 Sathya Srinivasan
Appian Employee
over 12 years ago

correct. For large volume of data and if the data is coming from a DB, then creating a view where one of the column is a computed column (using to_date function of MySQL()) to get the month and using it will be ideal. If you are running aggregation, I would go one step further to create the aggregated view in the MySQL directly and map it to a Record type and use it. This will give you some performance benefit. Hope this helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sathya Srinivasan
Appian Employee
over 12 years ago

correct. For large volume of data and if the data is coming from a DB, then creating a view where one of the column is a computed column (using to_date function of MySQL()) to get the month and using it will be ideal. If you are running aggregation, I would go one step further to create the aggregated view in the MySQL directly and map it to a Record type and use it. This will give you some performance benefit. Hope this helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data