Best Of
Re: Count transactions AND sum quantity on specific transactions by type
Are your transactions duplicated?
If not you could do a conditional sum like:
SUM(CASE WHEN `transaction_type` = 'Quantity' THEN `quantity` ELSE 1 END)
Re: Using Sum Distinct in Domobrick query
ArborRose
I ended up just running it through an ETL and aggerating it there. Thank you for the insight!
Re: Disabling email notifications for users in a certain group?
This is about the best you can do right now, Admin > Company Settings > Display Share Email Notifications
Re: Email connector - header row error
@NFerna Can you please share a screenshot of all your settings on the connector?
Re: Can I design the kind of chart with 3 bars stacked and 2 lines
@mcih = @MichelleH - there's some weird bug going on where it isn't letting me edit my previous comment, so wanted to clarify what was meant.
Also, in terms of series, I mistyped and now can't edit my previous column. What I meant to say is it's probably easiest if each of these columns is it's own series. So the 2 lines would be generated via their own beast mode/column, and the 3 bars would be generated via their own beast modes / columns.
You can have them all in a single series, but then you will need to define their sort order to make sure that the values you want on the line vs bar are mapped correctly.
Re: can we design this kind of chart in DOMO?
@Lu_zhang Check out the Grouped Bar with Line chart:
Re: How to remove min/max/avg from Bullet Chart
Thank you!! The older card does have a target value, the new one does not as I have not brought targets into the dataset yet. I tested adding a random field to the target value which successfully removed the min/max/avg lines.
Ant T
Re: Interactive Calendar Filter
@Atieh Yes, support should be able to help you with the bug and implementing the fiscal calendar!
Re: Interactive Calendar Filter
I have done a ton of testing and I am quite sure this is a bug. I would submit a support case to Domo to investigate.