How to integrate PGP using python
Hello teamI am currently trying to encrypting the message using PGPY library on python side so we can generate the claim for front end to use to integrate dashboard through pgp SSO. However I am stuck at the `sign` stage , all the signed message seems not able to be decrypted on Gooddata side, error: The error message is Cannot decrypt SSO message from sso provider=pgp-test.polyai-test.<hidden> Invalid sessionIdError code='sso.decrypt'Request id='aN3MEuAqWGt8SSrK:woOj0utfTAwppYz4' Look like pgpy only support clearSign by looking at the source code. ( At least that’s what I think why Gooddata cannot decrypt it) I wonder if there is any suggestion on how to encrypt the message using python instead of using gnupg ? That will be super helpful ! Thanks so much
How can I custom a attribute or metric in Date format?
Hi,I want to get the latest Date group by a attribute in mm/dd/yyyy format.My code is :select MAX(Date (Ticket Created Date)) BY EntityIDAnd I edit “Metric format” to “mm/dd/yyyy” format, but it doesn’t work.Do you have any better idea?Thanks for your help!
GoodData.CN Internal Server Error
Hi!We’ve encountered some strange error and we cannot find any way to identify the problem.We’ve using GoodData.CN development edition in docker container.The issue comes up after a minute or so after opening “Analyze” tab:We can’t do anything after that.Here are the logs from the server:ts="2021-06-30 08:17:07.585" level=ERROR msg="Failed to start computation" logger=com.gooddata.tiger.grpc.client.aqe.AqeClient thread=grpc-default-executor-6 spanId=13ea4090fa414b5e traceId=13ea4090fa414b5e exc="errorType=com.gooddata.tiger.grpc.error.GrpcPropagatedServerException, message=UNKNOWN: ,<no detail> at com.gooddata.tiger.grpc.error.ErrorPropagationKt.convertFromUnknownException(ErrorPropagation.kt:108) Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException: Error has been observed at the following site(s): |_ checkpoint ⇢ Handler com.gooddata.tiger.afm.controller.ElementsController#processElementsRequest(String, String, ElementsOrder, boolean, boolean, String, int, int,
Calculating how many days are invoices past due
Hello there. I uploaded our invoice data into GoodData and I would like to create a report where I will see how many days are open invoices past due. I do not have this number in my source data, I have just due date. Is it possible to calculate it? Thank you. Simone
DateDiff in MAQL?
Hi there everyone,I was just wondering if there is a simple way to perform a DateDiff function in MAQL. More specifically I want to be able to count number of days between Order Date and Today. I will be using Order Status to determine whether the order was completed and this MAQL metric would help me in highlighting those that take too long. Thanks a lot,Tomas
How do I create a metric with I am trying to count records that have a NULL value
Hi I have a fact that can be Null at times.I can count the records where it is not nullselect count(attribute) where fact > 0.I am trying to count the amount of records that are null.I do not see anything in the MAQL guide for that. Is there a way?I tried fact = 0 even know I know null is not 0.I tried fact <=0 Neither worked.
How To Ensure A Metric Available In Analytics Designer
Hi I created a metric based on two values that I’m using in an insight. However, when I use the metric ( a measure that simply chooses which of the other two measures should be shown) I get a message saying “Sorry, We Can’t Display This Insight”. And then when I use other data values, it moves into “unrelated data measures” Do the metrics need to be applied to the LDM? Or do I need to somehow associate the metric with a given dataset? Thanks James
Timestamps - I need to calculate how many users were active each minute, having single intervals of their activity
Hello!The problem I’m struggling is how to create an AMR (Average Minute Rating) using MAQL. For simplicity I started with one day period when I want to observe how users activity changes over time (for example minute by minute). So I have data of a form:userID start time - atribute refering to Start time table having M, H, S values as a facts, start time label as a key HH:MM:SS and an atribute start time [min] HH:MM start day - date end time - atribute refering to table with a structure like Start time table already described end day - date activity detailsI was able to build a very inelegant vay to find out how many unique users were active during particular hour (e.g 20:45 HOUR = 20, MINUTE = 45), but with one major drowback which is that I need hour and minute as a variable to do those calculations. Here’s the MAQL form:I need solution that could be visualised - for every minute, automatically. Hoping for your help! I would appreciate any hints :)
Building of an MAQL for Rolling Average
We have a table with several records where we need to perform the moving average of the last 90 days considering only grouping by one column (fluxo_id_card).If we don't consider the rolling avarage, the calculation is performed as follows:But what happens is that we need to display these results in a month-to-month progression, where each month we view the average of the last 90 days.For the Rolling average, the basic syntax is:But we don’t have a certain number of lines that each card would occupy, and that Rows Between does not currently support the COUNT function.How can we adapt this calculation to the new context without changing the original table in the model?
Data Permissions, Variable Filters and User Permissions and Custom Roles in GeneralArticle
Data Permissions If you want to restrict the access of your data in a workspace, to some of your users then you can use data permissions. The data permissions are set based on values of the attribute. Think of that, you want to create a report to display the invoice item quantity and the sum of prices on country and product basis. And you want to restrict the display of invoice item data based on the user's country. The users will be able to see invoice items only corresponding to their country to achieve confidentiality. Then the report should filter the data based on the attribute value of the Country attribute. The data permissions are hidden from the user, the user does not know that the data is filtered and can not change the data permission. The value of the attribute corresponding to that user, is passed as a hidden parameter with each query to the database. And the data permission is applied to all of the workspace. In order to understand data permissions better we can give an
How to filter by 2 different dates
I have a data model with orders and refunds in separate tables. I would like to use MAQL to create a metric showing the sum of all the order totals, less the sum of all the refund totals for a particular date and/or date range. The problem is that the two tables are using different dates. The orders table has “date the order was created” and the refunds table has “date the refund was created”. This is fairly simple in pure SQL using 2 sub-queried, Is there a way of making this work in an MAQL query? Edit: I should also mention that the order refunds table is linked to the orders table via the order id which complicates things further.
Linking two unrelated datasets in MAQL
Hello,I am attempting and failing to write some MAQL queries.I have two datasets with the following fields (model simplified from the real world case, which has many more attributes for contracts):Contracts Vendor name Contract currency Contract value in contract currency Exchange Rates Currency Date Rate The Exchange Rates are stored as a rate between the respective currency and our company main currency. The exchange rate for the main currency being stored as 1.I need to build a report which shows list of contracts (by vendors) with several metrics, including contract value:in our company base currency in the currency selected in a dropdown selector of the dashboard (the exchange rate for the current date should be used for conversion)I have been trying to build the metrics, but I have not succeeded yet. I have started with creating a metric which would get the current day exchange rate for each contract:SELECT SUM( SELECT SUM(Rate) BY Date, Currency ALL OTHER )BY ALL OTHEREXC
Already have an account? Login
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.