Best Of

Re: Locked dashboards and locked cards

@Jones01 yes. Locking the dashboard means that your colleagues can't change the dashboard (i.e. cannot remove, reposition cards within it), but if the cards themselves are unlocked, they can still be edited.

You can lock all cards on a page using the bulk edit features in the admin panel.

mhouston

1

dynamic rank/ordering for Beastmode

Is there a way to create a dynamic column via Beastmode that will rank the rows (1, 2, 3, etc...) based on the filtering and sorting for a table card? So however you filter and sort your table, there will be a rank column that adjusts so you can see the ranked order?

NathanDorsch

1

Change line type to dashed in line graph

Can the line type be changed from a solid line to a dashed / dotted line in a line graph?

There are old posts where it was determined this is not possible but I would hope this has become available now.

user050997

2

Re: pydomo export_dataset - exporting Domo dataset with millions of rows failing

Oh!! this would work, thank you @zcameron !

KristiKovacs

1

Re: Is it possible to recreate the SUMIFS formula in DOMO?

You can use a case statement within your SUM aggregation:

SUM(CASE WHEN [CONDITION HERE] THEN `Quantity` END)

GrantSmith

3

Re: Can someone help me with the syntax?

@MichelleH sum(sum(`loan count`) fixed by (`date`) - as I was writing it out, I think I found the error.. thank you! This one worked

sum(sum(`Loan Count`) fixed (by `Date`))

@DashboardDude I had it in the back of my mind to just go in and create a new ETL but I didn't want to create a new data source for two cards.

damen

2