Best Of
Re: Count New Ids by time period
Does your data have a date field that indicates when the ID was added?
Re: Is there a way to create a chart that displays the percentage of null values across all datasets?
There isn't a simple way to get the total percentage of null values within your entire data warehouse. You could utilize a scripting language to query a list of your datasets then using each dataset ID you could query each dataset with the query endpoint and have it count the number of values in each. This would take time to query each dataset depending on the size of each dataset and the number of datasets you have.
Re: Totaling Summary Numbers on Domo Page
@Mwatson , you could evolve the card that you created based on Marks input and make it a period over period multi value chart. Shows your progress of reducing errors or the unfortunate case of increasing errors. :/
Re: Totaling Summary Numbers on Domo Page
Yes, you can. It all depends on your datasets.
If those 3 cards are all built on the same dataset and are just looking at different fields, you can create a beast mode that looks at all 3 fields and sums them up.
If those 3 cards are based off of 3 different datasets, you would need to use Magic ETL and append those 3 datasets into a single dataset and then sum up the error column to get your overall total.
Re: What is the best way to present data that has categories and subcategories
I would look into the Trellis Categories property on a bar chart. You can create a look like this with the categories, subcategories and attributes.
Re: Is there a way to control the colors in a Lat/long map for a series of values?
Thanks @DavidChurchman that definitely works (noting that you need to set the Symbols > Symbol Color to Default). Much appreciated.
Re: Is there a way to control the colors in a Lat/long map for a series of values?
You can use "color rules" in a lat/long map. It doesn't appear in the "chart properties" panel they way it usually does, but you can open them using the button on top, then apply rules to the variable you chose for your "series for color".









