To GoodData homepage

Replies posted by tylervaleo

4 Replies

L
LenaKnown Participant
asked in Metrics and MAQL

How can I custom a attribute or metric in Date format?

Hi Lena,  my apologies for not initially understanding the issue here - please correct me if I am wrong, the issue here is that your metric returns a number, not the date in this format: mm/dd/yyyy. You can use a custom number formating to change the display in the numeric expression. Please see the following documentation that will help you with this:https://help.gooddata.com/doc/en/dashboards-and-insights/maql-analytical-query-language/maql-use-cases-and-tutorials/finding-min-and-max-dates-using-date-arithmetic In the above documentation, we have the following example - you'll need to slightly tweak this for your usecase of: mm/dd/yyyySELECT MAX ((SELECT (10000 * MAX(Year (Date))) + (100 * MAX(Month (Date))) + (MAX(Day of Month (Date))) BY <connection point>)) WHERE (SELECT COUNT(Date (Date), <connection point>) BY Year (Date), ALL OTHER) > 0   This article no longer exists, do you have an updated link for this article?

9
Julius Kos
GoodData Employee
1 year ago
tylervaleo
tylervaleoNew Participant
asked in Dashboards and Reports

Can we Sum or RunSUM based for columns in a table?

In the metric you have created:SELECT SUM(Prio: Low + Prio: Medium + Prio: High + Prio: Critical) The "Prio: Low" and "Prio: Medium" etc need to be individual measures/metrics within the final SUM measure.  With each separate measure you create, you can validate that it is populating data.  If the above doesn't help, I would like to suggest that you try our free GoodData University courses: https://university.gooddata.com/maql-metricshttps://university.gooddata.com/getting-started-with-maql Are you saying that I would require 4 more metrics to show the SUM of those original COUNT metrics that I created, and then I would have to SUM all of those metrics together in the final SUM metric?i.e. SUM(prio: low), SUM(prio: medium), etc,Final Metric: SUM(SUM Prio Low + SUM Prio Medium, etc.)?

6
Joseph Heun
GoodData Employee
1 year ago
tylervaleo
tylervaleoNew Participant
asked in Dashboards and Reports

Can we Sum or RunSUM based for columns in a table?

Hello,  thanks for reaching out. Unfortunately, we do not support such functionality where you can SUM the columns values horizontally. We only support this functionality vertically, as in your screenshot. In this case, you will need to create a metric as you mentioned, where you will SUM the totals of the 4 metrics.  Thank you Michael, In this instance, I’m using a COUNT function for those metrics, counting the numbers of tasks that are listed with that priority against a custom field for severity. I’ve tried a very simple syntax, SELECT SUM(Prio: Low + Prio: Medium + Prio: High + Prio: Critical) and receive NULL values. Any suggestion on how to make this populate?

6
Joseph Heun
GoodData Employee
1 year ago
tylervaleo
tylervaleoNew Participant
asked in Dashboards and Reports

Can we Sum or RunSUM based for columns in a table?

Thank you Michael, In this instance, I’m using a COUNT function for those metrics, counting the numbers of tasks that are listed with that priority against a custom field for severity. I’ve tried a very simple syntax, SELECT SUM(Prio: Low + Prio: Medium + Prio: High + Prio: Critical) and receive NULL values. Any suggestion on how to make this populate?

6
Joseph Heun
GoodData Employee
1 year ago
Welcome to the GoodData Community!Cookie settings