-
Remove Duplicate rows in Card
So I have this dataset which has products and their categories in the below format Product Category A ---------- X A ---------- Y B ---------- Z B ---------- X I am trying to build a card which shows the products filtered by categories. For example if I choose Category X and Y in the filter, it should show me one row for A…
-
Pivot Tables
Pivot tabels views are not very clean and clear, any workarounds and tip to it ? Also, if anyone can help how can I set my view like this in Pivit, I am using Fiscal Calendar. Quarter by month
-
Call-out or highlight cards on story dashboard
Hi, I'm searching for a way to call-out or highlight one or more cards on a story dashboard to draw attention to those cards. Initial thoughts have been to add an icon/badge or a border to the card but I haven't been able to find any such functionality. Is there a way of adding a visual cue to a dashboard to draw the…
-
Lat/Long Maps - is there a way to constrain the view to a specific area, based on PDP?
I have customers across the country who want to see where their users are within a specific geographic region (ie customer A operates out of California and only wants to see California users on a map). All other cards in the dashboard the customers are able to see is already filtered to an extent via PDP - is there a way…
-
How to create two running total lines on Y-axis
Hi, I want to biuld a card that has two running total lines and bars by customer A and B. I got the running total bar for both customer A and B but can only get the running total line for customer A. All those 4 metrics are calculation fields. Thanks!
-
Using Images in DOMO cards
I have seen there is an option to add images to table. Is there any option to add images in card directly. My requirement is to compare two numbers(a,b) and dispaly an upside arrow if a>b and a downside arrow if a < b. I am able to do this using an image inside a table but not in a card. Can you help me in this ?
-
Show data for signed in SSO name
I created a dataset containing all IT tickets. Now I'd like to create a card that shows tickets where the submitter is the signed in Domo user. Both our incident registration system and Domo are using SSO, but so far I can't figure out a way to connect them. So the dataset contains a field called 'Submitter' which contains…
-
Hack for color coding bar chart based on multiple series
Hi there, I have the bar chart attached that I would like to configure such that bars for "Most Recent RP" for subdimensions 'Self-Awareness' and 'Self-Efficacy' are yellow and the bars for "Most Recent RP" for subdimensions "Resilience" and "Stress Management" are green. Is there a hack to do this? I tried setting color…
-
How to build a card which show the latest-date data only?
Hello, I have lots of datasets, which are updated by daily/weekly/bi-weekly. They dont have a specified update date. I'd like to build cards based on them which show the "latest-date" data only, and should be updated automaticly when datasets updated. I notice "date_range" in domo cards build don't have a non-specified…
-
Trouble showing only %_percent_of_category labels on a 100% stacked bar
I am wondering if it is possible to show only my label settings even when hovering and hovering on the legend in a 100% Stacked Bar. The card is currently set up to show labels of %_Percent_of_category so in the default it only shows % labels (see second attached screenshot). I also have my hover settings adjusted to show…
-
KPI Dashboard Creation
Good morning to you all, Looking at creating a KPI Dashboard. Just wanted some initial advice to a possible strategy. Very new to Domo so still learning. Background: There are 4 different areas of the plant. Each area has the same KPIs. These KPIs are broken down by 5 project stages (each project stage has different KPIs).…
-
Page Filtering not Retained when Viewing Storyboard Page as a Slideshow
I have a storyboard set up to work with page filtering. When I set my filter and then chose to display the storyboard as a slideshow the filter I just set is ignored. What am I doing wrong?
-
Drill Down with different datasets
I know there are some threads around this but none of them seem to touch on the issue I'm having. I have the top card built off Dataset A with columns for Regional Manager, District Manager and Locations. Dataset A summarizes different revenue streams for each location. The card is subtotaled by Regional Manager then has…
-
Dashboard vs Story Dashboard
Hi, I am new domo, going the domo university e-learning modules. I am confused with the terminology between Dashboad and Story Dashboard. To my understand Base is a Page -> Collection -> group of Cards We can convert a page to Dashboard using design Dashboard option and revert the dashboard to Normal Page. How I create a…
-
Shrink Columns in Table
Hello, I was wondering if there was a way to shrink the column widths so I can show all the columns in my dashboard. I know you can adjust the ratio based on 100% but I want to be able to take the table on the left and shrink the columns to become the table on the right, getting rid of all the blank space. Thank you
-
Story Dashboard Export to PDF
We have created a story dasbhoard with some filters applied. When we choose to Export to PDF, the filtering criteria is listed at the bottom as well as page numbering information. Is there a way to remove that? It really takes away from the look of the dashboard when that is showing. Here is a screenshot of the bottom of…
-
Beastmode filter computation
I want to know if there is a way to do the following in Beastmode. I have a dataset with sales of asian countries 1). I want to filter and get the sum of only Japan and Taiwan. 2). I want to use the result of 1 in a computation such as SUM(Japan_sales and Taiwan_sales)/SUM(Asian of all countries) I can't use ETL or…
-
Visualize 3 numbers in single card
Hello everyone, I have a situation where I need to show 3 numbers in a card. Need help to chose a better card. Metrics: 1. Metric value for 1-30 days - a 2. Metric value for 31-60 days - b 3. Benchmark for the same metric - Not present in dataset - a static value I want the card to show : 1. Metric value for 1-30 days - a…
-
Color Rules on Symbol Line Chart
I am trying to set up color rules for a symbol line chart I am using. I currently have a scale marker set at 0.40%. I would like to have every point/symbol change colors depending on wether it is above or below this line/value but I cannot seem to find a way. I was able to make this work for a bar chart. I'm thinking that…
-
How to create a date page filter
I have what feels like a very straightforward scenario... but I can't seem to make it work. on a page, I have three table cards. Each of the cards used "Registration_Date" as date in the date drop-down. So in each individual card, you can use the date drop-down to view prior quarter, prior year, etc. I would like to setup…
-
Update Data Error
Good Afternoon Community! I have a DOMO Card that I created that I am having problems updating the data to. The intial data was loaded using the CSV Connector. When I re-run my data set and try the CSV connector I get to the screen that asks if I am sure I want to move 1 card to a new DataSet. I click Switch Data. The next…
-
Two Shape Options?
I think there should either be one Shape or rename them if they are supposed to be different.
-
Is there a way to AutoFit cards within a Dashboard whenever it refreshes?
We are trying to create a daily report that gets sent out internally. Everyday, there would be a different amount of information on each card. Is there the ability to Autofit to the Card without doing anything manual? Thank you in advance!
-
Using Latest Batch ID or Batch date
I have seen complicated ways to just use the latest data within a dataset - and I couldnt understand how to set them up. does anyone have a simple way to just use the last batch data? Currently I am just filtering to BATCH_ID Greater or equal to and entering latest number, obviously when the batches run I then have a few…
-
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?
-
Yes/No dimension across multiple fields
I have a SharePoint list that contains over 50 choice columns, all with their possible response limited to [ 'Yes', 'No', 'N/A' ]. Is there a way to use the [ 'Yes', 'No', 'N/A' ] dimension in a card that shows a bunch of these columns at once without having to reference each separate column's value individually? Hoping…
-
Multi-value: show two data points from different dates
Within one card, is it possible to display the value for the last month and below the change or average for the last 6 months? For example, the last month's emails received was 4.1K and the last 6 month average was 4.2K. The visual would show 4.1K and then below it, an downward arrow showing that this is less (% or value,…
-
Alert when any item is empty compared to previous months
Hi everyone, Is there any way to configure a card alert with comparing a recent value with the previous ones(previous months)? For instance, I need to have alerts triggered when any item compared to previous month is empty in current month. Thanks in advance!
-
New to Domo: Period Comparison Gauge
Hello all, I am relatively new to Domo and still trying to adjust my brain to it's unique ways (coming from a Qlikview/Cognos background). One of the things I am struggling with is feeling like I have to build a lot of things multiple times for different use cases. As an example - let's say I want to use the comparitive…
-
Stack Bar
What shall be my settings to write the hover text in this gragh. I want the o.p to be dispalyed as this, Also when I want the data to be displayed in Months, like weeks 1-5 shall formulate as January.