MAX Price

SiGill1979
SiGill1979
in Magic ETL

I have a list of suppliers and their prices. Is there a way in Domo to find the lowest and highest prices and return the supplier who has them.

 

Attached is an example of what I am trying to achieve

Any Help would be appreciated

 

Many Thanks

Simon Gillham

Best Answer

  • Prajju
    Prajju
    Answer ✓

    Hi,

     

    You will need to create a MySQL Transform as follows:

     

    1)Select the input dataset

    2)Apply the following transform:

     

    select supplier, fruit_size, min(price) as 'Cheapest Price'

     from example_data

     group by fruit_size

     

    3) Create an output dataset.

     

    This should work. Let me know if you have any other concerns.

     

Answers

  • Prajju
    Prajju
    Answer ✓

    Hi,

     

    You will need to create a MySQL Transform as follows:

     

    1)Select the input dataset

    2)Apply the following transform:

     

    select supplier, fruit_size, min(price) as 'Cheapest Price'

     from example_data

     group by fruit_size

     

    3) Create an output dataset.

     

    This should work. Let me know if you have any other concerns.

     

  • ST_-Superman-_
    ST_-Superman-_ Coach

    I would recommend a combination of a box and whisker plot and a drill path to provide granularity.  You could also just use the card in the drill path if you want all of the data on the first view, I liked seeing the spread with the box and whisker though.  Box and WhiskerBox and Whisker

     

    Drill PathDrill Path

     

    All Sizes at onceAll Sizes at once

     

     

     

     

     


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman

Categories