Skip to content

    • Charting

    Charting

    Beastmode filter computation

    Member
    in Charting

    I want to know if there is a way to do the following in Beastmode.

     

    I have a dataset with sales of asian countries

    1). I want to filter and get the sum of only Japan and Taiwan.
    2). I want to use the result of 1 in a computation such as SUM(Japan_sales and Taiwan_sales)/SUM(Asian of all countries)

     

    I can't use ETL or dataflow for some reason.

    Best Answer

    • Domo Employee
      Answer ✓

      You might be able to do something like this:

       

      1. SUM( CASE WHEN `countrycolumn` IN ('Japan','Taiwan') THEN `Sales Amount`
        END)
        /
        SUM( `Sales Amount`)

      You should be able to limit the the sales of only Japan and Taiwan in the numerator and then sum everything (since your dataset is 'Asian countries') in the denominator. 

       

      Let me know if you have any questions,

      Valiant

    Answers

    • Domo Employee
      Answer ✓

      You might be able to do something like this:

       

      1. SUM( CASE WHEN `countrycolumn` IN ('Japan','Taiwan') THEN `Sales Amount`
        END)
        /
        SUM( `Sales Amount`)

      You should be able to limit the the sales of only Japan and Taiwan in the numerator and then sum everything (since your dataset is 'Asian countries') in the denominator. 

       

      Let me know if you have any questions,

      Valiant

    • Member

      @Valiant  Thanks a lot! this might do the magic ?

    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories