Joining 2 datasets based on between condition.
Hello, I have two data sets that i would like to join based on a between condition. The "Join data" available in the ETL shows only inner & outer joins. Where can i do custom joins? Here is the detailed scenario. dataset A has 2 columns - clicks, date dataset B has ID, start date, end date. I need an output with B.ID,…
How to create date filters at dashboard level?
Hello, Can someone suggest on how to add date filters at dashboard level? I would like to provide the ability for users to select the time period for which they would like to view all the cards inside the dashboard. Is it possible in Domo? Thanks!
Did anyone receive this error message in SQL data flow: BLOB/TEXT column 'ds-value' used in key spec
Hi, I am receiving the below error message while creating an index on a column. Did anyone experience this issue? The database reported a syntax error. BLOB/TEXT column 'ds-value' used in key specification without a key length Thanks, Srujana
Re: Window functions missing from MySQL
Hi, My data source is a flat file from FTP and i am using the SQL data flow in Domo for data transformations. I have a need to use rank function and am wondering if i can use rank() over window partition by method. I can use the MySQL method mentioned at below link, but the window method is throwing errors. Does the…
Is it possible to create drill down view while using power point plugin?
When using power point plugin, is it possible to create a drill down view for a card?
What is the best way to pull Adobe Analytics in to Domo?
Hello Domo - Adobe Analytics Ninjas, Is anyone aware of the best way to extract the full historic data from Adobe Analytics and set up daily data append? I see that the Adobe Analytics regular and the advanced connectors have limitations in terms of maximum elements being only 4. Email connector doesn't see to have the…
Creating a grouped bar chart with multiple columns
Hi, Can someone help with how to create a grouped bar chart with values from 2different columns. Eg: dataset has 3 columns; date, apple sales, banana sales. How to show in a bar chart with date on x axis and apple sales & banana sales side by side in a grouped bar chart for each date? Thanks in advance!
Linking Cards in a Domo Dashboard/Page
Hi All, Can someone help me with how to link the cards inside a dashboard. I basically want the other cards to update and show the corresponding data only, when a user clicks on a specific catergory in one card. For example if there are 2 cards; one with overall daily revenue and other with product category. If a user…