Best Of

Re: How to calculate best?

For the final calculation, you could try something like:

(SUM(CASE WHEN `Field` IN ('9','10') THEN 1 ELSE 0 END) -- Sum of 9 and 10
-
SUM(CASE WHEN `Field` IN ('9','10') THEN 0 ELSE 1 END)) -- Sum of all Other Values
/
COUNT(`Field`)

It's hard to be too sure without seeing more of the dataset, Could you post a few lines of the data?

ST_Superman

2

Re: Magic ETL: How to REMOVE Rows Meeting a Two-Column Criteria?

@pstrauss You would just do the opposite of what you're wanting to remove:

column 1 is null and column 2 is not null

RobSomers

4

Re: Suppress Sections/Collections on Dashboards

Agree. I would also be fine if it would be possible that a card disappears if there is no data - we already can give it a custom message, but would be nice if it was completely gone from the page/export.

Ritwik

1

Re: Roll up rows in table chart with similar fields

In Analyzer you can select an aggregation for your Total field and select Sum, this will group all your other columns togethers.

GrantSmith

2

Why is campaigns front end web development instead of PDF export of dashboard?

I'm confused as to why one must have front-end web development experience/knowledge to create a campaign report attachment. This just seems like a lot of extra work for no reason. Can't we just link to an existing dashboard that becomes a PDF based on the distribution filters? That just seems like it'd be a lot easier. Am I missing something? Does that functionality already exist? This tool just seems like a massive afterthought. Or maybe if we could at least drag and drop card/text boxes that'd be a significant upgrade too.