-
using IF then WHEN
Hi I want to add another variable to the above equation but can't get it to work. In my Excel days, I would use an IF statement. Here is my equation: when 'primary class' = 'supermarkets and grocery stores' THEN sum(case when `Split answer` = 'Female' then `Value` else 0 end) / sum(`Value`) Thanks Ben
-
Beast Mode calculation when data is in rows and then how to chart
Hi All I have a dataset (a sample is attached) where the 2 series I want to track are in the same column, identified by the Split Answer (i.e. male or female). I want to calculate the % split answer value by dividing the value by the sum of all values where the Split Detail is held constant (i.e. what is the % of female…
-
Organize values on X-Axis
Hi All, I am trying to sort my x-axis values on roles (see screenshot attached) not on the default sort options available in Analyzer. I read a previous note from 2017 that told me to use CASE to sort, so I did: CASE split_detail WHEN 'CEO'THEN 1 WHEN 'Head of Business' THEN 2 WHEN 'key management personnel(KMP)' THEN 3…
-
How to hide Pie Chart total and include % in the data label
Hi - see attached. HOw do I hide the "Total 890" to the right of the pie chart? And, ho do I include the % value in the label? Thanks Ben
-
Charting
I am new to Domo and busy learning Analyzer. I'd like to know how to convert a bar chart (with two variables) into a line chart with percentages, so if you have a column with 75 Male General Managers and 50 Female General Managers, another column with 100 Male Executives and 50 Female Executives, and a final column with 65…
