Best Of
Re: Beast Mode
You need a few helper columns to acheive this. The first is the ID, the second is the revision number. assuming the revision number is in chronological order (highest number being the one you want to count) then you can add another column that finds the maximum revision number by ID. Lastly, create a function that reads the maximum revision number and the actual revision number, and produces a 0 if it is not the maximum, and a 1 if it is the maximum. Filter off anything that is not equal to the maximum id revision, then count distinct ID values.
This can be done in magic ETL and in Beastmode.
beast mode for finding the maximum revision number by id: max(`revision_number`) over(`id`)
beast mode for determining if the current revision number is equal to the max: case when `revision_number` = max(`revision_number`) over(`id`) then 1 else 0
filter off anything that is a 0 in your card
beastmode to count distinct IDs: count(distinct `id`)
This is just one of many ways to solve the problem.
nmizzell
Shopify Sessions or Visitors
I'm trying to connect to Shopify Visitors or Sessions data. Has anyone tapped into this part of Shopify?
Re: How to add an empty row in my table?
@learningdomo The only way to truly add rows to a table is to add rows to your dataset. If you are just trying to make the table easier to read, I'd recommend adding a beast mode to categorize which rows you want grouped together and use that as a subtotal field.
Re: Radio button Filter
@ColinHaze I'd suggest using the Global Date filter at the top right of your dashboard since it allows you to filter all cards by a relative date (e.g. "Today" or "Yesterday")
Re: is there a way to create a bar inside bar chart (similar to nested bar chart)?
@VicenteS I suggest checking out the Bullet Chart type:
Re: Case when for 0-30, 31-60 aging buckets
@KristiKovacs try removing 'day' from your DATEDIFF's. In Domo, DATEDIFF just does days by default. I tested it out using DATEDIFF with day and nothing popped up and then removed it and the number of days populated correctly.
Re: Data label %'s and quick filters
This seems like a use case for fixed functions. I would look through the examples in this KB article and see if one of them matches your use case.
https://domo-support.domo.com/s/article/4408174643607?language=en_US
Re: Stacked Grouped bar chart
Agree with @MichelleH that this sounds pretty busy. You might look into using the Trellis Categories on a bar chart to help break it up.
Re: Make the Flex Table the GOAT Chart it can be
Love these ideas @DavidChurchman . I think you should repost this in the Ideas Exchange so that it can be voted up.
Make the Flex Table the GOAT Chart it can be
Update: I meant to post this in the ideas exchange. It's there now, so please upvote it if you agree 😀
I feel like the Flex Table has the potential to be the Domo GOAT chart, but it's so locked down, I end up never being able to use it. Here are my suggestions to unlock its potential:
- Allow for multiple series, so you can group at more than one level. i.e.: first two columns are Region, State
- Allow to set a manual vertical scale for the charts and/or give the option to sync the scales across the charts
- Build in the ability to Trellis/Pivot. i.e. the rows could be states, and you could see the percent change across multiple product categories
- Create a 'no change' symbol, or an option to have no symbol with no change
- Allow the change color to propagate to the graph
- Add chart types:
- horizontal box plot
- Waterfall
- Outlier/SPC
- Bullet
