-
Colour change depending if beating last years amounts
I have a bar graph with a comparison line showing the previous year. I want the bar to show a different colour depending on if were beating the previous year or not. e.g. red if under and green if over.
-
Save / Export dataset containing the projections in Domo Analyzer Cards
Let's say we create a Domo Analyzer Card using "Multi-Period Projection" from the chart properties. It uses Linear Regression Recent Weighted and shows the projection in the UI. We need a dataset where all these projected datapoints will be saved.
-
How to select which Metric should go on Line in a Line + Bar Graph?
I have a chart where one Metric is $ and rest all is Numbers. How do I graph it in a way where the $ shows as Line and other show on Bar graph. (Like how in Excel we do a secondary axis) In the picture below, its taking the 1st one(USB requests) as Line while I want to show the Red Bar as Line with $
-
Unable to Display Stacked Bar Due to Partition Beast Mode
At the base, my dataset is broken up by employeeID, months, and planID. For each of the employees, month and plan; the employee receives a $ value based on performance, called "Earned" and they also have a column "Funded" that indicates what they were funded for the plan and month. I am trying to create a card that…
-
Showing some values based on SUM, other values based on the most recent date available for the week?
I am working with a dataset that pulls in sales and inventory data for items on a daily basis. In data analyzer, I created a table with the data grouped by week. After grouping by week, most of the fields in my card (i.e. Revenue, Units Sold, etc.) are aggregated by SUM because I would like to know the sum of all of the…
-
Pivot table field total and sub total options
I created a pivot table and I noticed that the fileds now have options to hide totals and sub totals. But when I check the options, it doesn't seem to do anything. I have columns "division", "category", and "subcategory". I have sub totals enabled and I want to add the item number and the item description. However, now I…
-
Best Way to compare Events
Hello! im trying to make a flexible card that is able to compare two points of time based of events that might have happend. For example this current period vs the school holidays fortnight. Or Event A vs Event B where the events are easily changed to different periods
-
Ability to get to card view from analyzer
As a power user of Domo who creates many cards I can have a quick way to get to the normal card view after creating a new card So I can lock the card, share, export, etc. without having to search for the card I just created Here is a common scenario for me today: I create a new card using the “+” ⇒ Card button After…
-
Allow Inverse Scale Marker Ranges in Line Charts
Currently the “Range” scale markers available in line chart types allow users to choose a fill color for Y-axis values within a selected range. It would be helpful to choose upper and lower range colors as well. For example if a metric has an acceptible value range, I'd like to shade anything above the upper limit as red…
-
Can we save / export the projection data as a dataset in Domo Analyzer Cards?
We have created a Domo Analyzer Card using "Multi-Period Projection" from the chart properties. It uses Linear Regression Recent Weighted and shows the projection in the UI. We need a dataset where all these projected datapoints will be saved. Any idea how to create this dataset or export it from the card?
-
Analyzer: Don't Automatically Choose Chart Type and Columns
When opening a dataset in the Analyzer, often the Chart Type and Columns that are selected are not the ones that we want to use. It would be nice if it didn't automatically select these and did not turn on auto-preview until we have selected these options ourselves and are ready to run the first preview.
-
Calculations using analyser or beast mode
Hi, I have figures from a dataset that I need to carry out calculations on (addition, subtract etc). In the attached, columns 'CAP' and 'ITB Not Built' use different filters to get the final number. All I need to do is add CAP and ITB Not Built together for each client. Pipeline is just these two figures put together.…
-
Can you paint with all the colors of the web?
At the CST time of this posting, I had a far out idea – what if colors were a little more flexible in a couple of ways. Here’s a few ideas. Today when changing colors on a visual, this fun experience occurs: The change all button doesn't even have a warning before it causes the mass extinction of the other carefully…
-
Month over Month % Change Formula
Hello, I'm collecting data from Google Analytics for my company's website. I'm graphing Date to Avg. Session Duration. I need to add a calculated field for Month over month % change. How do I extract months from 'Date' column here. Below is how I calculated Avg. Session Duration & have graphed it. I want to use the MoM% in…
-
Can't Graph by Month
I've merged two tables and used the following formula to make sure the date doesn't get converted to String The two tables joined successfully. But My chart doesn't let me Graph By - Month The Table format still shows as 'String' under the Date columns. What can I do maintain the dates as 'Date' format so that I can Group…
-
Problems launching analyser
Hi, I've noticed a new version has been pushed to our instance as the share on dataset checkbox on the beast mode dialog box has moved up towards the save button. Anyway we are having problems launching the analyser for lots of cards now. You just get infinite loading and have to close and retry to get it to show up.…
-
Create beast mode dates
Hi everyone, help needed! Here is how my table looks below. What I want to show in Analyzer is the count of accounts of these services over time. My problem is how the dates are shown here. Any advice on what I can do? I thought about creating a calculated field to index dates but not sure how to do it. Any help is…
-
How to Remove Duplicate rows in analyzer?
I have used the LinkedIn connector to export the stats. I see duplicated rows. How do I avoid them?
-
What is the best way to calculate?
So I'm using a grouped bar graph and am looking to try and calculate the difference between two of my columns that were created. My company calculates the average spread on loans broken down by lenders we use. I was able to separate those average spreads by product by adding the products to the 'series' drop-in at the top.…