-
Interactive table function
Is there a function/card that would allow you to add in columns that can contain text and be updated and saved? For example, we have a Sales Funnel and this shows all prospects across the globe, with start dates, values etc (this information is taken from a CRM platform to DOMO), we would like to review these prospects on…
-
Group in Beast Mode
Is there a calculated field in beast mode to group names for a filter? For example, data looks like this on card slicer: Customer A- UK Customer A-USA Customer A- Mexico Customer B- UK Customer B-USA Customer B- Mexico Is there way of grouping Customer As and Customer Bs together to show on the card slicer only the…
-
How to exclude BLANK values in histogram custom bins?
My beast mode calculation is the following: CASE WHEN CEILING(`Flow Velocity (ft/s)`)<= 10 THEN '0-10' WHEN CEILING(`Flow Velocity (ft/s)`)<= 50 THEN '10-50' WHEN CEILING(`Flow Velocity (ft/s)`)<= 100 THEN '50-100' WHEN CEILING(`Flow Velocity (ft/s)`)<= 150 THEN '100-150' ELSE '150+' END I have realised that any BLANK…
-
Rename filter values to "Other"
I am trying to apply a filter at Card Level. For this specific card, I only want to show the filter options as either "Name 1" or "Other". I want the rest of the values to be bundled under "Other", so I only show two options for applying the filter: Name 1 Other Is it possible to do this via beast mode so it only applies…
-
Sorting-Histogram Text
I have created a histogram chart with custom bins. The value is "text" and the sorting is off see below. How can I fix this?
-
Updating individual rows- dataset
Hi, I have used an excel upload for my dataset, and want to know if it is possible to make changes to individual rows within DOMO using Magic ETL or another function? For example, if I need to update a specific field within a row, without having to make the change offline and reuploading the dataset. Thanks
-
Frequency Chart / Histogram
Hello, I have a range of Velocities (ft/s) and I am trying to show how many jobs we have performed within this range of velocities. I need to remove the decimal places and would like to round the numbers up. Is there a function to do that in beast mode or ETL? Then I would like to create a card that shows number of jobs…
-
Values showing as Number with K -how to remove/change?
Hi, I have a list of pressure values in psig and I am trying to show a histogram of the range and number of jobs we have done at these different pressure values. The issue is that the column is a number and when i create the chart, DOMO is picking up with psig value as a number and adding a K to it. How can I change this…
-
Global Map, can you have dynamic filters
Hi, I have a global map card which shows our total number of jobs per country. We have different job types and ideally I would like to show these on the map but in a different colour. Is it possible to have the map coloured in relation to the filter "Job Type"? Thanks,
-
Joining or Appending Data Help
I have a dataset (dataset 1) with individual rows as a specific job (with an identifier key) with details including year and country of operations. I have created cards to show the total number of jobs per year. I have another dataset (dataset 2) which shows historical revenue by Year and Country but it is not specific to…
-
Unique Values Pulling Through twice
I've used an excel upload method and I'm tidying up the dataset using Magic ETL. On one of my columns there is a value labelled "Test". For some reason it is pulling through as two unique values when it should only be one. I have tried to use 'replace text' but whatever I replace it with it pulls through again as two…
