-
How to add date to the scale marker to indicate current date
I Have a scatter chart holding the Month in X scale and amount in Y scale.i want to add a scale marker which indicates the Current date . The option i have is to select "Line" , "Manual" and Value, I am not seeing the scale marker moving to the current date .can you please guide what is the format i have to enter to set…
-
Show labels on pie chart even if it's too small
I am using a pie chart. I have 2 slices. One is 90% and the other one 10%. But the 10% one is too small to show the label. Is there a way to force this? As I don't mind it overlapping the 90% chart as there is enough room to show the label there.
-
Dynamic date in dashboard textbox
Hi, I need some help in creating a dynamic date in a dashboard text box. i'm looking for the date to display yesterdays date. Also can this dynamic date be used for a summary number in a text box? Any guidance would be greatly appreciated.
-
Beast Mode - forEach
Hello. So I have this dataset where I get item, work order and the quantities both planned and actual. This is to calculate manufacturing absorption %. Is it possible, via beast mode, to tell the function that for each distinct work order, it sums its quantity and displays it as the total of Actual production? If I do an…
-
How do I create this simple pivot table?
Looks very basic, how do I do this in Domo, TY.
-
Use Gauge : Target + comparison
Hi all, I am using the Gauge to show my sales results. But I want to show both a target point and compare it to last month. Normally the line from previous month is the targetpoint but I want to adjust this. Is this in any way possible? I also looked at the Comparative Fill Gauge but doesn't seem like the way to go. Thanks…
-
How to use Line + Stacked Bar Chart
Hi Dojos, Looking for some advice on how to use a Line + Stacked Bar Chart in a specific way. Currently my chart looks like this: I want to add a line which indicates the number of clients by region. My dataset is structured as follows (only relevant columns shown): "Operational Places" is grouped by "ACPR Name" and…
-
Add date filter 'with presets' to page
I want to add/show the date filter with presets (as is available on card builders) on the page level - on the filter section. I know that custom filters can be added selecting the date field dimension and then filtering out the required dates and other option is to build a date filter card and add it to the page. But what…
-
Need to add a date axis to a flex table
How can I visually add the dates to the X axis on this flex table?
-
Display Photo based on the selection of a name in Filter
Hello All, I am building a POC for a healthcare case management and I want to know how to display a Patient Photo based on the selection of a Patient Name from the fitler. In Tableau or Qlik, I used to load a file with the Name and Location (Path to the photos) and I can use some OOTB function that will display the picture…
-
Funnel Chart Summary total to top of chart?
Hey team, i'm hoping someone can help me here; i created a Parameter allow me to create a lead source funnel based on a filtered report. The filtered report gives me a total number of 861 leads (represented by the top left summary number). The parameter created basically states "IF this THEN category"; which gives me 3…
-
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…
-
Drilldown filters on different chart types
I am adding drilldowns to a dozen or so cards on a page, all built from the same dataset. Most have filtered as expected -- if I click on a category it drills down with that category set as a filter. But one will not -- If I click on a category, it goes to the drilldown view, but does not filter. If I click on a datapoint,…
-
Move page to a sub-page
I am unable to move a page to a sub-page of another dashboard. This knowledge article may be out of date because I have a different experience on the admin>pages section. There is no checkbox by the page and no "move page" options I can find. There is a side pane with the list of pages and then a window with users and…
-
How to adjust size of the value in the single value card?
Hi, I am using single value cards and would like to adjust the size of the value (font size) inside the card (not of the card) but I'm struggling with that. I know for other cards you can adjust that under General, but there is no option for that in a single value card.
-
Beast mode - Age buckets / grouping
Hello everyone, I am having trouble with a beast mode grouping outstanding records by age bucket. I am looking to calculate the number of days a record has open and then place the record within a range. Below you will find my existing beast mode which is an "Invalid formula". If someone could assist with the formula…
-
Conditional Formatting Workaround in Pivot Table
Hello, Context: In my organization, my role is cardbuilder. I have built a pivot table and ran into some issues with conditional formatting. In my table, I have Daily Budget and Net Cost as two columns broken out by day. Ideally, I wanted the Net Cost column to turn RED (could be font or background - just something to flag…
-
All Year text in Textbox
Hello Everyone, Anyone can help me regarding the below requirement:There is requirement* When I have not selected any slicer value then in the Text box Number that is "All Year". * When I have selected any slicer value then in Text box display '2019'(Year Number) Thanks
-
Warning sign in Multi row card
Hello Everyone, I have created a multirow card which is grouped by "YEAR".When I am selecting a single "Year" from the filter it is giving me a warning message. Can you please help me hide the Warning message icon?
-
Dashboard Interaction with Drill Down
Is is possible to have a drill down interaction on a card which at the last level interacts with other cards? To give more detail we have an alert table on a dashboard that drills down from property level to the device level, showing problematic devices. Ideally, after drilling down from property level, one would select a…
-
Pivot Table card order
Is it possible to have the total column at the beginning of the table? In the example below, it would be the yellow part of the table... I didn't find any related property...
-
Show all items in a list after applying Page Level filter
Hello Everyone, Thanks in Advance. Is there anyway to show all the item in a list. After applying Page level filter and saved.
-
Keep Line+Bar format even when Null or Zero
I have a line+Bar chart, line is a target and the bars are each department (3 segments in each bar). problem occurs when I filter for any specific department, the bars collapse because there's no data for that specific department within that month. How do I keep the integrity of 6 segment and 2 bars even when there's no…
-
Pareto 80-20
As we know, a Pareto is used to display top offenders based on their impact in the analyzed data. How can I limit a Pareto chart to only display items that are below or equal to 80% of the total? There's no chart option for it, so I assume it's gonna take ETL or SQL to solve this, any ideas or guidance please? Also, this…
-
Shape Gauge
I have a data set that lists the NPS rating a customer inputs on all our interactions. The customer has the choice between 0 - 9 to input a score. The data is in an excel file, I have uploaded this in the workbench. I am trying to create a shape gauge card that will display the count of each choice. I am inputting my…
-
Top 10 with WOW(Week over Week) comparision
Hi, I have a card where I show previous week data by top 10 review projects by timekeeper. Now, want the format to be the same, but want current week bar next to previous week. I am aware that with period over period we need to change the chart type, and have the date on the x axis at least, but then we are not able to…
-
Is there any way to show the card description on the card when on a dashboard?
I can't find it. I made a useful description. I want to show it on the card. TY
-
Hover over hyperlink
Hello, Is there any way to create a text while hovering over the hyperlink text (hyperlink display as)? Thanks, HF
-
Capture Card Summary data on a schedule
Hello. I have a card that is continually counting how many "wigets" meet a certain criteria. The number changes hourly. I'd like to capture that card's Summary number at various intervals (maybe hourly) during the day so I can report on trends. Any easy way to do this? Unfortunately the source data changes when it updates…
-
Adding "Last Updated" Label to Card
Is there a way to add a "Last Updated On....." label to a card? Our data updates roughly every 2-3 hours and we would like the users to see on the card when the data was last updated. Example: Last Updated: 2/14/2020 10:21AM MST Thanks, Ryan