I have a dataset I needed to recreate for various reasons from an existing dataset with pdp. i want to be able to copy the pdp policies from the orig dataset to the new dataset. How can I do that?
In most database systems, you can create a join/view on date ranges like so: SELECT * FROM A1 JOIN A2 ON A1.ProductID = A2.ProductID AND (A2.SalesDate >= A1.StartDate) AND (A2.SalesDate <= A1.EndDate OR A1.EndDate IS NULL) However, a DataSet View in Domo only seems to allow joins on exact values and does not allow ranges…
Hello everyone, I am struggling with the syntax a bit on how to count blank cells/null values in a column. Basically what I'm doing is COUNT(CASE WHEN column name IS NULL) Would greatly appreciate any help!
Hi, I am trying to upload a data frame from R environment to Domo using ds_update. One challenge that I am facing is that somehow DOMO automatically changed one column into Date, from numeric. Because the value in that column ranged from 0 to around 890 thousand, I guess DOMO thought they were numerical date… (like in…
I have created a view as an admin on top of an ETL and this view is shared with four groups. However, after some time I observed that individual users are being added within the user group, even though they are already members of the group. What should I do to prevent individual members from being added?
Hi, First time using Domo. I have a highly relational database with about 20 tables in postgresql. Should I flatten these tables in pgsql before importing to Domo or should I be importing all 20 tables and doing the joins in Domo? What is best practice. Thanks
Hi, I'm new to domo and was just wondering if anyone could generally tell me how I can get data from a dataset in domo in a ddx brick? Thanks.
Hello, When I click on a specific dataset (for which I have full edit access to) I seem to not see any of the tabs at the top like the overview, data, cards, etc. I thought maybe I have restricted access but if I manually input in the url "/data/table" after details, I can see all of the data. Any idea how to bring these…
Hi Domo Community, I'm working on improving data visualization in Domo and would love your tips. Any advice on creating dynamic dashboards and using advanced charting features? Thanks,
Hi everyone, I would like to create a calendar table based on an orders data base, based on min and max date from that. Do you know a way to do it? Thanks for your help Eduard
It looks like you're new here. Sign in or register to get started.