-
Issues with Text boxes
I've noticed some serious issues with updated text boxes. I will make a bunch of updates... click out of the text box, so it appears saved. And then when I refresh or return to the page later, it undone my edits. This SO UNBELIEVABLY FRUSTRATING!!!!!!!!!!! What is the issue here with this?? Is there somethign I need to do…
-
Multiple Date Columns
So I have a data set that looks basically like this: And I want to produce a card that counts the number of chats, emails, web, and text tickets by date, but also the number of calls by date. Then I need to sum up all interaction types by date. So for the above example, I would want this as the output: Can anyone provide…
-
Beastmodes capture sales for each of last several months
I'd like to create a table where I show the progression of sales ordered each month per product.... I thought if I could create a beastmode to sum up all the sales for the last month, or 2 months ago, or 3 months ago, etc. I could then just place these in a table. So I created the following beastmode to capture the last…
-
How do I force a Filter to have a value?
I have a dataset that looks something like this: I want to build a card that shows the Q over Q difference and allow the user to filter by Region. But I also need to either have the filter always have a value, i.e., not allow the user to unselect all values, or show the difference between the 'Global' values when none of…
-
How to add a Toggle button to switch between different currencies at Dashboard Level.
Hey there!!! I have data flowing from 2 different regions (USA & Canada), with their respective local currency. Is there a possibility to add a button or something similar, with which I can show the data in a single dashboard but in multiple currencies?
-
Beastmodes getting turned to Text
Hi, So I have been having this problem lately, all of the inputs of my beastmode formula are numbers, but it keeps classifying the beastmode output as Text. All of my columns are classified as floating decimals, there is no text in it, all the nulls are classified as zeros, yet it still keeps it as text even though the…
-
In the data science module of DOMO, is their a means by which to perform a cluster analysis?
I have been requested to do a cluster analyses for the marketing and pricing departments at my company. I am familiar with DOMO, but do not have access to all of DOMO's features. Is their a feature in DOMO that allows for performing a cluster analysis in their data science tool pack? If so, I should be able to convince the…
-
Windowed Function Beastmode Will Not Update Dynamically
Hi I need help using a windowed function in Domo. Here is my formula making up the "Fall Out Rate Average Line" column: sum(sum(case when `CanceledDate` is not null then `Units` when `DeclinedDate` is not null then `Units` else 0 end)) over() / sum(sum(case when `ApplicationDate` is not null then `Units` else 0 end)) over…
-
Can Links to the Parent Page be Disabled?
If a page has sub-pages, clicking/touching the name of the parent page in the navigation will take you to the parent page. Does anyone know how to disable this link? This is not very usable, especially on mobile, as people often accidentally touch the parent page name on the left-hand side rather than the icon for…
-
Maintaining header rows and columns when uploading dataset?
I have a table in excel which has both header columns and header rows. I want to build a dashboard so salespeople can pick which columns they want to display in the table to give to clients. When I upload the dataset to Domo, I select crosstab, but then all of my columns are lost and rows are duplicated for each column. Is…
-
Take large text input as field for filtering?
I have a slicer card to filter zip codes for a large data set. There is a search bar field for finding zip codes to filter by, but say I had a large list/string of zip codes and I wanted to select all of them for filtering. Is there a way to paste this list into a search field to filter them all, instead of selecting each…
-
Is there a way to fix sub-page order for everyone
Is there a way to set the order for sub-pages for others you share it with? Or at least set the default order when they first access it? So for example, I'd like to have the following order in the screenshot... but I notice others see it differently (because I had them in a different order originally).
-
Drill Path Filter to show Specific Apt's without a Specific Procedure
Hey guys, I'm worried that the answer to my question is that it has to be done in ETL, but I'm hoping it can be done as a beast mode. So the data in question looks similar to what I have below: Doctor | Procedure | Date | Apt # | Patient Dr. B | D0330 | 4/1/22 | 80136 | I. M. Madeup Dr. B | D0126 | 4/1/22 | 80136 | I. M.…
-
Complex count distinct
I have a dataset with session IDs and pages... I want to know how many distinct session IDs include a specific page ('ABC'). The trick is one session ID could have multiple rows with page ABC... Session ID -- Page 123 -- ABC 123 -- ABC 123 -- DEF 456 -- DEF 456 -- ABC 789 -- GHI Hypothetically, how do I create a beastmode…
-
STRING formatting with a decimal
Hello -- I've created a dataset with a column definition as: "type" : "STRING", "name" : "SKU" However when I load the data, the "11465730" as "11465730.0". I see that the column is a text field. Why is Domo formatting it with ".0"? Here's a link to the dataset:…
-
Beast mode formula: Case When with distribution points
Hi, I have a question about my beast mode formula concerning a distribution calculation. Currently, I am calculating the distribution points based on the volume. If one product of brand x has been sold in period y, then one customer gets 1 distribution point. It is max 1 distribution point per customer per brand. I have…
-
How to reorder variable categories in legend and how to remove the total section in a pie chart?
I feel like I've tried everything... could really use some advice! How to reorder variable categories in legend? The sorting function is not really working and I would want to avoid renaming the variable categories (this issue is also prevent in other cards). Also, does anyone know how to remove the total section in a pie…
-
Creating a constant value for each month
Hi all! I want to build a Pivot Table Card with columns being each month from start to current date , rows as IDs and each value to be a constant number. However, in the dataset there's one row per ID showing start date, its status and the constant number (ID-1 ; 01/01/2016; active; 150). So, when building the card the…
-
Drill down card with display certain columns when clicked.
I have a bar chart with different events such as cta_clicked, navigation_clicked, media_interaction. I have to create a drill down card but I want to display certain parameters and not the whole table For example, if I click on cta_clicked it should only display columns (cta_title,cta_link_text,component name) . When I…
-
Is there a one-letter abbreviation for month?
I am aware that I can use %b for the abbreviated month (three letters) and %M for the full month, but is there a way to have a one-letter abbreviation for month? For example, "J" for January and "F" for February.
-
How to use Escape characters in Beast Modes?
Hi, I am trying to create a web link for a card using a beast mode and some of the values that will be passed through the beast mode contain apostrophes ' . When they are passed through the beast mode the link is broken because the value is cut off early. For example the value 'Square's Lake' is cut off early and ends up…
-
How do I stop my tile from Aggregating
Hi Dojo! Could you help with this: I see that when I first expand my tile under Aggregation I can choose to not aggregate. however, in the bottom where it says Subtotal/Total under Calculation it is using sum and not giving me a no aggregate function. Thank you!
-
New Descrition format
Hello all, We use to format our descriptions with some information and was formated in a easy to read format, but in this new version was all tranformed in a 1 row, no spaces, bunch of data. we went from this.- to this.- is there any way to apply formating to this new feature?
-
grouping providers by how many times they submit
Hello, another user was able to help me with the formula but I am still working on the graph. formula test123 it counts how many times a provider submits a case, then it segments it into how many cases they submit per year. The system recognizes as a submitted case when there is a date in FirstSetupApprovedDate. Note that…
-
Is it possible to Export the Data Table
I need to compare two different data sets from two different cards and want to export them to excel or csv or the like to put them side by side. Seems like there should be a function to export the data table of chosen columns.
-
Data Table Columns Selected
After I select the data columns I would like to see in the Data Table view from my card and then select Save, those columns aren't saved after returning back to the card. It has reverted back to the original two columns. Is this a known issue or the way it's supposed to work? I have to keep adding the columns back in each…
-
How can prevent aggregation when graph by quarter
Hi I would like to visualize the count of customers by month or by quarter. the data is monthly, so when I graph by month it gives me the correct sum(count). However when I graph by quarter, the sum(count) of each month within a quarter are summed up, which is not correct. The number of customers at end of Q1 should be the…
-
Remove Header Row from Table
I have a simple table where I need to remove the header row and the gridlines. My table looks something like this: Is it possible to format this table so that it looks like this: The Header Row has been removed and the gridlines are gone. Is it possible to do this? BTW, these illustrations are done in Excel. Also, I have…
-
Making dashboards load faster
I have a dashboard with ~150 cards and it takes upwards of 2 minutes to fully load... Are there any suggestions for making this speed up? I tried building views of all the datasets with restricted data for each card (significantly reducing the rows and columns) which doesn't appear to have had any impact... :-(
-
Rookie Question - Reordering data columns for drill-downs?
Hi, I was looking into one of my cards for a presentation and noticed that the drilldown table is in different order from the source xlsx file. Is there a way to fix this?