Best Of
Re: July Community Highlights 🌟
Congratulations @nmizzell! Thanks for your help and participation.
Re: Can my output include projects that don't have a column value for a Split / Group
Hey PJG,
Could you provide an example input and desired output?
Thanks,
nmizzell
Adding checkboxes to a table
I am wanting to add checkboxes to each line in a table so that I can select the check box to signify that line has been completed as I am working through the list, is this possible?
Next part to the question would be is there a way to make sure the boxes that get checked stay checked after I go back to the home dashboard screen without having to go into 'Edit Analyzer' for the card? The table I am working with has about 10 columns and typically around 40ish rows.
Thanks all!
Is there a way to make column headings on the DOMO table cards dynamic?
I have several DOMO [mega] table cards that display data in numerous columns, including a column for last month, this month, next month, and the month after next. Every month I need to go in to the beastmodes and change the title to reflect the change in months. The beastmode formula/data automatically reflects the change in months, but the title of the beastmode does not. I am aware that the data label can be changed in Analyzer, but that too is a manual process and no different than changing the beastmode title. On one card, some of the different column headings are: |July|August|September|October|. Next month, I will need to manually change those four beastmode titles to: |August|September|October|November. Is there a way to make the column headings on a table card dynamic?
charles
Re: Reset password
You can reset a password by going to More » Admin. Then edit the person and click the Change Password button.
Re: SUM(DISTINCT) or other function?
Hey, that's terrific. You could also use a filter on that branch to limit what comes through that path.
Re: SUM(DISTINCT) or other function?
Correct, you see only what is produced by the Group By. But, you can either add fields to the group (if they match that "level"). Or, you can spawn a branch off that backbone, do something on the side branch, and then use a join to join new things back to your backbone.
Edit…I said that slightly wrong. If you add a new field to that formula tile, the new field will also be part of the output.
Re: Filters on Multiple Pie Charts
Just create a beastmode field that references the field you are using to filter. Example below:
Then use this as your filter for the right side. You can also use filter exceptions.
Re: SUM(DISTINCT) or other function?
The first table doesn't require an ETL, a fixed function or a distinct function. This is the exact kind of data Domo tends to works best with.
This BM should work:
case
when sum(PlannedCost)<sum(ForecastCost) then 'Over'
when sum(PlannedCost)>sum(ForecastCost) then 'Under'
END
However, the second table, where you get counts of over/under is harder. I would probably end up doing it with an ETL. I'm not sure it's possible to get counts across rows using just BMs, but would be curious if someone else could do it. One way to get the counts by budget is with a bar graph. Using the same BM above for budget, and COUNT(DISTINCT ProjectName):
The key is using the projectname as the series, to get it aggregate at the right level. With a lot of projects, I would probably not use data labels and color code based on budget to avoid business on the graph.
