To GoodData homepage

Replies posted by B. Logan

2 Replies

B
B. LoganNew Participant
asked in Metrics and MAQL

Issue plotting RUNSUM without data at regular intervals

Hi @Moises Morales, Thanks for the response. Is there any function to check if there is an empty/missing value? If I could at least determine that data is missing more easily I might be able to easily to add null/zero values. It still comes down to the missing data is across many sources so even knowing where there are gaps is difficult to track down, unless I happen to have it graphed and can see the gap. 

3
Moises Morales
GoodData Employee
1 year ago
Jay Finegan
Jay FineganParticipating Frequently
asked in Metrics and MAQL

RUNSUM doesn't seem to like intermittent data

Is there a more official way around this? I’m running into the same problem where I’m trying to calculate a runsum on expenses across multiple projects and plot this by month and week in two different graphs.  Not every project has consistent expenses being logged and while I tried to create a metric that creates a zero value it is not working correctly. Basically there are gaps wherever there are no expenses logged and it is unreasonable to attempt to manually enter $0 expenses across a large number of projects and time. This seems like a major flaw in the runsum function. 

5
B
1 year ago
Welcome to the GoodData Community!Cookie settings