Hello,
i am creating an insight where the ‘year(Reporteddate)’ in the columns has to be applied only for the ‘Sum of Claims Opened’ in the metrics as shown in the attachment.How to do that?
Best answer by Michael Ullock
View original
Userlevel 1
Hi Preethan,
thanks for reaching out.
You metric in this case would look something like this: SELECT SUM(Claims Opened) BY Reporteddate (Year)
You can refer to the following documentation for more details on this:
https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/maql-analytical-query-language/maql-expression-reference/granularity-keywords/overriding-insight-attributes-with-by-keyword/by/
https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/dates-and-times/
Also, I would like to point you to our free GoodData University courses that you might find useful:
https://university.gooddata.com/getting-started-with-maql
Hello,
But the metric ‘ SELECT SUM(Claims Opened) BY Reporteddate (Year) ‘ suggested here do not display the deserved output for me.i want to display the year(reporteddate) column values as column names and the sum(claims opened) as the row data in it in the insight, Since,there are multiple facts already given in the insight, all the metrics such as sum of claims closed and sum of Expense paid are all being considered as the row data as shown in the attached image.please do let me know the solution.hope the requirement is clear now
Hi,
again to be precise, what my requirement is that in the attached image for example, month/year (activity) comes under the columns and # of activities comes under metrics but in my case there are multiple are present in metrics such as sum of claims closed, sum of claims opened etc and i want to consider only sum of claims opened.How to do that??please do let me know
Userlevel 3
Hi Preetham, Is this similar to your other post about summing across columns? If this is the case, I’m afraid it is not possible and we will consider it for product feedback.
Reply
Login to the community
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Social Login
or
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.