Creating a calculated column in beast mode results in data being split up
Hi all - I am new to Domo and experiencing some issues displaying desired results in a bullet chart.
I have a beast mode calculation where it provides a value if one criteria is met, and another when a different criteria is met. In my bullet bar graph, when I select both criterias in the filters, values are now split into two sets where I'm expecting one consolidated total.
I also tried capturing both criterias in the case statement but it still displayed both sets. Am I writing the beast calculation incorrectly or should I be creating this formula in the ETL?
Bullet chart - results
Bullet chart - desired results