-
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…