Import data to read quantities per dimension instead of actual data

Options
davargas
davargas Member, ALL USERS Posts: 5 New Contributor
in Extensibility

Hello, I am trying to create an inventory model for a bunch of server farms. i have one csv file with over 15000 machines. For each machine, it shows its location, its manufacturer, the model, how many cpu cores, and a cpu factor. I want to create a module that shows me the average of cpu cores x cpu factor per location. Because the csv file has over 15000 rows, I am not quite sure how I should import the file to obtain my target module. To start off, I want to have a module that just shows how many machines there are per location. So it would just be how many rows read back each location. Really stuck and now sure how to start. Thank you. 

Tagged:

Comments

  • davargas
    davargas Member, ALL USERS Posts: 5 New Contributor

    @Misbah thank you for the response. Could you elaborate on 2a? 

  • davargas
    davargas Member, ALL USERS Posts: 5 New Contributor

    @JaredDolich @Misbah Thank you for the replies. I now have this module setup. On rows, I have a list with about 15000+ members. 

    davargas_0-1660250183162.png

    Factor (Adjusted), Weighted Factor, Memory/Core, and Core/Node are line item calculations. Site and SuperPool Are list formatted line items. I want to create another module with site and superpool as pages and then display the averages of weighted factor, memory/core, and core/node for whatever is selected. Site and superpool both only have about 10 list memebers. Any idea how I can accomplish this? 

Categories