To GoodData homepage

Topics started by Anna M

2 Topics

A
Anna MNew Participant
asked in Metrics and MAQL

Creating a metric that shows the last previous value generated irregularly

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.

3
Michael Ullock
GoodData Employee
2 years ago
A
Anna MNew Participant
asked in Dashboards and Reports

Displayed number differs from the dataset

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.

1
Joseph Heun
GoodData Employee
1 year ago
Welcome to the GoodData Community!Cookie settings