Best Of
Bar Diverging Chart Tutorial
Diverging bar charts are a simple standard bar chart that can handle both negative and positive magnitude values.
How to build in Analyzer:
- Select ‘Horizontal Bar’ under ‘Popular Charts’ as the Chart Type
- Drag ‘Profit’ from the Data pane into X-Axis
- Drag 'Product' from the Data pane into Y-Axis
- In Chart Properties, configure the following:
- General -> Sort on Totals: Descending
- Gridlines -> Hide Gridlines checked
- Gridlines -> 'Remove Min/Max/Avg Lines' checked
- Data Label Settings -> Text as '%_VALUE'
- Data Label Settings -> ‘Use Scale Format’ checked
- Data Label Settings -> ‘Use Scale Abbreviation’ checked
- Value Scale (X) -> Show Label as 'Never'
- Hover Text Settings -> Hover Text as '%_CATEGORY_NAME: %_VALUE profit'
- In Color Rules, configure positive values to be equal to or above 1 to be yellow.
Screenshot:
Pris
Re: MySQL Indexing Issues
@trafalger I see. Now I finally understand a use case for using the SQL transform in SQL data flows! Thanks.
Dr_Duru
Re: SQL Flow taking hours to run
Thanks so much for the great advice on solving this issue! I will look into using Magic 2.0.
mroker
Re: Why are my filters not working in Magic ETL?
@damen In your formula, instead of doing COUNT('withdrawn'), do this:
SUM(case when 'fallout_reason' = 'withdrawn' then 1 else 0 end)
As you have it now, the numerator is essentially creating a "column" with the string 'withdrawn' in every row, so the numerator is doing the same thing as your denominator. You need to identify the column your aggregation should be looking at and what the condition is.
Re: Beast Mode Delete Button
Hey, @DawsonKent - I had some communication with Chris Wright about this months ago and I got the impression that they opted for "archive" rather than "delete". @ckwright, any thoughts on this?
