the_tree Member

Looks like also if the dataset is written from the API, it can be written to

This is about writing to an existing domo dataset, not creating a new one which we can do. It appears it is not possible from a security perspective Thanks!

This is intermittent, sure its a bug if @domo wants to look. Closing it.

After just randomly looking for stuff, we found you can get this with QuickBooks Online Advanced Domo Cloud Connector, using the P/L Detail object.

got it- using an alternate aggregation does make it render correctly. and I figured out that the sum of 1 aggregating across the number of records in the test dataset did come out to 179. mystery solved, thank you.

Thank you, sorry, I missed that last part, makes sense and it works

So whether I use 1 or sun it shows up as 179. Any other insights out there as to why?

It works perfectly everywhere else, and is found in the domo docs as valid syntax

I updated the question above