-
AND filters in dashbaords
When we use a filter to select multiple values in a dashboard it uses an OR statement. For example : If I want to see all orders containing SKU A and SKU B, how can I achieve that with a filter on a Domo dashboard? Typically, it only provides orders containing SKU A or SKU B. Hence, I'm curious if there's any method to…
-
Histogram Buckets Beast Mode
I have created 5 buckets and I am not sure why only the last bucket is showing on a bar chart. I can see more buckets in the underlying data. Any insight on this? For reference I am using a case statement to create my buckets. Something like this. CASE WHEN (SUM(min(1)) over (partition by cat1,cat2 order by sum(value)…
-
Histogram Represent Y axis as %
I am using histogram card to show the distribution of users in a percentile. Currently the Y axis is using count of users and the graph is showing user count in a percentile. I would like to change this to a user % and would like to show % of users in a percentile. So for example 2% to 7% should show % of users ( 50 /…
-
SUM(distinct) Fixed By
I have a column that needs to be a constant value based on two more columns. So I am using this formula SUM(DISTINCT Balance) FIXED (BY Client, Item). This is working fine. However, When I am using the same formula in another beast mode I am getting the below error (1-SUM(Lost))/ sum ((SUM(DISTINCT Balance) FIXED (BY…
