-
forcing x-axis in bar chart to ignore filters
Hi all I have 30-40,000 rows of data presented to a bar chart with 5 dashboard filters operating across the data. There are 15 different categories presented as the x-axis. Occassionaly filtering removes one of these categories. I'm trying to find a way to leave the category on the x-axis despite the fact that it is no…
-
SUM('Revenue') BUT IGNORE ALL FILTERS PLEASE!!!
Hi all About to through my Mac through the window if I can't sort this. How do I write a Beast Mode that sums data whilst ignoring ALL filters? Many thanks
-
Heat map totals to use AVERAGE instead of SUM
Hi folks. I have a heatmap with the values as averages of values within the data. I've asked domo to add a 'Total Row' and a 'Total Column' (red outline below) but rather than these also being averages - domo is totalling the rows/columns. I need them as averages. Any ideas? Thanks
-
Sum x for each unique y
Hi all I'm hoping you lovely people can help me sort the following out, please I have tens of thousands of rows of data which all repeat themselves (for boring reasons). There are 20+ columns but two are always a pair. I've used 'country' and 'value' here to demonstrate (see table below). All I would like to do is add up…
-
Remove duplicate unknown comma separated values within a single 'cell'
Hello good people of Domo Very frustrated trying to remove duplicates WITHIN a comma seperated list. I have the following webform: If I 'Group By' (Magic ETL) by 'Who' & 'Manufacturer' (combining 'Model' & 'Colour' with commas) I get the below. This has repeats in R5:C3 (2x 'TT'), R6:C3 (2x V70) and 'Black' is repeated in…
-
Run DataFlow break/throttle
A tile within Magic ETL that you can insert inside a DataFlow that allows you to throttle the number of rows/calculations that continue past that point - including a full stop (0%. Use Case: I would use this whilst building out complex workflows so that I can test the parts of the workflow I want to test without using up…
-
Combine [unique] strings separated by comma
Hi all Anyone know if this is on the horizon? Combining unique values in a comma separated string. Anyone know? The issue is mapped out in the 4 year old post I've linked to below. Thanks
-
Rolling Averages
Hi all. There's something so simple in Google Sheets / Excel that I cannot believe the might of Domo can't do it but a) I cannot work it out and b) it seems from going through the forums, it cannot be done easily. There hasn't been a post on it for 6 months so I'm hoping there may have been some developments. I won't to…
-
Single item Filter with CONTAINS functionality
Hi all I have a table of 1,000+ people. Each person = one row. One of the columns shows the companies they have worked for in the past (e.g. 'BT, Shell, Facebook'.) You know what's coming…. I would like to be able to give my dashboard a filter that shows each company once and brings back any person/row that CONTAINS that…