Best Of
Re: Charts/Graph by
You should put your date column in the x axis then use the “trellis/tiered dates” chart property to include a trellis category. Then drag location over to the “category 2” field. I would recommend making location also be the series when you do this as well.
Re: card design troubleshoot
@Jbrorby You can achieve this using a Stacked Bar + Line chart without the Trellis Settings. In order to stack the bars, you will need to create two separate beast modes for True and False values:
For true:
sum(case when test = 'True' then lte_ibd_transaction.net_shipment_count else 0 end)
For false:
sum(case when test = 'False' then lte_ibd_transaction.net_shipment_count else 0 end)
Then you can place both of these fields in the "Series" spot in Analyzer. In order to show the table below the graph like in your Excel version, check the box under Chart Properties > Data Table > Show Data Table
Re: ZIP code leading zeros being removed
If you can, import the data as a string instead of an integer.
Re: Scatter Chart
Hi @Raymond -
Welcome to the forum. I'll try to guide you through the basics, not knowing the structure of your dataset is or where you are getting stuck. Feel free to follow up with more questions if needed.
The scatter plot chart type is found in the "Data Science" collection:
Once selected, the fields at the top of the screen will allow you to build your chart. For Scatter charts, you are allowed to add "X AXIS", "Y AXIS", "SERIES", "BUBBLE SIZE".
You will likely need to create a calculated field to allow Domo to generate the profitability, unless that is already part of your data. If you need help with that, please share some more about your dataset. In particular what fields would be needed and how you calculate profitability.


