Topics started by Anna M
Hello,We have a problem probably with a numerical orders. For one of the datasets, the value reached 12086075,0816709 in the database. In the data model, the column is defined as decimal (12.2). Therefore, the value in the dashboards should be displayed as 12086075,08 without any problems, and we still have a reserve of two orders (__12086075,08). However, for unexplained reasons, the number 1 is displayed in the dashboard, when I hover over the number, the value 1.21 is displayed in the pop-up little window. Other numbers for a different products in same table of the dashboard are right (their value is smaller then 10M). Is there a solution on our or your side? I tried to change the rounding and datatype in GD in a various ways, but it didn't help.Many thanks.
Hello, I'm having trouble creating a CostsPreviousDataset metric that shows me the last previous value for the Costs metric. I managed to set the metric to show the value from the previous day (SELECT Costs FOR PREVIOUS (Date (Datasetdate))), but unfortunately the client does not generate costs once a day every day, but the generation is irregular - it can be once every three days or, conversely, four times a day etc. and the client needs to see a comparison with the previous dataset (not with previous day). Each dataset is marked with a unique integer DatasetID, but I couldn't figure out how to build the formula correctly in MAQL. Thank you for help.
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.