Solved

Incorrect filtering of running sums

  • 22 June 2021
  • 9 replies
  • 169 views

Hi! I’m facing following problem

When I choose Sum in measures and set date filter to All time, I get these data

 

When I set data filter to This year I get the same data but filtered by year 2021. And it looks right.

 

When I choose Running sum in measures and set date filter to All time, I get running sums groupped by years. It’s still right

 

When I try to filter running sums by This year I expect to get running sum filtererd by ths year, in this expample - 1327. But  I get the Sum (not Running sum) - 51. Is there a way to get what I expect?

 

icon

Best answer by Michael Ullock 24 June 2021, 14:09

View original

9 replies

Hi Vasiliy, 

Just under your two metrics, there is "+" button for creation of Calculated measure: 

There you can select a "Ratio" calculation of your two metrics:

 



More complex measures would require certain knowledge of MAQL and such measures can be built via API, as mentioned by Michael before.
You can find some examples here and you can also check this article below:

 

 

Thank you, Iva!
I calculated desired measure (0.54 in the example below) but I need to show only this amount as headline (not within table). How is it possible to do? 
 

 

Userlevel 3

Hi Vasiliy, 

Just under your two metrics, there is "+" button for creation of Calculated measure: 

There you can select a "Ratio" calculation of your two metrics:

 



More complex measures would require certain knowledge of MAQL and such measures can be built via API, as mentioned by Michael before.
You can find some examples here and you can also check this article below:

 

 

Hi!

Could you please provide me an example or tutorial how can I calculate division of these two metrics using  GoodData.CN?

 

Userlevel 2

Hi Vasiliy, 

currently in GoodData.CN the metrics are managed via APIs.

Please see the following article which will help you create your metrics:


Please note: The Metric Editor in GoodData.CN is planned for Q3 of this year: 2021

Best regards, 
M. Ullock 

Hi Vasiliy, 

please see the following article which will guide you though creating metrics:
https://help.gooddata.com/pages/viewpage.action?pageId=86788051

Best regards, 
M. Ullock

I’m using  GoodData.CN. Is the Custom Metric Editor available for GoodData.CN?

Hi Vasiliy, 

please see the following article which will guide you though creating metrics:
https://help.gooddata.com/pages/viewpage.action?pageId=86788051

Best regards, 
M. Ullock

Why can’t I see the Manage tab in my interface?

 

Userlevel 2

Hi Vasiliy, 

please see the following article which will guide you though creating metrics:
https://help.gooddata.com/pages/viewpage.action?pageId=86788051

Best regards, 
M. Ullock

Hi Vasiliy, 
 

this is actually the expected behaviour and is working as designed. If you would like show the complete total - As in your use-case "1327", your metric would look like this:

 SELECT RUNSUM (<Your-Fact>) WITHOUT PF

Here is some additional articles that you may find useful:
https://help.gooddata.com/pages/viewpage.action?pageId=86795471
https://help.gooddata.com/pages/viewpage.action?pageId=86795498

Regards, 
M. Ullock 

Where should I write this query here?

 SELECT RUNSUM (<Your-Fact>) WITHOUT PF

Userlevel 2

Hi Vasiliy, 
 

this is actually the expected behaviour and is working as designed. If you would like show the complete total - As in your use-case "1327", your metric would look like this:

 SELECT RUNSUM (<Your-Fact>) WITHOUT PF

Here is some additional articles that you may find useful:
https://help.gooddata.com/pages/viewpage.action?pageId=86795471
https://help.gooddata.com/pages/viewpage.action?pageId=86795498

Regards, 
M. Ullock 

Reply