How to Aggregate data for month from date field
24 February, 2014
Hello,
We are trying to aggregate few metrics for a month based on a date field.
The fields used are Bill_Date (Date as datatype), Txn_Units (integer as datatype), Txn_Amount (Float as datatype).
We want to aggregate these two metrics (Txn_Units & Txn_Amount) in two different charts where Bill_Date would be the Dimension. When we represent the chart for Datewise it comes fine, but we would want to aggregate the same monthwise for which the aggregation is not working as YF is not able to understand the Dimension as Month & Year alone. We dont want to use Time Series.
Any help would be great.
Thanks and Regards,
Prakash.
We are trying to aggregate few metrics for a month based on a date field.
The fields used are Bill_Date (Date as datatype), Txn_Units (integer as datatype), Txn_Amount (Float as datatype).
We want to aggregate these two metrics (Txn_Units & Txn_Amount) in two different charts where Bill_Date would be the Dimension. When we represent the chart for Datewise it comes fine, but we would want to aggregate the same monthwise for which the aggregation is not working as YF is not able to understand the Dimension as Month & Year alone. We dont want to use Time Series.
Any help would be great.
Thanks and Regards,
Prakash.
Hi Prakash,
Depending on your database type, there are a few different ways to can format the field as a month/year. For some database we have created the functions for you at the view level:
http://wiki.yellowfin.com.au/display/USER70/Date+Hierarchy
Let us know what database you are using if you can't see many options in the list.
To see a few different ways of formatting dates, check this out article: http://www.yellowfinbi.com/YFCommunityNews-Yellowfin-Quick-How-To-Date-to-Month-Display-112000
Regards,
Cameron
Depending on your database type, there are a few different ways to can format the field as a month/year. For some database we have created the functions for you at the view level:
http://wiki.yellowfin.com.au/display/USER70/Date+Hierarchy
Let us know what database you are using if you can't see many options in the list.
To see a few different ways of formatting dates, check this out article: http://www.yellowfinbi.com/YFCommunityNews-Yellowfin-Quick-How-To-Date-to-Month-Display-112000
Regards,
Cameron