Create a Graphics bar ,counting diferents models of pc

[llserra]

Hi ,

I would like to create a graphics bar but really i don't know how to do it.

I have a simple sharepoint list with

Name Model_pc

A         model1

B         model2

C         model1

D         model3

E          

F          model2

I would like a graphics  ,with X Counts and Y Models_pc ,with result

model1   2

model2   2

model3   1

Nothing  1

Does anybody knwo how to do it?
Thanks

[v-albai-msft]

Hi @ llserra ,

What is the column type of your Model_pc column? Is it a Text column or a Choice column?

I do a simple test in my side, you can refer to my steps:

1. Create a list called “ExampleList” with a Choice column called “Model_pc2”:

2. Go to your app,  add a button, and set its OnSelect property to below(The formula will cause Delegation issue, so I first save my SPList into a Collection, then use the Collection as data source within my formula):

ClearCollect(test1,ExampleList);

ClearCollect(test111,  Table(

                { Y: "model1", X: CountRows(Filter(test1, "model1" in Model_pc2.Value))},

                { Y: "model2", X: CountRows(Filter(test1,"model2" in Model_pc2.Value))},

                { Y: "model3", X: CountRows(Filter(test1,"model3" in Model_pc2.Value))},

               { Y: "Nothing", X: CountIf(test1, IsBlank(Model_pc2.Value))}))

If your “Model_pc” column is a Text column, try below formula:

ClearCollect(test1,ExampleList); ClearCollect(test111, Table(

                { Y: "model1", X: CountRows(Filter(test1, Model_pc="model1"))},

                { Y: "model2", X: CountRows(Filter(test1,Model_pc="model2"))},

                { Y: "model3", X: CountRows(Filter(test1,Model_pc="model3"))},

               { Y: "Nothing", X: CountIf(test1, IsBlank(Model_pc))}))

3. Click the button to create the collection, then add a column chart(you can add other type of chart as you want). Set the Items property of “ColumnChart” to “test111”:

Best Regards,

Allen

[llserra]

Hi ,

Thanks for your answer, but the problem is with your answer i can only see Model1 ,model2, model3 and nothing... but in my List, i really i don't know how many models are.

I found a midle solution ,but also i have a delegation problem.

First in Onvisible:

ClearCollect(
    lista_modelos_2;
  
    AddColumns(
        Distinct(
            inventario_idom;   // list with users and his pc
            Modelo  // model of pc
        );
        "Contador";  // count of pc for each model
        CountRows(
            Filter(
                inventario_idom;
                sede = "Barcelona";  // only pc's from Barcelona
                Modelo = Result
            )
        )
    )
)

After i have a gallery with items:

Filter(lista_modelos_2;Contador>0)

With this i will see only models that exist with count>0 in barcelona ,if not i see also pc's with cont=0 and there is many models that really i don't want to see.

At last in my Graphics items:  Gallery2.AllItems

So i have this:

But, first ... 

1) I have a delegation problem, in my database Invenatrio ,i have more than 2000 records ,some of Barcelona, Madrid...

2) In this i have count 238 records... i really i have less computers in barcelona... Uff i can not see how it's possible that here i see more computers...

So with your answer it's possible to adapt to more models?

Thanks again for all