All
Accepted answers
Hiroshi Sato · Apr 9 go to post

Thank you for pointing that out.

My explanation was incorrect.

In reality, the issue was that the values returned as a result of the following `Group By` query were in uppercase, causing them to mismatch with the matching data prepared on the Python side.

SELECT revenutype, sum(total) from xxx group by revenuetype


# Revenue types and their row positions in RevenueByRevenueType
REVENUE_ROWS = {
   ‘License’:      5,
   ‘Maintenance’:  6,
   ‘Subscription’: 7,
   ‘Training’:     8,
}

Hiroshi Sato · Jun 13, 2023 go to post

Hi, Evgeny

Thanks for your comment.

I have slightly changed the content based on your suggestion.

Hiroshi Sato · Jun 7, 2023 go to post

Hi, Ben

Thank you for your comment.

I have slightly rewritten the content based on your suggestion

Hiroshi Sato · Apr 28, 2023 go to post

Thanks, Iryna
You are right.

Alexey
This is actually a quite old article so that it includes old things
Now we don't need to care about V5.0 thingss at all.

Hiroshi Sato · Mar 23, 2023 go to post

Thanks for pointing that out.
Certainly this method does not give us the answers we are currently expecting.
This article was originally posted in Japan quite some time ago, so it certainly would have worked in past versions.
Anyway, I will try to rewrite this article so that it works as expected in the latest version.