-
Built in data table functionality & arrows
Hey guys. Weird ask here. Boss is wondering if I can make a visual that gets rid of the light blue bar (Revenue) but keep it in the data table below. Reason being is so I can have two scales for the values instead of the three, which is why the scale for the light grey bar is messed up. She is also asking for up and down…
-
Duplicate value handling in ETL
I have a column where there are around 34 values that are duplicated for one line that is supposed to be for two people. See picture for example. Ideally it'd be great to have one formula that can distinguish where the break would be so I don't have to manually create 34 lines of code, and have to continually add lines…
-
How to recreate this visual in DOMO?
I have all the data needed to make something like this, I just haven't found a setting or chart type to make this. The problem is getting the table to be multi-tiered with column headers able to stack under like in the image. Just wondering if anyone has any idea or knows of a chart type, brick, etc to help me achieve this.
-
Follower Count, Post count for Social connectors
Hi all, I have been having issues with finding how to get follower counts and posts by month through the connectors in DOMO, specifically for Facebook, Instagram, Twitter (X), and LinkedIn. Right now we are filling out a Google Sheet that looks like the picture below. I have been looking for the right connector with the…
-
Can I omit certain values on line graph from being calculated in avg line?
I have an interesting case here, I have a cost per lead value being graphed by week for the past 9 weeks. Only problem is that when there are no leads the value is blank and the line breaks. I can fix the problem by using a beast mode to say when there are no leads to just zero out the Cost per Lead value. When I do that,…
-
Pinterest authorization issue
Hi all, having an issue with the Pinterest connector. It has run fine up until July 14th. It throws out this error, "Domo is ready, but Pinterest Ads returned the following error: Authorization failed." Do I need to do something in the actual Pinterest account? It says that Domo is ready so it is obviously a problem with…
-
Global date range filter in dashboard, have it compare to exactly a year ago in guage card type.
I have a dashboard that displays metrics from social media platforms, and I would like to apply global filters so the client can filter specific dates, but then also show what those values were exactly a year ago. Example: Say the client wants to see total impressions for April 12-17, 2023. I would like the card to filter…
-
Omitting rows in pivot table
Any way I can omit this section in a pivot table but keep the 2021 Total?
-
Totalling certain rows
I have a question about totaling data in tables. I have two sets of data from different time periods 2021 & 2023, and I'd like to sum the respective metrics for each. I have two different tables present that may aid in getting this solution done. For the first image I want to add a column after the 2021-12-01 column to…
-
Sum column when i have duplicates in other two columns?
I have these columns and I would like to sum the cost column only when the Publication and Year column have duplicates, so I can see the cost per Publication per year. Brain fart, I am assuming this is pretty straight forward? I'd like to do it in ETL if possible. Is there some SQL I can utilize to do this in the formula…
-
GA4 campaign and session campaign data Joining question
I have a unique question… some context: I have a dataset from the Google Analytics 4 connector that has 5 columns that I am grouping by with one of those group by columns being the 'campaign' dimension. The other dataset in the join has 4 of the same columns but the fifth one is a 'session campaign'. The two datasets are…
-
Is there a way to store a beast mode in a filter on a dashboard?
Is there a way to instead of having the beast mode in our cards for the guage multi value visual (Impressions, Web Page Visits, Visit Rate, etc.), have it in a filter that links to the cards in the campaign? Instead of having a static last 30 days vs previous 30 days, our client suggested that it would be great if there…
-
How can I change the order of columns in chart?
Hi guys, I have been trying to reorder my chart chronologically backwards. I have 3 columns that I want from left to right, Current Year, 3 years ago, 5 years ago. The table is transposed. Every column header on the left (transposed) is a beast mode. I have tried clicking the arrows next to 'Year of Tour' and it never gets…
-
Is there a reason why you cannot change the legend labels in a Period over Period chart type?
I'd love if there was a quick way you could change them like you can to the y-axis for example when you click the dropdown. I know there is a way in a normal bar + line chart to make a beast mode for the time period you want and add it to series to manually plot the bar and line against each other a year apart but I have…
-
Ability to edit/change legend labels in period over period charts
Being able to change the legend labels in a period over period chart tyoe would make a huge difference in my workflow day-to-day. Instead of having to write multiple beast modes and adding them to series just to have the ability to have a dfferent legend label show up is too much work for what it does. Allow the ability to…