Best Of
Re: Search for keyword (from text input variable) in a phrase
You might try the INSTR() function as an alternative. You could do something like this:
CASE WHEN INSTR(fieldname, variablename) >= 1 THEN 'True' ELSE 'False' END
Re: Connecting Microsoft forms data into domo.
This is definitely possible. Configure your form to send the results to an Excel file that is in OneDrive. Then use the OneDrive for business connector to dynamically pull the data into Domo.
Table, compare several month-over-month
This seems to be similar to the thread located here, but a little more extensive as we're looking to create a table that would compare several months as opposed to just two.
https://dojo.domo.com/t5/Card-Building/hello-how-to-compare-month-to-month-with-secondary-axis-in-card/m-p/38214#M5099. And it looks as if a table is/was being planned but don't see that it's launched at this time (https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Period-over-Period_Charts)
So, wondering if either of the solutions (beast mode or SQL/ETL) in that thread, or something entirely different, can accommodate MORE than 2 dates in a single row of data to compare several months, showing total discrepancies along with the percentage difference from the previous month. The month over month bar chart doesn't seem to be able to visualize what we need, and hoped maybe it can in a table.
EXAMPLE:
We want to show, from left to right, CURRENT MONTH (December) data w/PRIOR MONTH (November) percentage variance, then November compared to October, & October compared to September. The column to the left would be by company/organization along w/current month, # of discrepancies, & the % change over the previous month. Then it would continue, left to right, for the previous 3 months from the current month.
Can this be done?
Re: Remove duplicate unknown comma separated values within a single 'cell'
@Charlie Bantoft It sounds like you want this formula:GROUP_CONCAT(DISTINCT Model SEPARATOR ', ')
Use the "Add Formula" button instead of the "Add Column" button in Group By and use that formula in place of the "Combine strings separated by ," aggregations. Don't forget to replace Model with Colour for the other one.
EDIT: For context, the "Combine strings separated by ," aggregation is identical to the formula (note that it does not include the DISTINCT keyword): GROUP_CONCAT(the_column SEPARATOR ', ')
rco
Re: HTML in Textbox Cards Type isn't Available ?
I am pretty certain that only Table Cards and Summary Numbers are allowed to show html. It is blocked anywhere else and treated like plain text like you see here.
There are advanced methods for creating custom cards that bring power via Design Studio or Dev Studio.
n8isjack
Re: How do you suppress individual line items?
John you are the best! I was missing the knowledge of collapsing the sections. Thanks so much!!!!!
BethW