-
Cloud Amp Output Does not Appear when Changing Dataset within DataSet Views
This is a bit frustrating, has anyone had an issue with trying to sub in a different dataset from a Cloud Amp output (specifically from DataBricks) within a DataSet View? It won't even bring up any of Cloud Amp outputs when I try to search for it under "Type". Would really not want to create an entirely new DataSet View…
-
How to default a Pivot Card to a Collapsed View?
Hi all, I'm wondering if there's a capability to save a Pivot Card defaulted into its COLLAPSED form within a dashboard. The idea is to give the user the flexibility to expand out if need be in order to see the granularity within the data. Is this possible? I know I can collapse the rows but it won't "stay" there if I say…
-
Beast Mode Calculation Timing Out in Card
Have you guys had any problems with a Card Timing out using a Beast Mode calculation. I wonder if my dataset is too large (338M rows). I'm doing a Count Distinct on a CustomerID. The card spins and then generates an error message: An issue has occurred during processing. We are unable to complete the request at this…
-
Using Separate Filters in a Dashboard as an OR type argument
Hi all, I have a situation in which I have a High Roll-up of States grouped together and then a separate State level filter and want them to work together. Example is: Region Filter: -East -West -South -Midwest And then a State Filter of all 50 states. I would like to have the have an option to pull in data that can…
-
Knowledge Paper so bad
Why DOMO training continues to lag far behind vs. Tableau and Alteryx. They can't even get their knowledge papers right....check it if you wish : https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Stacked_Bar_with_Line_Graph
-
MySQL query for YTD Running Total
Hi all, I'm having trouble creating a mySQL query that does a running total by a certain Group By dimensions. Here is a sample structure of the data: datestoreChannelVisitsYTD…
-
Beast Mode not available to add to Summary Number
I have a simple question that is frustrating me. I want to create a Customized Summary Number. So I tried creating a simple beast mode using Concat. It was something real basic such as: CONCAT(`Total_Sales`,' Total Sales and',`Total_ROs`,' Total ROs for all') And this Beast Mode is not available to be selected as a Summary…
-
Partition By Beast Mode as a Filter
I created this Max('Value') that is grouped by a certain NamingKey using the Partition By. I followed the syntax recommended by DOMO in the attached image. I was able to get Max and Min values and use them within a Case statement, but I could not filter from that Case Statement. The Partition By Beast Modes just don't…
-
Card and Beast Mode to Isolate Best Performing Stores
Hi all, I need some ideas and help in trying to isolate best and worst performing stores based on say a monthly or YTD YoY ratio. I don't know yet where to start but I would like to have an option to look at YoY differences for the month or for the year and then develop a ranking type chart of best and worst performing…
-
How to create a Dual Axis on a Horizontal Bar Chart?
Hi all, I'm trying to create a Grouped Horizontal Bar chart, but one metric is in units while the other is a MoM % calculation. So the primary axis is based on a unit scale and the secondary bar chart is too small to see anything because it is on a % scale. So I'm wondering can you create a secondary X axis to display the…
-
Beast Mode Calculation for cutting off the last months
Hi all, I have a question on how to create basically a Beast mode tyle filter that will cut off the last 3 months. my datecolumn is in the MM/DD/YYYY format (4/26/2018). So I would like to take the most recently closed month (end of March) and subtract it by 3 months to only report data up to 12/31/2017. Thanks for your…
-
Calculating Beast Mode YoY and MoM Type Calculation
Hi all, I want to calculate a YoY or MoM calculation for each month in which data is available for such comparisons. I would then like to possibly create a chart showing the trend of my YoY and MoM % changes. The Example data looks like this and I would like to calculate a column of YoY and MoM and trend it:…