-
Find the source table of an API connection
We have a data table that nobody seems to know the origin. All we know is that it is an API connection. Is there a way where we can see the API code within Domo to see what the source data is for this table?
-
Stats for number of Cards per Page
Is it possible to get the following information on a card? List of Pages Owner of Page Created Date of Page Last data of data refresh Number of cards on the page I've tried doing this using Domostats data but can't find a dataset where I can get this information, especially the count of number of cards per page. Any…
-
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…
-
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…
-
Text Summary Number
I have a dashboard where I am using several summary numbers in a text box. For each number when I save the page I see a dotted/dashed line under the number. Is there a way to not show this dashed line? Any formatting that I need here? This picture has an example of it, the dashed lined under the $496M number:
-
Summing a Max or Level of Detail
My data has row count information that is duplicated or reported on a Column Name basis. I need to be able to sum the max of each dataset name, or sum by level of detail - column name. For example in the data shown below. The row count for 'KPI DOC DOE SUB BE - SBE as category' is 5,013,614,211 and the row count for 'MKTG…
-
Grouped Bar with two categories and trend line
I am trying to create a bar chart with two categories, quarter and region, and then show a trend for each region across quarter. I am able to that by using a Grouped Bar chart with 2 Categories and a Series. But then I need to add a line that shows the average across quarters for each region. The chart would look like…
-
Sort a Pivot table
Hello All, I am trying to create the beast mode for sorting the Pivot table, please see the explanation below. I have a pivot table where I am trying to have sorted at the Channel attribute level by sorting on the combination of Return_V + Reg. I have created a beast mode to do this but it is currently sorting at the lower…
-
Deleting users creates Social accounts. How to delete or remove users
I noticed when attempting to remove users from our instance that when they were deleted it seems a Social account was created from them using only their user ID. Therefore I have to delete them twice. Has anybody else seen this behavior? Why are these accounts created and shouldn't a user be removed when they are deleted…
-
Concatenate values to http: to make a link
I have a dimension called URL which multiple values which look something like: //en.wikipedia.org/wiki/Lake I want to take this value and concatenate Https: to it so it will show: Https://en.wikipedia.org/wiki/Lake and create a hyperlink to the web page. I've tried this: CONCAT('<a…
-
How can I create an anchor so that I can create links within a dashboard
I want to build a small Navigation menu at the top of my dashboard and then have links in that menu that link to different sections within the same dashboard. So, how can I create anchors at the individual sections on my dashboard and then create links to those anchors within my navigtion menu? Something like this...The…
-
I need to export a list of attributes from my data table
Is there a way to create and export a list of attributes from my data table? I don't want the entire table with all of the data, just the attributes. Can I export this?
-
Documentation on Pivot Table and Mega Table
Does anyone know of any good documentation on the new Mega Table? Just wondering what are the benefits and when I should use a mega table vs a regular table? I see the difference with the new Pivot Table but wondering about the Mega Table. Any information?
-
Data Table and Page Filters
How do I change the data table that my page filter is referring to? On my page I have cards that use two different tables but when I create a page level fitler it seems to default to table A, however I want it to use table B so that I can filter using attributes from table B. How can I select which table my fitler will use?
-
Change a number to a text
I have an 'ID' field that has been imported into Domo as a number but I need it to be a label or text. I can see how to go from a text to a number but how to go from a number to a text? What is the beast mode logic that will allow me to make this update?
-
The number of views of a page
We have created several dashboards and I'm wondering how we can see the number of views, by day or by week, for that dashboard/page? When I go into the activity log of the admin tool I can filter for the page object but the small cards on top of that page do not filter accordingly. So, I can see all of the views and…
-
Background images to Domo stories
I was reading through a previous thread asking about this. This feature was displayed at Domopalooza in March and then it was noted in the latest release of late June or early July but I still don't see how to insert an image for use as background on a story page. Am I missing something or is it still in beta and not been…
-
Number and text in summary value
I need to show a value along with text in the summary number. I know this can be done by concatnating but for some reason I can't get the value to show as a summary number. This is what I need: Show a count of distinct records (which is 10,232) and then add some text. The issue is when I concatnate the count(distinct…
-
Move a Company Sub-Page
Is it possible to remove a Sub-Page that is under a Company page and make it it’s own Company page? I've seen this discussed in the Domo Community before but it was just noted as a suggestion and given to the development team. Has there been a solution to this? For example I have Page 1 and Page 2. Page 1 is a Company page…
-
how can i duplicate a data table
How can I create a duplicate of an exisiting data table in order to capture all of the beast modes, etc.?
-
Running Sum with Stacked Bar
I would like to build a card to show results by time period but also add a line to show the cumulative percentage. Something like the image I have attached. I can build the bars, but how do I add the line that is a percent of the total over these time periods? Thanks.
-
Filter for x-axis values
Is it possible to filter for the values that are used for the x-axis on a bar graph? For example, have a chart that is currently showing volume by month. I'd like to have a filter that will allow the user to switch the x-axis values between month and week. Is it possible to do? I want to allow the users to switch between…
-
Is it possible to change the font color on the value number in the Spark Line chart type?
Is it possible to change the font color on the value number in the Spark Line chart type?
-
Beast Mode Manager and Back Button
I have two questions...First is, do you know when the Beast Mode manager will be available? Second is, are there any plans to include a 'Back' button in analyzer so you can make a change, i.e., change chart types, and then click back before committing your changes?
-
Error comments for beast mode and SQL
In writing a beast mode or a script in a data flow, the error message that can be generated is not helpful. You just get a message that says 'syntax error' or something like that...are there any plans to improve this so that when writing a script you could see an error that would better direct you to the problem?
-
How can we enable the Stories Feature?
-
Scheduling an update of CSV file
Is it possible to schedule an automatic update of a CSV or Excel file? I can connect to my file and update it manually, but is it also possible to schedule an automated update? How can if find out how to do this, if possible?
-
Using SUM and MAX
I am trying to get a quarterly view of a value where Q1 and Q2 are full quarters and Q3 is a year-to-date calculation. So my table is showing Quarters as rows. But when I try to pull the data using a beast mode like below, I get errors because I'm using the SUM aggregation with the MAX for the date (or the number of days).…
-
How can I sort the legend values in a Pie Chart
Is it possible to sort the order of the values in the legend in a Pie Chart? I'd like to sort this to read: * High Engagement * Medium Engagement * Low Engagement * Not Engaged But by default I am getting this:
