-
Rolling Averages Feature
I was looking for a more flexible way to create rolling averages. Of course possible in a Domo Dataflow/Magic ETL → but then you need to fix it on the periods you want to "roll over". Is it possible in a beast mode or is there maybe a card type/feature that makes it even easier?
-
How come MySQL does not support window function, specifically lag in dataflows?
Hi, I am currently building a dataflow and trying to get the best out of both sql dialect. I use Mysql to order my data (because redshift doesnt order properly) and then use another datflow in the redshift dialect to be able to use window function. What I am curious about is to know why Mysql does not support window…
-
Create Conditional coloring based on a value not displayed in card
All details are summarized here:
-
Waterfall Chart that allows for intermediate results
Hi, we are currently not able to built a waterfall with intermediate results using the waterfall chart in domo. It is somehow possible with a workaround using the bar chart to create bars that reflect an intermediate result step. This would be super useful, since for now we are opting out for other solution that are more…
-
Search Filter in a Dashboard allowing to Search for Titles
Hi, is there a filter card (or other options) where I could place it at the top of a page and would allow me to search for certain Terms? Basically like a cnrl + F functionality (Windows version) but as a visible option? For example, I might have a table that has columns of customer demographics and I specifically look for…
-
Scatter Plot with a dynamic x-axis scale marker?
Hi, I am using this nice feature that allows me to mark the average (median, etc) value on the y-axis, that would also adjust dynamically. However, it doesn't seem it is possible to do so for the x axis. you can set one manually using quadrant lines, but that would require manual adjustment every other day. Any ideas?
-
Is the data restricted for drill downs?
I am building a drill-down but seem not to have the same options as I would building a separate card. Example: I have a stacked bar overview where I am demonstrating the cutomer base by volume over months and by customer types. I am trying to create a drill down where I am showing in a pivot table view where I want to show…
-
Stacked bar Legend not visible when hovering over bar value
Hi, I am using a stack bar chart to show the development for different segments over time. Because there are more than 20 segments, they are not visible all at first look. When hovering over one segment, I was wondering if there is a feature that would bring the segment in the legend a bit up in the ranking? Right now if…
-
How can I color the bar based on a beasmode not directly shown in the chart?
I am trying to color the 2nd (Appointments) bar based on the ratio (Appointments/Target) However, it does not seem possible via the Color under Chart Properties - Is there any other way?
-
Why do all Redshift Datflows (still) convert all variables to lower case?
Hi, we're currently doing an audit and noticed that legacy datasets have 2 versions, with the 2nd version just capitalizing the variable names (often a magic ETL). The first version is in Redshift - building dataflows in redshift is quite popular within our team because it has fuctions that mysql dataflows doesn't have.…
-
Filtering is not supported Error
Hi, I built a Radio Button selector card as a filter for 2 other cards. The 2 other cards are based off of 2 different datasets. The filter allows to filter for degree vs. no degree and the other 2 cards : one has information about average life expectation and the other average earnings. I created the degree field in all 3…
-
Is there an alternative of distinct on for redshift?
Hey, I am trying to build a dataflow using redshift but distinct on is not supported. It's a simple query: (SELECT distinct on ("id") var_list.* from "indicator" as ind order by "id", "rank" desc) Any suggestions for workarounds?
-
How to read and understand error messages in Domo dataflows? (Redshift)
Hey, I am creating a dataflow and using redshift for my transformations. I am getting this error: The database reported a syntax error: [Amazon](500310) Invalid operation: syntax error at or near "then" Position: 888; and I have a couple parts in my query using a then and my query is going up to 33 rows. What is the best…
-
How to create simple tables with both variables created in beast mode, using window functions
Hi, I am trying to partion by a beast mode and then creating a table based to provide an overview of how many agents fall into a certain quadrant. 1. I created a beast mode that places each customer into the scatterplot based on the two score I defined: advisory score= sum(case when product='nx' then 'score' else 0) /…
-
Redshift does not sort properly in a dataflow
Hi I have the following query, which I sort by id and date. The id is sorted properly however the date is still random. The date is in a timestamp format, but I tried casting it to ::date, there was no effect on sorting: select distinct "id" app."App ID", app."Date"::date, app."Device" from "appointments" as app left join…
-
Dropping rows with null values (postgres)
I am building a redshift dataflow and found that the following statement allsow you to delete whole rows, but I get an error: DELETE from "table name" where "variable name" is NULL I use it in a table to transform my data and get tis error: Table transform must be a SELECT clause How come?
-
Can you set target lines in a scatterplot?
Hi, I would like to set target lines on the y and x-axis within the scatterplot but haven't found anything on that topic. I would like to devide where my data falls in into the 4 quadrants. Or do I have to use a different chart?
-
Remove hover values in Bar chart
Hi, I read that you can't remove hover values for the stacked bar, is it the same case for bar charts? Thank you!
-
Barchart with a series of 2 different types (sorting issue)
Hi, I've build a bar chart where I can see sales by sales person. I have a beastmode variable that calculates sales and I dragged into the Y-Axis field and I put into the series field a product field that allows me to distinguish between food and drink items. Now I am trying to sort the bar by sales descending, but it only…
-
Remove hover value that appear automatically (100% stacked bar)
Hi, I am using th 100% stacked bar. I selected some data label setting but did not select anythig under the hover text setting. When I hover over the chart, it shows me onscure values and I want to get rid of these. Any suggestions?
-
Show values in the donut chart
Hi, I am using the donut chart to display values, but somehow there is only the hover option working to show numbers of each section. Is there a way to see immediately how much each section makes up without have to hower over the chart?
-
Empty cells after aggregating and creating a case when variable
Hi I have a dataset that shows a sale/lost sale an agent made on a daily basis. Now I am using the dataflow to get the sales % over the last 3 months (data is only last 3 months) per consultant and want to join it back to the original dataset for later card creation purposes. This following formula gives me empty values…
-
Tenure calculation using differences between 2 dates (magic etl)
Hi, I am creating a new variable using the add formula icon where I am creating time period bins that reflects the tenure of the consultant in reference to today. This is the formula I created: case when CURRENT_DATE() -`CD (Start)` < 90 then '3 Months' when CURRENT_DATE() -`CD (Start)` >= 90 and CURRENT_DATE() -`CD…
-
How to adjust size of the value in the single value card?
Hi, I am using single value cards and would like to adjust the size of the value (font size) inside the card (not of the card) but I'm struggling with that. I know for other cards you can adjust that under General, but there is no option for that in a single value card.
-
Create a dynamic date range with a beast mode
Hi, I want to create a dynamic date range to capture the following period: 100 days ago excluding the last 4 weeks (28 days). The date I want to use is signup_date. Is this possible with a beast mode?
-
Select specific columns for join in Magic ETL
Hi, I am using Magic ETL for the first time and I am using two datasets and a left join to combine the two. I only want to left join one column from the 2nd table, but I cannot find where I can select for that in Magic ETL
-
How to fix a target line independent of filter selection?
Hi, I build a card that shows monthly sales volume (bars) and shows the average sales volume per consultant as a line (=target). Now, I added filters at the top, that allow to select for a specific consultant. I would like to fix the average sales volume, such that when selecting a specific consultant a direct comparison…
-
How to align scales when using bar and line chart
Hi, I am using the line + stacked bar graph, I added a target line (case when date then 20 end) and now I have 2 different scales. I would like the left and right scale align in values otherwise the traget line is confusing.
-
How to add a Target line
Hi, I am looking at how much time consultants spent on the phone and the traget is about 20%. How can I manually add a horizontal line that shows 20%?
-
Filter card: selecting more than one item
Hi, I am using a filter card that affects another card. Now the filter card is set up in a way that I am allowed only to pick one item on it. How do I adjust the filter card, such that I can select several items (ex: several teams, instead of one only)?