SEARCH

In this article, we will learn How to apply filters in Microsoft Excel. We are using Microsoft Office 365, so we have the latest Excel version, but the concept will work with the older version of Excel. Before start, the following is the demo video that we will cover in this article.

You can read the same article in Hindi here.

As shown in the above video, we have COVID 19 data. We are applying different types of filters with the same sample data. First step, we need to enable data filtering. To enable data filtering follow the steps below.
First, select the data for which we need to enable the data filtering.

Now we can see the drop-down after each column name.
Filter Based on Specific Value
In our Excel, we have data for multiple countries. Let’s assume we are only interested in the “India” data. For this, we need to create a filter for the “Country” column. Select the country’s drop-down, unselect everything, search for “India” and Select the country “India.”

Filter Blank
Let us assume we need to select all the rows with the blank value; we have some blank in the “New_deaths” columns. Let’s try to find out or focus only on the blank rows. Select the drop-down for the “New_deaths” columns, unselect everything and select only blank values.

0

Blog, Cyber Panel

If you need to change the PHP Upload limit for Cyber Panel, follow the steps below.

Let’s first check the easy way to achieve the requirement or change the upload limit.

Step 1: Open the Edit Config page. From the side menu, click on the “PHP” and then “Edit PHP Config” option.

Step 2: Select the PHP version for which you need to change the PHP Version. Based on the selected version, you will be able to check the current configuration values. Edit the required property and Save the Changes. For example, we need to change or increase the value for 7 and 8, as shown in the following image for the current requirement.

Step 3: Restart LSCPD: To restart the LSCPD, we need to use the following command.

systemctl restart lscpd

In case you need to control the other advanced PHP configuration, you need to follow the steps below.
Step 1: Open the Edit Config page. From the side menu, click on the “PHP” and then “Edit PHP Config” option.
Step 2: Click on the Advanced Tab.
Step 3: Select the PHP version for which you need to change the PHP Version. Based on the selected version, you will be able to saw the PHP INI file. Edit the file and Save the Changes. For example, we need to change or increase the value for “post_max_size” and “upload_max_filesize”.

Note: It is a best practice to create a backup while making changes in system files.

Step 4: Restart LSCPD: To restart the LSCPD, we need to use the following command.

systemctl restart lscpd

Finally, you can upload files based on your new configuration values.

0

Introduction

This article helps you understand What is new in IBM Cognos Analytics 11.1.7. It was released in August 2020. It is good to compare it with IBM Cognos Analytics 11.1.6. Cognos Analytics 11.1.6 was the last released by IBM.

We can also provide IBM Cognos Analytics 11.1.7 training for more details, drop us an email at [email protected]

If you think we missed any new feature feel free to share the section we will update the same as soon as possible.

Article Version: 1

Last Updated: 10 Aug 2020

Status: Update is in progress.

What’s New in IBM Cognos Analytics Report Studio

Multiple Measures in Visualization

With IBM Cognos Analytics 11.1.7 version, we are allowed to add multiple measures in the Visualisation. For example, we have the following requirement. We need to create a Line Chart to display COVID-19 information. In it, we need to show Recover, Deaths, and New Cases with Record Dates. Let’s try to achieve the above requirement with IBM Cognos Analytics version 11.1.6.

We already created a new report with a Line Chart with the following columns in it.

X-Axis: Year, MonthName, RecordDate.

Y-AXIS: We need to add the required measure.

Let’s try to add Recover, Deaths, and Confirmed in the Line Chart at Y-Axis.

While we are trying to add more than one measure it is failed with a warning “You can’t insert multiple items inside the selected location.”. 
Let’s try the same with IBM Cognos Analytics version 11.1.7.

We successfully able to add multiple measures, and it is working as expected.
How we supposed to add multiple measures in the older version of IBM Cognos Analytics? For more details, tricks, and the workaround, you can always register for the training session. Contact Us for more information.

2