Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
5 subscribers
Views
1833 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
71305 - no subject - #Records Hi, we are trying to create a b
kdimitrov
over 10 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....
OriginalPostID-71305
Discussion posts and replies are publicly visible
Parents
0
kdimitrov
over 10 years ago
Hi Sathya, yes, we added the original table's primary key and changed the "data" column to "xsd:long" since aggregating on COUNT() in MySQL produces bigint(21) result and it worked like a charm. Thanks for your help!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
kdimitrov
over 10 years ago
Hi Sathya, yes, we added the original table's primary key and changed the "data" column to "xsd:long" since aggregating on COUNT() in MySQL produces bigint(21) result and it worked like a charm. Thanks for your help!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data