The best way to display data tables with too many columns

I face a challenge on the best way to help the user to scan data and make a decision about the status of their pipeline, in an instant.

What is the best way to display data for a table that has more columns than would fit on the screen? I am talking about 30 columns.

Hoping everyone can guide me with some advice.

Thanks in advance.

ms office: can I filter several columns at the same time in Excel?

I have not been able to find a good answer on Google, so here it goes:

I have a large set of people data and within this there are two columns that I want to filter: location and rating. I have solved how to do one at a time (just the normal filter function), but I want to filter for both at the same time. So I only have people with X location and Y classification, is this possible?

Thank you!

Eli

sharepoint online – Creating columns of highlighted content

Our SharePoint tenant is host to multiple Customer sites, all of which are structured in much the same way and with access to each Customer site given to ourselves and to the respective customer. Each site also contains a Document Library called Jobs, with a column called & # 39; Job Description & # 39 ;, as well as some others, and every time a Customer has a job, you must create a folder in the library & # 39; Works & # 39 ;, and detail the details in the columns.

As a means to ensure that this is done, I have been looking to use the featured content web part to incorporate all the new jobs that are being created across our tenant; for the most part, this works, and I can see Title, Modified and Modified by details of each item in the list that is being created or edited, although ideally I would like to get the column & # 39; Job Description & # 39; of the folders here too. I know you can create a column in highlighted content through JSON, but I wasn't sure if this would also include the actual text in the column, or if I would have to use CAML or something else to do that. Is this possible, and if so, how?

Any help would be appreciated – Thank you!

mysql – How to verify the existence of a value between two columns of the same table

I have a table accounts having columns id, starting_bl_no, ending_bl_no.

How can I verify that there is already a new invoice number entry in the table?

id    starting_bl_no    ending_bl_no    
 1     100              140  
 2     357              500  
 3     150              190

Note: that is, if the entry is 102 I should go back there. Or if the entrance is 145 must return does not exist

equation resolution: delete one of the columns in the output of the Solve command

I would like to delete a variable in the output of the "Solve" command without changing the rest. For example, in the following code

p = 6;
A = Solve[{p == x + y + z + t && x > 0 && y >= x && z >= y && 
 t > 0}, {x, y, z, t}, Integers]

we have the exit

{x -> 1, y -> 1, z -> 1, t -> 3},{x -> 1, y -> 1, z -> 2, t -> 2},{x -> 1, y -> 1, z -> 3, t -> 1},{x -> 1, y -> 2, z -> 2, t -> 1}

and I need to remove, for example, the last column for "t" and have:

{x -> 1, y -> 1, z -> 1},{x -> 1, y -> 1, z -> 2},{x -> 1, y -> 1, z -> 3},{x -> 1, y -> 2, z -> 2}

Without changing the code in the input, I mean, I just want this change in the output section to keep the original output there.

usability: how to handle filtering in the columns of a table?

I am currently working on a fairly complex (and complicated, I admit) table in terms of filtering. One of the options to filter allows the user to filter on an item that is displayed as a column and I am trying to find the least confusing / jarring way to update the table.

This is difficult to describe with words, I will be honest, so here is a GIF that shows the functionality.

enter the description of the image here

I added blocks to hide some data, so don't pay attention to the floating gray boxes :).

Advance

Currently, only the items selected for that filter are shown in the table and the rest are removed. This has the benefits that the user does not have to see or think of information that he does not care about, but then he has to readjust to what is really a "new" table. The other option is to dim the unselected columns so that the information is still there but out of focus.

What method of the above, or someone else if you have ideas, do you think would confuse the user less?

Website design: users want to create tables with many columns and infinite scrolling rows. How do we handle this?

I have a situation where users are able to create their own searches in large data sets, using a user interface similar to a query. Our users come from a solid Excel background and are used to working with dozens or more columns in them.

Our search system provides a full screen interface with infinite scrolling and fixed headers, since sometimes these searches can return millions of records. We tried to limit the number of columns in a search to 12, but users expressed their desire to have more.

We are asked to add horizontal scrolling, but this works poorly with the existing system of fixed headers and infinite scrolling, in addition to generating a poor user experience.

Because users select the columns themselves and can write custom columns using mathematical functions or aggregates in previous columns, it is difficult to predict the final appearance or content of searches and it is not possible to condense multiple columns into a single cell.

Are there patterns or shortcuts to provide what the client requests without compromising experience or functionality?

Select column A where the values ​​in column A are not present in columns D-G

Having problems with a query.
I want the query to select column A where the values ​​in the column A are not present in a column D-G.

I tried a filter and I did not succeed.

t sql: insert multiple columns in a sql column

Table A

Name (string)

Surname (Sring)

Address (string)

Employee (chain)

Not employed (chain)

Withdrawn (chain)

Table B

Name (string)

Surname (Sring)

Address (string)

Employed State (string)

I want to insert in the table B name, surname, address in their respective columns, but of the 3 columns in Table A for employment, I want to insert in a single column of Employment Status in Table B. What is the best way to do this? ?

regards

postgresql – Error: pq: 1 columns must reference exactly 1 columns in the referenced table (found 2)

I have some tables and I am facing this problem most likely with the "element" table.
When i remove restaurant_id Y category_id, It works well.

CREATE TABLE IF NOT EXISTS restaurant
(
    id              UUID NOT NULL PRIMARY KEY DEFAULT gen_random_uuid(),
    title           VARCHAR(50) NOT NULL UNIQUE,
);

CREATE TABLE IF NOT EXISTS restaurant_gallery
(
    id              SERIAL,
    restaurant_id   UUID NOT NULL REFERENCES restaurant,
    image           VARCHAR NOT NULL,
    PRIMARY KEY (id, restaurant_id)
);

CREATE TABLE IF NOT EXISTS category
(
    id              SERIAL,
    restaurant      UUID NOT NULL,
    name            VARCHAR(25) NOT NULL,
    PRIMARY KEY (id, name)
);

CREATE TABLE IF NOT EXISTS item
(
    id              SERIAL,
    restaurant_id   UUID NOT NULL REFERENCES restaurant, (problem?) 
    category_id     INT NOT NULL REFERENCES category, (problem?) 
    name            VARCHAR(25) NOT NULL,
    PRIMARY KEY (id, restaurant_id)
);

CREATE TABLE IF NOT EXISTS item_gallery
(
    id              SERIAL,
    item_id         INT NOT NULL REFERENCES item,
    image           VARCHAR NOT NULL,
    PRIMARY KEY (id, item_id)
);

Error:

pq: 1 columns must reference exactly 1 columns in referenced table (found 2)
Error: pq: 1 columns must reference exactly 1 columns in referenced table (found 2)
Failed running "sql"

Any help is really appreciated!