sum case

Options
Ana
Ana Member
edited July 7 in Calculations & Variables (Beast Mode) 
how categorical variables can have a numerical total of another numerical variable?

for example i need sum THE TOAL OF SALE FROM DIFERENT BRANDS / TOTAL OF SALES. 

the query needs to be smart enough to determinate the different brans


AND IN A GRAPHIC THE BRANDS NEED TO BE IN X AXIS AND % IN Y AXIS


Answers

  • ST_Superman
    ST_Superman Domo Employee
    edited April 2023

    @Ana

    I think that you could do this with a Pareto. Place BrandName in the Pareto Name and Sales in the Pareto Value. The graph will then tell you the % of total sales.

    However, if it needs to be a Bar graph, you can use a formula like this:

    SUM(Sales) / SUM(SUM(Sales)) FIXED (FILTER DENY BrandName)

    Using this formula should let you place the brand name on the x axis and this value in the y axis to create your desired graph.

    If you are running into issues, it would be helpful to see what your dataset looks like and how you expect to visualize your data.

Categories