To GoodData homepage

Replies posted by Yurii Budgetman

4 Replies

K
GoodData Employee
Kyle ShimekGoodData Employee
published in Metrics and MAQL - KB articles

Using TOP or BOTTOM to filter a MAQL Measure in GoodData.CN

Much appreciated that you found time to reply, Kyle. The solutions you've suggested look interesting. I'll try to implement them. But in general, yes, I was about to based on some metric value to display TOP-3 attributes. Anyway, thank you one more time! 

1734
K
GoodData Employee
2 years ago
Jacques Sham
GoodData Employee
Jacques ShamGoodData Employee
published in Metrics and MAQL - KB articles

Running Total Function in GoodData Platform (Sum vs Runsum)

Thanks for a quick reply but it doesn't work on my end. And I can't use the pf except option, as I need to roll data using this attribute on board to get different TTM figures :) The row data coming from the stores on daily basis. In this case, I assume the Row in this syntax will mean each Day, and not Month as I need. I did a very simple formula in the past, which just add up twelve month in row. But is there a smart way of doing the same? SELECT ( (SELECT REVENUE) + (SELECT REVENUE FOR Previous (Month (Worked Date))) + (SELECT REVENUE FOR Previous (Month (Worked Date), 2)) + (SELECT REVENUE FOR Previous (Month (Worked Date), 3)) + …/Yurii B

3376
M
GoodData Employee
8 months ago
Jacques Sham
GoodData Employee
Jacques ShamGoodData Employee
published in Metrics and MAQL - KB articles

Running Total Function in GoodData Platform (Sum vs Runsum)

Hey Jacques and thank you for the article!I have a challenge to calculate a TTM Revenue (trailing twelve months). I created a metric with the following syntax:SELECT RUNSUM (select Inv. Amount (Converted) Where Month/Year (Worked Date) BETWEEN THIS - 11 AND THIS)But when I'm adding a report into dashboard, GD cuts the data and displays only month (depends on the Data filter)Basically, if I take your Diagram 5: Revenue and Total Revenue YTD, as an example, I need the sum Revenue for the period (11-2017 - 10-2018). And by using a Data filter (Month/Year (Worked Date)) get different values for the last 12 months (incl. selected month).Please advise. Thanks, /Yurii B

3376
M
GoodData Employee
8 months ago
K
GoodData Employee
Kyle ShimekGoodData Employee
published in Metrics and MAQL - KB articles

Using TOP or BOTTOM to filter a MAQL Measure in GoodData.CN

Hey Kyle, Thank you for the article. I have a question. Is is possible to display a Top-(...) attributes of a metric?For instance, I have Industries and Revenue. And I would like to show the TOP(1) (just one) Industry as a Key Metric on my dashboard. I need the Name without any figures Thanks in advance!/Yurii B

1734
K
GoodData Employee
2 years ago
Welcome to the GoodData Community!Cookie settings