-
Multi value chart with % and number
I'd like to create a card that looks like this. Shows the percentage (of records with a certain value) along with those relative numbers over the total number of records. Is there a way to do this?
-
Filtering table by selecting from chart - or showing hover text
I have a dataset with data along the lines of: UserID - Order Date - Order Number - Customer Name - User Purchase # etc. I have a chart to show first time purchases by users (where user Purchase # = '1'). and then a table below to provide more information on the customer. Is there a way to filter the table by the users…
-
can you share a filter view if you don't co-own the page?
I have a user (with editing access) attempting to share a filter view she created and the share with everyone check box is greyed out. Is this because I didn't make her a co-owner of the page?
-
excluding a card from being filtered by date
is there a way to exclude a card from being filtered by the date range selected? I've got two charts on the dashboard. One will be showing sales data... and I want to filter that by date. But then I have another chart with user information (which provides the customer's registration date, last login, last purchase, etc.).…
-
Is there a way to annotate tables?
The user wants to be able to annotate values in a table (such as below). Is there a way to do this? Basically, she wants to provide some note on particular cells.
-
Compare last 12 complete months to prior 12 months
I want to show data for the last 12 complete months and compare them to the prior 12 months. Is there a way to do this? I created a beastmode (PERIOD_DIFF(date_format(Date,'%Y%m'),date_format(now(),'%Y%m'))) to allow me to filter out the current month (march). However, the chart will still show March of last year on the…
-
Formatting a table
I have a table which I would like to have sub-rows providing sub-total numbers for each month. It currently looks like this. How do I get it to look like this? Where the total rows are emboldened, the color coding applies to their respective columns, the “Count x/y” is replaced with Total in the Retailer field, and the…
-
Is there a way to create a filter for line charts
Is there a way to have a multi-line chart connected to a filter which can allow a user to select which metrics they want to see on the chart?
-
Adjusting Axis values vs values on line chart
For line charts (or any type), is there a way to differentiate the value format on the axis and the values displayed on the lines? For example, below, I'd like the left axis to display percentages with no decimal (5%, 10%, etc. -- NOT 5.00%, 10.00%), but for the values displayed on the line nodes to have two decimals…
-
Is there a way to have a dataset sorted alphabetically?
I have several datasets that have over a hundred columns... and I'd like to have them sorted in alphabetical order. Is there an easy way to do this without having to go through and manually adjust their order using Select Columns in an ETL?
-
Disregard this.
-
Grouping data by month in table
Can someone advise on how I can create a table which groups the data so it is one month for each row? I tried Group by and it just formats the date column fields to the month-year. But continues to track each individual date separately.
-
How to work a dynamic textbox
I want a simple card that says "Data through [Date]" where date is the latest/max date value in my dataset. How can I do this...? I've tried using a Dynamic textbox, but I can't figure how to get this (seemingly easy function) to work.
-
separating Output datasets from ETL
I think I made a a mistake of having 1 ETL facilitate some simple transformations for several input datasets. I have the ETL triggered to run whenever any of them update... but now it occurred to me that the ETL is going to keep running every time one of them updates - and I'm afraid it won't pull in the latest updates…
-
getting the %_name on donut chart slices
Can somebody please, please, please tell me what I am doing wrong with this donut chart??? I want the chart to show the name of the value followed by its count. Like the donut shows in this instruction - https://domo-support.domo.com/s/article/360043429693?language=en_US I can get the count in with %_value... but for the…
-
Disregard - failed to convert value from string to boolean
Can someone tell me why this isn't working....??? Nevermind - I figured it out.
-
Highlight alternating sections of rows on a table (to differentiate based on a single column)
I have a table with a lot of data to show the page history of different users (sorted chronologically by User Pseudo ID). Is there a way to highlight every other section of rows associated with each User Pseudo ID? So the user can easily see each user's page history? So in the screenshot below... the first row would be…
-
Add a column to capture percent of total value for adjacent column
I have a table set up below, which breaks down metrics by various column combinations (Campaign name/source/medium/content). Is there way I can add a column next to visitors to identify the % of the total visitors? So in % column, the value on the second row next to 107 would be 32% (107/330).
-
Remove column from a dataset
Is there a way to remove a column from a Domo dataset? I have a dataset which I am unable to use in an ETL because it contains a floating decimal column which occasionally has the number expressed exponentially which the ETL is unable to parse. And I can't alter or remove the column in the ETL. I'd prefer not to have to…
-
How to hyperlink values in a Mega Table
I have a dataset I am showing in a Mega Table, which contains URLs. I'd like to hyperlink the URLs so the user can click on them and go to the site. Is there a way to do this? I've been trying to following this suggestion:…
-
How do detag a column
I incorrectly tagged a column in a dataset... is there a way to remove the tag? When I click on it, it doesn't allow me to do anything...
-
Quick way to determine number of unique values per column
I have a dataset with over 400 columns... and long story short, there are basically duplicate columns (4 different formats for each field) and I want to select the ones where there are actual values (as opposed to blanks or nulls). Is there a quick way to do this in Domo without manually having to go through? Maybe via…
-
How can I remove all special characters and spaces from values in a field?
I want to remove all special characters and spaces from a field in ETL.... how can I do this? Is there an easier way than having to create an individual replace text line for each specific character?
-
how to split up column based on string of charecters
I want to separate out the SKU that is at the end of a url... how can I do this with the following, where anything following "-sku-" is separated out into a new column? I tried using the split columns function and using -sku- as the custom delimitator, but it isn't working.…
-
removing last 5 characters of a value
How can I remove the last 5 characters of a text value in ETL?
-
ETL run complete, but output datasets still not reloaded
I notice with an ETL I have (with a large amount of data), it takes a while for the output datasets to refresh after each run. For example, the ETL completed over 2 hours ago, and yet the output dataset has still not be updated... Is this a common issue?
-
Struggling with Beastmode formula
For some reason, the following BM formula is not working. I get a Calculation Error: This calculation contained a syntax error. Can anyone advise on what I'm doing wrong here? sum(case when `EVENT_NAME` like 'user_engagement' then `EVENT_PARAMS_ENGAGEMENT_TIME_SEC` end) / COUNT(DISTINCT case when `EVENT_NAME` like…
-
formula to include values that don't contain string
Is there a way write a formula that includes a field that doesn't contain a certain string? So for example, I'd like to name a value in a column based on other columns where if the event_name contains "Add-To-Cart" and the page_location doesn't contain "shop", then it'll be "Add to Cart from XXX"... when `EVENT_NAME` like…
-
Including multiple values on on card
I'm interested in creating a card that will show values from two different columns... For example, I have a table that includes two columns: -Sends -Delivered I'd like a card that has the sum of the Deliver column and also what percentage of the sends were delivered also in that card. i.e. 500 delivers and 75% delivery…
-
understanding null vs blank or empty string values
I've always struggled with figuring out how to filter by fields with nulls vs blanks... for example, if I have a formula to identify if a field is null (this will not work with fields that contain empty strings or blank values, correct...?). I've tried using charlength functions to say (when charlength' is greater than 0…
