Pritesh Member

Hey Naveen - Sorry, couldn't figure it out. I suggest post it as a new thread on community so someone who've encountered similar issue can help.

Hi Naveen, 'Query' not defined. Can you paste you code snippet to get more idea? It's javascript legacy api object so shouldn't happen. You cannot refer your Domo dataset directly in your DDX. You have to first map the dataset(s) that you want to refer in your DDX by choosing them in your mapping section (as dataset0,…

Thanks Coleman - I've sent you my quick video…

"self" card means, clicking the card on which I've applied interactions settings. Let me explain in other way: I've three table cards on my dashboard (let's call them Table1, Table2, Table3). If I change interaction for card "Table1" (by going "Card interaction settings" and uncheck the "Enable interaction filters" it…

Yes, I did that, however it doesn't apply to the "self" card (on which user clicks)…

I'm trying to prevent this… If any user clicks on a value in the table, it applies filtration on all the cards, including that very card. Even if I manually remove interaction from all the other cards, the self card still get affected by this interaction. For our users, it's very annoying and completely irrelevant (to…

Not sure if using API directly works from the DDX form window console as I was not able to get data with that. I could finally make it work by using the Query object, however - as following… var version =''; var query = new Query(); query .select(['Version']) .groupBy('Version') .limit(1);…

Hey @james_kibugu - Not sure if you could resolve this, but if you're trying to pivot your data on column names which are numbers, then you might get this error.

Hi @GrantSmith - Thanks for the response. But I just want to populate the returned data from this query in an input box, I imagine it's "array-of-arrays" but it should at least show it there right? At least I want to confirm that the query did work — I saw in one of the articles that you could do "console.log()" and…

Hi @PD If you have a complex requirements & an external system not listed as connector in Domo and nothing works, then I suggest you try Jupyter Workspace. It has super flexibility with python in terms of fetching data, transformation and you can do anything you want. Thanks!

Hi Nathan, I don't have experience of embedding dashboards. But did you try applying PDP to your dataset columns that you wouldn't want to appear for public view? Ideally, it PDP should also apply to the dashboard or other elements where you're sourcing this dataset…

Hi @rco - Thanks for the response. I figured that the issue was the column name as integer. In my case, the column names were 101, 102, 103 and so on… which was causing this. Converting the column contaning this numbers to "String" type helped resolving the issue.

Hi @JacobFolsom - Thanks for the response and suggestion. However, in this case it wouldn't help because the NULLs are generated real-time while pivoting it. Please see an example below to further explain this: For e.g., if you have flat data like below (where you see Mary doesn't have a row for .NET and Mike doesn't have…

Hi - rank() and count() did the work!

Also, if there's only one group, then lead/lag doesn't work at all!! So, in that case, I just want to punch '1' for the last row. Is there a way to use CASE..WHEN..END to punch a value for the last row? something like... CASE WHEN CURRENT_ROW() = LAST_ROW() THEN 1 END…