-
How to Sort by ASCII (caps first)
I have a user complaining that their pivot table column sort changed recently. It used to sort capital letters first. For example, it used to sort DOMO before David, but now it sorts David before DOMO. Now it ignores upper/lower case when sorting. I prefer ignoring case when sorting, in general, but is there a way to sort…
-
Heatmap - Configuring Display
Two questions… is it possible to have the X-Axis labels at the top, rather than the bottom? Is it possible to set a fixed width to the columns as is doable in a standard table? Have been searching, and evaluating Properties, and have not found solution to either of these two.
-
Defining Custom Color Palettes
It would be nice to be able to define custom color palettes to choose from. I don't mean the ability to set color rules on datasets or cards, or the white label features in embedded analytics. I mean adding your own palettes to the color picker for internal dashboards. Right now, having to use hex codes for everything is a…
-
How do I get future data being populated to current year?
I have a requirement to show Next fiscal Year data into Current chosen fiscal year. So if user choses , FY 23, it should show data for Fy24 in 1 column. Please see below: If FY is selected, then monthly data is shown for current fiscal year. and similarly NextFy data (Fy+1) is also displayed like below. Please suggest.…
-
Spreading out labels so it's easier to read
Hello, I am trying to spread out more the following labels that come from a Lollipop chart so it's easier to read, but am having trouble finding the setting in analyzer. Thanks for the help!
-
How to change color of bar charts (top 5)
Hello. Can someone help me if there's a way to use a different color to indicate the top 5 items in the bar chart dynamically?
-
% of Total Using Distinct Count
I need to show a % Total of Accounts in the below card. I used the following to get the below % of Total accounts. However, there are multiple rows per account name. The # of Accounts column is calculating a Distinct Count, but the % of Total appears to be calculating of the # of rows, not a distinct count of the Account…
-
Page Filters - Use a text value in "Contains" on filter and save as filter
Hi there, I think this is a feature request.. but just asking a question in case I missed it.. When using a filter on card on a text field, you can use a contains "blah" as a condition. Great.. But then when you go to a Page filter, you can only select literal values (I know you can search and click "all" to get a similar…
-
Hamburger button on top left not working in edge.
When I move my mouse in EDGE to the button nothing happens. No fly out window… sometimes it blinks like it tried to work but never does. It works perfectly in CHROME. Any ideas how to fix?
-
Dynamic Columns Line Chart?
Hey everyone, does anybody know if there is a way to either convert this to a line chart using the code in this brick or if there is a seperate brick?
-
Calculated line on Bar Chart not the same as Summary Average
I am trying to figure out why the calculated line for a bar chart I am creating is different the the Summary Average of the same metric. Is this a rounding issue or something else? Thanks in advance.
-
Can I show 2 values as a stacked bar and other values as single bars?
I've been asked to create a bar chart that shows 4 values: Prior Year, Actual, Forecasted, and Goal. The request is that the Actual and Forecasted amounts would stack on top of each other for easier comparison but I'm struggling to find a chart type that will support this. I looked into the Grouped & Stacked bar chart…
-
Case Statement Help
I'm trying to write a simple case statement, but it isn't working as intended. My data set has an attribute for Customer ID. When populated, this indicates that a customer was attached to a sale transaction. It populates with zero if no customer was attached. I want to count the unique customers that were attached, and…
-
Getting x axis sorted correctly
Hi, Any idea on how to fix this so that its in the correct order? The last two columns just need to switch. Its sorted by year and week right now.
-
Display a zero value
How do I display a zero value for a location which has no data. I have 7 locations with only 6 displaying because the 7th location has no data. How do I get the location to display in the table an show a 0% value?
-
Updating Color Rules on Symbol Line Chart
Hello, I am trying to do exactly as was asked in this forum question below. The only difference is that I have multiple lines and many timestamps on the x-axis. Given that this question was asked a bit more than 3 years ago, is there a better way of doing this?
-
Displaying up and down periods over time in a chart
We are tracking internet down time at our stores. Basically every 15 minutes we receive a list of all stores that are currently up. I then process that and for every store that was missing in the list I store a record in a dataset with the store and a timestamp. We need to show over a 24 hour time period what stores were…
-
Cumulative Sales between December and January not calculating correctly.
Hello, I'm trying to create a table with daily net sales by date and also cumulative sales up to the current date (1/3 ATM) between two years: For the "Date" column, I used a beast mode to create date index formatted as %m/%d value: CASE WHEN YEAR(`created_at`) = '2024' AND DAYOFYEAR(`created_at`) <= DAYOFYEAR(CURDATE())…
-
MoM Variance in Pivot
Hi All is there a way to display the MoM Variance values in a pivot? for context i have data per day for Company, Division, Subdivision hierarchy, i can easily display the values at the end of the month in the hierarchy state but what i would like to do is calculate/display the monthly movement with the ability to drill…
-
Company Overview Chart Color Picker
Hey all Just found this in company settings and didn't have it enabled. I was looking at cards and colors and I see no difference. Anyone know what this does?
-
Supress Zero Value rows in Pivot table
Hi, Do we have an option to suppress complete zero value rows from pivot table. Thanks
-
4 Columns of data - but they don't all line up
Hi! We have 4 columns of data, but they don't all line up when in drill down mode; good news is that they do at a high level. What are the steps needed to have these columns below all line up? Thank you!
-
Can I swap the two axes?
How can I swap the two axes, I want the percent on the right and the count on the left.
-
Is a grouped bar with line chart possible in Domo?
Is a grouped bar with line chart possible in Domo,see attached what I am trying to do
-
Conditionally formatting colors of horizontal bar chart for over/under budget
I am trying to figure out how to conditionally format my "Actual" sales either green/red for over/under "Budget" by location. Is this possible? I know this may have to be done with a beast mode (unsuccessful so far) as it cannot be done in chart properties.
-
Trouble with uploading KML file into a Custom Chart
I'm having trouble uploading a KML file into a custom chart. The file is a US Census Tract map and I downloaded it as a KML file from the US Census so it's reliable - I also uploaded it into Google Earth to make sure it was correct. However, when I go to upload the file into a Custom Shape, some of the objects are rendered…
-
Table Total Row and Beast mode Aggregation
Hi experts, I'm tying to build a table of consumption by subtracting a total on different days. I'm using the lead to get the next value and subtracting the current one: When I able the total row option an error occurs: My first question is why is it happening? My second question is why doesn't the bar chart aggregate the…
-
Built in data table functionality & arrows
Hey guys. Weird ask here. Boss is wondering if I can make a visual that gets rid of the light blue bar (Revenue) but keep it in the data table below. Reason being is so I can have two scales for the values instead of the three, which is why the scale for the light grey bar is messed up. She is also asking for up and down…
-
How do I add different y axis labels for the same chart with variable control?
Hello! I built a bar chart graph with variable control, so users can pick one of the few provided variable values and see the respective values on y axis. These values can be in the format of percentage, dollars, and days. I wasn't able to find a way to customize the y axis label shown based on what user selects to see. Is…
-
How can I display amounts for different months in a table in Domo?
I want each row to contain the amount for the previous month as well as the amount for each of the 5 months prior to that. What is the best way to do this in Domo with a Table chart type?