I have troubles with DOMO and can´t figure it out without adding (hopefully) unnecessary data.
We run a daily update on costs on an external service via Excel upload.
In dataflow I join daily costs from the previous year.
We don´t have costs on every day, but we still need to run it, so costs from last year are included.
I use a schedule in dataflow, so data will be still updated without updating the datasource.
As you can see we don´t have costs for December 18, 2018, but we do have costs for December 19, 2017, so this row must be included in the output.
Within dataflow I can see the correct figures, but in the output I get the following result:
On the 6th of december I updated the datasource the last time. But I set the update trigger to schedule so the data shouldn´t stop at the 6th.
Could someone explain me if I need to change some settings or something in DOMO?
I'm happy to help, but I don't think I fully understand your question. Let me summarize what I understand (also one question), and then please correct me.
I wonder if the output dataset hasn't updated since 12/6 because there hasn't been an update to the source dataset since then. You should be able to tell what is happening with the dataflow by clicking into the dataflow details and then looking at the "History" tab. If you mouse over the "..." button, it should give you some detail about the result of the dataset run. Additionally, you can click on any records of a dataflow run to see yet more details.
I hope this is helpful - but I might have missed the point entirely!