jhl Member

Hi, you can filter a card in the details view but it doesn't sound like this would work for you in this case. Depending on your needs Sumo Cards (similar to a Pivot table) might be what you are looking for. If not, you might want to play around with drill paths. HTH

hm... then I would suggest an SQL Dataflow, putting in something like this pseudocode select UnitNumber, count(UnitNumber) from Dataset group by UnitNumber; or you might want to sum() up another value column (the above is assuming that it is just about the number of appearances in the dataset). If necessary, you can add…

Is there a missing identifying column? I am not sure why you couldn't join first and then sum up.

Hi, this might be late as well ? but there are beast mode tricks that you can use to do this. You add the image into a CASE statement using html and voila. Instructions and examples are here.

If you just need this as a table view, you can just pick unit numbers and hours spent, put both in a table and use SUM in the aggregation field. If you want to brute-force it, this might help: Use Beast Mode to make a as many extra columns as you need, for example Case when `Unit Number`=1 then sum(`Hours`) end HTH

Do you use the report scheduler? If so, I do know, unfortunately. If you use the Domo Powerpoint Plugin, Tables are exported as images, which is also not optimal. The best way of dealing with tables that I have found is to just export the table card as powerpoint using the Domo GUI - this makes them show up as (complete)…

Hi, I do not think you can do that in a Gantt chart. But you should be able to easily beastmode this elsewhere. The calculation could look something like DATE_DIFF(`End Date`, `Start Date`) which would give you the number of days as a positive number. You can use AVG() on it as well and maybe just plot it by location in a…

Hi DK, are the "many, many lines" duplicate values? If so, you might want to try the Remove Duplicates function in ETL. If they are not: which values of the larger dataset do you want to keep? If it is, say, a dataset with a timestamp that gives you values for each company for each day, you can use Rank and Window to, say,…

As stated here there is afaik no way to create or check a rank that is not already in the data by using Beast Mode - MySQL (which Beast Mode is based on) does not have these sort of partition functions, which is one of the most limiting factors. A new stable version should be released soon-ish and then eventually Domo will…

Hi Bheeshma, exporting a card to Excel exports the (modified) data only - your beast mode calculations will have a different name (as from the Domo system) as well. Totals rows in table cards are layout options that do not get exported to excel, the same way that putting labels on a bar chart or changing color rules would…

Hi Alexis, it is possible to use the API to import and export datasets. The documentation is here and specific export instructions are here, share it with a developer, he or she will understand the details. Essentially, you send something like GET…

Hi, we use cohorts for tracking customer retention in a table card that looks pretty much like the first graph here. So what we want to see is - month (start of cohort action, in our case becoming a customer) - number of customers at the beginning - number of customers retained for the next period (column) Example: Cohort…

Hi gwsv-it, I cannot speak for the Domo product development plans, but you can request this feature in the Ideas Exchange in order to allow other users vote on it (I am sure you are not the only one who would like this feature). In the meantime you have several options (afaik, the Domo API does not have this feature): 1)…

Hi, afaik the latest stable version of MySQL (5.7) that Beast Mode uses (I think that's it, right, moderators?) doesn't actually have that function (fingers crossed for version 8.0, which also has window functions, which will be absolutely mindblowing. What you can do however is add a rank into your data (for each column…

I found the release notes for this feature. As far as I understand, it has to be enabled by an admin, then there is a link in the cards and it is a "free 30 day trial" for paying users. Which I do not understand, to be honest (also no info on the pricing). Also no word on the need of SSO (which I would prefer not to…

I myself am anxiously awaiting this feature. If you press the "?" in the bottom left corner, the image below shows up in the "Oct. 12" section. Maybe tomorrow... this would be the killer feature that is going to sell everyone not yet on board on Domo.

There is a knowledge base article on customizing your summary number here. Code example: CONCAT(Sum(CASE when `Status` <> ’New' then 1 END),' Total, ',sum(case when `Date` >= date_sub(curdate(),INTERVAL 1 MONTH) then 1 else 0 end),' In Last 30 Days’)

Assuming that your connector update settings are "Replace" there may be a quick fix. You could set the dataflow to just append rows - then you get a "snapshot" for each time the dataset updates. This will lead to a lot of duplicate data, which you can easily filter out for your analysis by filtering on either _BATCH_ID_…