DATEDIFF('day', [Order Date], [Ship Date])

from akhilraparthi1996 to All Participants:

Now its audible

from Pradeep Singh to All Participants:

yes

from Abhishek kumar to All Participants:

from Ashish Kumar Mandal to All Participants:

yup

from V.V.S. PADMAPRIYA to All Participants:

yes

from Anand C P to All Participants:

yes

from chandansingh6025 to All Participants:

yes

from Ruta Narkhede to All Participants:

yes

from Rishabh . to All Participants:

yes

from Mahaveer Singh to All Participants:

yes

from Radhika Kamat to All Participants:

Yes, we can hear you

from Diwakar Singh to All Participants:

yes

from Quynh Nhu Trinh to All Participants:

Yes

from Shwetha R to All Participants:

ys

from Naveen Gambhir to All Participants:

yes clear
from Rishabh . to All Participants:

yes

from Renu Pathak to All Participants:

yes

from V.V.S. PADMAPRIYA to All Participants:

yes

from Diwakar Singh to All Participants:

yes

from Anand C P to All Participants:

yes

from akhilraparthi1996 to All Participants:

yes

from Radhika Kamat to All Participants:

Yes

from Ashish Kumar Mandal to All Participants:

ys

from Abhishek kumar to All Participants:

yes

from Ruta Narkhede to All Participants:

yes

from gurralarajesh to All Participants:

yea

from chandansingh6025 to All Participants:

yes

from KHUSHBOO NAG to All Participants:

Yes

from Bander Mansor AlQahtani to All Participants:

yes

from ajayapradhan9777@gmail.com to All Attendees:

no sir

from Pradeep Singh to All Participants:

good evening sir

from Anamika John to All Participants:

yes

from Abhishek kumar to All Participants:

from Ashish Kumar Mandal to All Participants:

yes

from Renu Pathak to All Participants:

yes

from Pradeep Singh to All Participants:

yes

from Bander Mansor AlQahtani to All Participants:

clear

from Rohit Singh to All Participants:

yes

from Dhanalaxmi Pawar to All Participants:

Yes

from Abhishek kumar to All Participants:

yes we can

from Manish bharti to All Participants:

yes

from Nithin R to All Participants:

yes Visible

from Anand C P to All Participants:

yes

from panditpragya to All Participants:

yes

from Ruta Narkhede to All Participants:

yes

from tusharrobin to All Participants:

yes
from Ashish Kumar Mandal to All Participants:

yes;

from KHUSHBOO NAG to All Participants:

Yes

from veeresh sindagi to All Participants:

sir this is my first last ,is there any practice file ?

from Rishabh . to All Participants:

https://chat.whatsapp.com/HdwOST7CSZUCPa7pZXEzUD

from Dhanalaxmi Pawar to All Participants:

Dual axis

from Rohith B to All Participants:

hi. mai know still now how many data files u have shared

from panditpragya to All Participants:

dual

from akhilraparthi1996 to All Participants:

dual

from tusharrobin to All Participants:

dual axis

from Abhishek kumar to All Participants:

dual axis

from Rishabh . to All Participants:

dual axis

from Rohit Singh to All Participants:

dual axis

from pauldesahagun to All Participants:

voice is breaking

from tusharrobin to All Participants:

blended axis

from Ruta Narkhede to All Participants:

blended axis

from KHUSHBOO NAG to All Participants:

Blending

from panditpragya to All Participants:

blended axis

from Rohit Singh to All Participants:

blended axis

from Learner success manager to All Participants:

Audio troubleshooting steps:

Click on Audio

Click on Audio Conference

Select Use Computer for Audio

Note: Please do not use the Call-in option, it will charge you.

from Mahaveer Singh to All Participants:

blemded axis

from Bander Mansor AlQahtani to All Participants:

blended

from Bander Mansor AlQahtani to All Participants:

sheet filter

from Ruta Narkhede to All Participants:

live and extract

from Pradeep Singh to All Participants:

live

from panditpragya to All Participants:

live

from Bander Mansor AlQahtani to All Participants:

live

from Bander Mansor AlQahtani to All Participants:

extract

from Anand C P to All Participants:

live and extract

from tusharrobin to All Participants:

live and extract

from GIJAULHAK ANSARI to All Participants:

live /Extract

from Rohith B to All Participants:

sir can u pleae say how many data files u have shared

from Ganesh Kadam to All Participants:

1000

from panditpragya to All Participants:

updating it

from akhilraparthi1996 to All Participants:

refresh

from Bander Mansor AlQahtani to All Participants:

refresh

from GIJAULHAK ANSARI to All Participants:

refresh

from Bander Mansor AlQahtani to All Participants:

from extract option

from Rishabh . to All Participants:

refresh

from Mahaveer Singh to All Participants:

refresh

from Vasu Acharya to All Participants:

refresh

from KHUSHBOO NAG to All Participants:

Refresh option

from KHUSHBOO NAG to All Participants:

No

from GIJAULHAK ANSARI to All Participants:

no

from Anuradha to All Participants:

no

from GIJAULHAK ANSARI to All Participants:

no

from Naveen Gambhir to All Participants:

no

from panditpragya to All Participants:

no

from Mahaveer Singh to All Participants:

no

from tusharrobin to All Participants:

noo

from Pradeep Singh to All Participants:

no

from Ashish Kumar Mandal to All Participants:

yes

from KHUSHBOO NAG to All Participants:

Yes

from Pradeep Singh to All Participants:

yes

from Bander Mansor AlQahtani to All Participants:

no

from ayush.solanki26@gmail.com to All Participants:

yes

from Anuradha to All Participants:

no

from Ashish Kumar Mandal to All Participants:

revision same

from pauldesahagun to All Participants:

sorry your voice is quite unclear from my end..

from Diwakar Singh to All Participants:

yes

from pauldesahagun to All Participants:

keeps on breaking not sure

from ayush.solanki26@gmail.com to All Participants:

made a new one

from Vasu Acharya to All Participants:

no

from Ashish Kumar Mandal to All Participants:

yes

from GIJAULHAK ANSARI to All Participants:

yes

from Naveen Gambhir to All Participants:

yes clear

from Pradeep Singh to All Participants:

yes

from Dhanalaxmi Pawar to All Participants:

yes

from KHUSHBOO NAG to All Participants:

Yes

from Abhishek kumar to All Participants:

from Vasu Acharya to All Participants:

I mean it

from gurralarajesh to All Participants:

Yes

from Ruta Narkhede to All Participants:

clear to me

from Rohit Singh to All Participants:

sir my first class can utell tblu for student we have to download or some other?? it's saying10 day
trail

from Pranav Chauhan to All Participants:

all good

from Rohit Singh to All Participants:

pls can u guide

from Vasu Acharya to All Participants:

I'll join again

from Rohit Singh to All Participants:

I k ow sir

from Pradeep Singh to All Participants:

no

from Divyanshu Gupta to All Participants:

what is lollipop chart

from Rohit Singh to All Participants:

I am asking just tell from which website sir twblu for students??

from Manish bharti to All Participants:

this is my first clas

from panditpragya to All Participants:

how would we know that which data we should present..i've made the data which we created in the
class. But im not how can we present other data on our own..mix and match

from panditpragya to All Participants:

ok

from Anuradha to All Participants:

done

from Abhishek kumar to All Participants:

done

from akhilraparthi1996 to All Participants:

done

from Ganesh Kadam to All Participants:

done

from veeresh sindagi to All Participants:

send dnlink of practice sheet

from pauldesahagun to All Participants:

wait which file again?

from pauldesahagun to All Participants:

hold on please
from veeresh sindagi to All Participants:

hello

from Ganesh Kadam to All Participants:

from Abhishek kumar to All Participants:

calculation 2 or more data

from Bander Mansor AlQahtani to All Participants:

mathematic process

from Anamika John to All Participants:

Sir one thing how can u write here in tablue

from Ashish Kumar Mandal to All Participants:

maths

from Anamika John to All Participants:

i m not getting this writing option

from PRIYA GADAGI to All Participants:

wer is calculation

from veeresh sindagi to All Participants:

sheet now available

from veeresh sindagi to All Participants:

wid m

from Anamika John to All Participants:

ok

from manghluna manghluna to All Participants:

sir voice is not clear

from biradarshivakumar898 to All Participants:

not audible

from gurralarajesh to All Participants:

No

from panditpragya to All Participants:

no

from GIJAULHAK ANSARI to All Participants:

no

from manghluna manghluna to All Participants:

clear now

from Abhishek kumar to All Participants:

no

from Ashish Kumar Mandal to All Participants:

no

from Renu Pathak to All Participants:

it's clear

from akhilraparthi1996 to All Participants:

no

from ABHAY YADAV to All Participants:

No

from Anuradha to All Participants:

no

from KHUSHBOO NAG to All Participants:

All good from my end

from manish mishra to All Participants:

no

from pauldesahagun to All Participants:

now it is clear

from Rishabh . to All Participants:

clear to me

from chandansingh6025 to All Participants:

no lound and clear

from adeebakhanum633 to All Participants:

yes

from pauldesahagun to All Participants:

i disconnected and reconnected the audio..

from Abhishek kumar to All Participants:

string,
from Ashish Kumar Mandal to All Participants:

int

from Dhanalaxmi Pawar to All Participants:

string

from Ganesh Kadam to All Participants:

string

from Abhishek kumar to All Participants:

int

from akhilraparthi1996 to All Participants:

numbr

from Ashish Kumar Mandal to All Participants:

float

from Ganesh Kadam to All Participants:

globe

from akhilraparthi1996 to All Participants:

string

from akhilraparthi1996 to All Participants:

calendar

from Dhanalaxmi Pawar to All Participants:

number

from akhilraparthi1996 to All Participants:

clock

from Rishabh . to All Participants:

map

from Ashish Kumar Mandal to All Participants:

string

from akhilraparthi1996 to All Participants:

glob

from Dhanalaxmi Pawar to All Participants:

date

from Gaurav kumar verma to All Participants:

boolean

from akhilraparthi1996 to All Participants:

globe

from Bander Mansor AlQahtani to All Participants:

time

from Ganesh Kadam to All Participants:

boolean

from Dhanalaxmi Pawar to All Participants:

date and time

from Abhishek kumar to All Participants:

boolean

from GIJAULHAK ANSARI to All Participants:

boolean

from Bander Mansor AlQahtani to All Participants:

date

from Diwakar Singh to All Participants:

num,tex,date,date/time,geo,bool

from Abhishek kumar to All Participants:

date and time

from Vasu Acharya to All Participants:

boolean

from Chaudhary Tuba to All Participants:

date time

from Vasu Acharya to All Participants:

string

from Vasu Acharya to All Participants:

date time

from Divyanshu Gupta to All Participants:

int, string,boolean

from KHUSHBOO NAG to All Participants:

Boolean, string, date and calendar, globe

from Abhishek kumar to All Participants:

from Pradeep Singh to All Participants:

yes

from Ashish Kariwdekar to All Participants:

Hello

from pauldesahagun to All Participants:

oops audio again..

from pauldesahagun to All Participants:

whats happening..

from Ganesh Kadam to All Participants:

done

from Abhishek kumar to All Participants:

from Rishabh . to All Participants:

yes

from gadaginamrata92 to All Participants:

yes

from Anuradha to All Participants:

yes

from Bander Mansor AlQahtani to All Participants:

yes

from Ganesh Kadam to All Participants:

yes

from Pradeep Singh to All Participants:

yes

from KHUSHBOO NAG to All Participants:

Yes

from Vasu Acharya to All Participants:

Yes

from Mahaveer Singh to All Participants:

yes

from Rishabh . to All Participants:

https://chat.whatsapp.com/HdwOST7CSZUCPa7pZXEzUD

from Rishabh . to All Participants:

yee

from Rishabh . to All Participants:

yes

from S J SAVITA to All Participants:

can you please repeat

from Pradeep Singh to All Participants:

yes

from Ganesh Kadam to All Participants:

yes

from Abhishek kumar to All Participants:

from Pradeep Singh to All Participants:

done

from Ganesh Kadam to All Participants:

The calulation is valid

from GIJAULHAK ANSARI to All Participants:

yes

from Ganesh Kadam to All Participants:

yes

from Pradeep Singh to All Participants:

yes

from Rishabh . to All Participants:

yes

from Anuradha to All Participants:

yes

from Bander Mansor AlQahtani to All Participants:

yes
from Vasu Acharya to All Participants:

Yes

from Vasu Acharya to All Participants:

can see it

from Bander Mansor AlQahtani to All Participants:

from Chaudhary Tuba to All Participants:

done

from Ganesh Kadam to All Participants:

done

from GIJAULHAK ANSARI to All Participants:

dn

from panditpragya to All Participants:

no... can you repeat

from GIJAULHAK ANSARI to All Participants:

yes

from KHUSHBOO NAG to All Participants:

Yes

from Vasu Acharya to All Participants:

Yes

from Bagdiya Suraj Santoshkumar to All Participants:

I am trying to double click on Rows and Column but its not working

from Bagdiya Suraj Santoshkumar to All Participants:

also In Marks

from tusharrobin to All Participants:

done

from GIJAULHAK ANSARI to All Participants:

dn

from Pradeep Singh to All Participants:

done

from GIJAULHAK ANSARI to All Participants:

done

from Abhishek kumar to All Participants:

from Dhanalaxmi Pawar to All Participants:

Yes

from Vasu Acharya to All Participants:

Done

from tusharrobin to All Participants:

done

from Ganesh Kadam to All Participants:

why it is negative numbers

from Ajay alappanavar to All Participants:

plz repeat once

from GIJAULHAK ANSARI to All Participants:

yes

from shobhang8 to All Participants:

repeat pls

from Rishabh . to All Participants:

it shows neg figure becoz it is a loss

from Pradeep Singh to All Participants:

done

from Ajay alappanavar to All Participants:

ok

from Ashish Kumar Mandal to All Participants:

come again

from Chaudhary Tuba to All Participants:

sir plz repeat again

from Pooja Yadav to All Participants:

Yes please

from tusharrobin to All Participants:

done
from Gaurav kumar verma to All Participants:

done

from GIJAULHAK ANSARI to All Participants:

done

from Vasu Acharya to All Participants:

Done

from Rishabh . to All Participants:

done

from Abhishek kumar to All Participants:

done

from GIJAULHAK ANSARI to All Participants:

yes

from gadaginamrata92 to All Participants:

I m not getting number field

from Pradeep Singh to All Participants:

yes

from Rishabh . to All Participants:

yes

from Vasu Acharya to All Participants:

Yes

from Divyanshu Gupta to All Participants:

yes

from Vasu Acharya to All Participants:

DONE

from Gaurav kumar verma to All Participants:

done

from Abhishek kumar to All Participants:

done

from Rishabh . to All Participants:

done

from Chaudhary Tuba to All Participants:

done

from Ganesh Kadam to All Participants:

yes

from Gaurav kumar verma to All Participants:

no error

from tusharrobin to All Participants:

done

from gadaginamrata92 to All Participants:

please repeat

from Pradeep Singh to All Participants:

no

from adeebakhanum633 to All Participants:

Done

from GIJAULHAK ANSARI to All Participants:

done

from KHUSHBOO NAG to All Participants:

Done

from GIJAULHAK ANSARI to All Participants:

no Error

from Ayesha Banu to All Participants:

done

from Peeyush (Faculty) to All Participants:

[Profit]/[Sales]

from KHUSHBOO NAG to All Participants:

Yes

from Anamika John to All Participants:

int

from Rishabh . to All Participants:

num

from Vasu Acharya to All Participants:

int
from Abhishek kumar to All Participants:

num

from Ganesh Kadam to All Participants:

number

from Bagdiya Suraj Santoshkumar to All Participants:

Integer

from tusharrobin to All Participants:

num

from Ruta Narkhede to All Participants:

number

from Dhanalaxmi Pawar to All Participants:

number

from Vasu Acharya to All Participants:

number

from Gaurav kumar verma to All Participants:

number

from KHUSHBOO NAG to All Participants:

Number

from Mohammad Sohail to All Participants:

=#

from Ganesh Kadam to All Participants:

by colour

from Abhishek kumar to All Participants:

=#

from KHUSHBOO NAG to All Participants:

from Ruta Narkhede to All Participants:

= sign

from Dhanalaxmi Pawar to All Participants:

from adeebakhanum633 to All Participants:

BY this Sign=

from tusharrobin to All Participants:

from ayush.solanki26@gmail.com to All Participants:

from Anil Kumar to All Participants:

=#

from pauldesahagun to All Participants:

how to go back to data page?

from Rohit Singh to All Participants:

pls repeat

from Bagdiya Suraj Santoshkumar to All Participants:

I did not gethis point

from Vasu Acharya to All Participants:

Ok got it

from ABHAY YADAV to All Participants:

=symbol

from Bagdiya Suraj Santoshkumar to All Participants:

Yes

from Pradeep Singh to All Participants:

no

from Rohit Singh to All Participants:

repeat sir

from Rishabh . to All Participants:

no

from Animesh Shrivastava to All Participants:

Can u pleease repeat formula creation

from Bagdiya Suraj Santoshkumar to All Participants:

I did not getthis point

from Animesh Shrivastava to All Participants:

missed it
from Bagdiya Suraj Santoshkumar to All Participants:

Equal to Sign before #

from Anamika John to All Participants:

Sir is there way to modify calculated one

from Bagdiya Suraj Santoshkumar to All Participants:

Got it

from Bagdiya Suraj Santoshkumar to All Participants:

Understood

from Ganesh Kadam to All Participants:

no

from Dhanalaxmi Pawar to All Participants:

No

from Anand C P to All Participants:

no

from KHUSHBOO NAG to All Participants:

No

from tusharrobin to All Participants:

no

from Vijay Pratap Singh to All Participants:

no need to modify data surce'

from S J SAVITA to All Participants:

repeat

from Rishabh . to All Participants:

done

from tusharrobin to All Attendees:

done

from Bander Mansor AlQahtani to All Participants:

done

from Anil Kumar to All Participants:

Too many decimal values..

from Bander Mansor AlQahtani to All Participants:

:)

from Pradeep Singh to All Participants:

done

from Kavita saha to All Participants:

done

from adeebakhanum633 to All Participants:

Done

from Vasu Acharya to All Participants:

if we will double click then also it starts reflecting

from akhilraparthi1996 to All Participants:

done

from Rohit Singh to All Participants:

sir that values are in negative or it is specifying

from gadaginamrata92 to All Participants:

Please show again how to reflect it in table

from gadaginamrata92 to All Participants:

Namrata

from gadaginamrata92 to All Participants:

No

from gadaginamrata92 to All Participants:

I dint get profit ration coulmn

from gadaginamrata92 to All Participants:

Yes

from Ganesh Kadam to All Participants:

profit ration is notadding properly

from gadaginamrata92 to All Participants:

yes got it

from Ganesh Kadam to All Participants:

if i say 29% profit this is not correct

from Pooja Yadav to All Participants:

Sir, this is my first class. May I know how far I am and how to cover?
from Vijay Pratap Singh to All Participants:

this is my first class too.

from Vijay Pratap Singh to All Participants:

either i have to download tableau

from 1984shashankkumar to All Participants:

Profit Ratio should reflect in %

from Gaurav kumar verma to All Participants:

done

from Vasu Acharya to All Participants:

Done

from Peeyush (Faculty) to All Participants:

SUM([Profit]) / SUM([Sales])

from chandansingh6025 to All Participants:

did you create a new calculation field??

from chandansingh6025 to All Participants:

or edited existing

from gadaginamrata92 to All Participants:

in format, i m not getting number field to convert decimal to zero

from PRIYA GADAGI to All Participants:

yes same

from Bagdiya Suraj Santoshkumar to All Participants:

Why AGG is written there?

from Gaurav kumar verma to All Participants:

done

from chandansingh6025 to All Participants:

sir please cehck chat

from chandansingh6025 to All Participants:

i got it somehow now

from Kavita saha to All Participants:

please repeat last one

from Rishabh . to All Participants:

profit ratio

from akhilraparthi1996 to All Participants:

profit /sales

from Pradeep Singh to All Participants:

profit ratio

from Abhishek kumar to All Participants:

profit ratio

from Kavita saha to All Participants:

sum of profit ratio please repeat with formula

from akhilraparthi1996 to All Participants:

profit ratio

from akhilraparthi1996 to All Participants:

sum profit ration

from akhilraparthi1996 to All Participants:

from Abhishek kumar to All Participants:

yes

from Rohith B to All Participants:

sir can u please un umute me once

from Rohith B to All Participants:

kk

from Rishabh . to All Participants:

-3472

from Gaurav kumar verma to All Participants:

yes

from akhilraparthi1996 to All Participants:

from Abhishek kumar to All Participants:

from Rishabh . to All Participants:

yes
from akhilraparthi1996 to All Participants:

from ABHAY YADAV to All Participants:

yes

from Anuradha to All Participants:

yes

from Rishabh . to All Participants:

114879

from akhilraparthi1996 to All Participants:

from Rishabh . to All Participants:

yes

from Anuradha to All Participants:

yes

from Bander Mansor AlQahtani to All Participants:

validation process right

from Bander Mansor AlQahtani to All Participants:

as a part of qulaity assurance

from S J SAVITA to All Participants:

how to check in the microsoft excel?

from BIMOSH SAHOO to All Participants:

hello sir, Vishnupriyatyagi2@gmail.com

is not able to attend the classes

On asking the simplilearn team ,they said its problem on the simpli learn side. But that has not been
resolved yet.

kindly help by passing the message to ur technical team .

from Abhishek kumar to All Participants:

-28.87

from ABHAY YADAV to All Participants:

-28.7

from Anuradha to All Participants:

yes

from Abhishek kumar to All Participants:

from chandansingh6025 to All Participants:

why are we using sum of profit/ ratio

from pauldesahagun to All Participants:

having bad audio reception quality

from akhilraparthi1996 to All Participants:

total profit/total sum

from akhilraparthi1996 to All Participants:

total sales

from Abhishek kumar to All Participants:

-3472

from Abhishek kumar to All Participants:

from Abhishek kumar to All Participants:

114880

from Rishabh . to All Participants:

yes

from Abhishek kumar to All Participants:

from Anuradha to All Participants:

yes

from KHUSHBOO NAG to All Participants:

Yes

from Bander Mansor AlQahtani to All Participants:

can you repeat this again please

from Bander Mansor AlQahtani to All Participants:

I dont get it

from akhilraparthi1996 to All Participants:

can we do it row wise in excelfor sum(profit/sum (sales)

from Rishabh . to All Participants:

clear

from chandansingh6025 to All Participants:

what is the use of sum of profit ratio

from Bander Mansor AlQahtani to All Participants:

can you repeat this again please

from tusharrobin to All Attendees:

uderstood

from Bander Mansor AlQahtani to All Participants:

I dont get it

from Ganesh Kadam to All Participants:

you mean to say -28.87% is profit ration

from Ganesh Kadam to All Participants:

ratio

from Bander Mansor AlQahtani to All Participants:

what is the diffrence bet ween two ways

from Ashish Kumar Mandal to All Participants:

explain aggregate once more

from Bander Mansor AlQahtani to All Participants:

I get this poiunt

from Bander Mansor AlQahtani to All Participants:

but aggregated should be one result, why it's differ in each row

from Ashish Kumar Mandal to All Participants:

got it

from Chaudhary Tuba to All Participants:

done

from Bander Mansor AlQahtani to All Participants:

ok

from Bander Mansor AlQahtani to All Participants:

this point clear

from Bagdiya Suraj Santoshkumar to All Participants:

Could you please unmute me?I will ask myq uestion then

from Ashish Kumar Mandal to All Participants:

-10

from Ganesh Kadam to All Participants:

0.5

from Bander Mansor AlQahtani to All Participants:

it will excuted in row level

from Bander Mansor AlQahtani to All Participants:

this point is very clear

from Ganesh Kadam to All Participants:

0.50

from akhilraparthi1996 to All Participants:

we can do it agrregate for 2nd one not row wise

from pauldesahagun to All Participants:

10/20

from Bagdiya Suraj Santoshkumar to All Participants:

2.5

from Anuradha to All Participants:

0.5

from Dhanalaxmi Pawar to All Participants:

0.50

from Ganesh Kadam to All Participants:

0.50

from Bander Mansor AlQahtani to All Participants:

0.5 first calc

from Rishabh . to All Participants:

0.5

from akhilraparthi1996 to All Participants:

0,50

from pauldesahagun to All Participants:

.5
from panditpragya to All Participants:

0.5

from Aiswarya S to All Participants:

0.5

from GIJAULHAK ANSARI to All Participants:

.5

from tusharrobin to All Attendees:

0.5

from Ashish Kariwdekar to All Participants:

0.5

from pauldesahagun to All Participants:

10/20

from KHUSHBOO NAG to All Participants:

0.5

from Ruta Narkhede to All Participants:

0.5 for all rows

from S J SAVITA to All Participants:

0.5

from Bander Mansor AlQahtani to All Participants:

0.5

from S J SAVITA to All Participants:

0.5

from Pradeep Singh to All Participants:

0.5

from tusharrobin to All Attendees:

.5 for all rows for profit ratio

from kumar kavin to All Participants:

0.5

from gautamakankshan@gmail.com to All Participants:

rest all 0.5

from Bagdiya Suraj Santoshkumar to All Participants:

For Seocnd its .5

from kumar kavin to All Participants:

0.5 for all

from Bagdiya Suraj Santoshkumar to All Participants:

0.5

from S J SAVITA to All Participants:

0.5

from Ganesh Kadam to All Participants:

0.50

from Ashish Kariwdekar to All Participants:

0.5

from Mohammad Sohail to All Participants:

0.5 second cal

from Rishabh . to All Participants:

0.5

from S J SAVITA to All Participants:

all answers are .5

from pauldesahagun to All Participants:

.5 constant

from GIJAULHAK ANSARI to All Participants:

0.5

from 1984shashankkumar to All Participants:

For both it is 0.5

from Rishabh . to All Participants:

yes

from Bander Mansor AlQahtani to All Participants:

yes

from Animesh Shrivastava to All Participants:

.5 both

from Pradeep Singh to All Participants:

yes
from Naveen Gambhir to All Participants:

.5 for both

from Naveen Gambhir to All Participants:

.5 for both

from GIJAULHAK ANSARI to All Participants:

yes

from chandansingh6025 to All Participants:

how it is .5

from GIJAULHAK ANSARI to All Participants:

2.5

from Ruta Narkhede to All Participants:

2.5

from KHUSHBOO NAG to All Participants:

2.5

from chandansingh6025 to All Participants:

ok

from Ganesh Kadam to All Participants:

150

from Animesh Shrivastava to All Participants:

150

from Rishabh . to All Participants:

150/300

from akhilraparthi1996 to All Participants:

2.5

from kumar kavin to All Participants:

150

from Bagdiya Suraj Santoshkumar to All Participants:

150

from panditpragya to All Participants:

150

from GIJAULHAK ANSARI to All Participants:

150

from Pradeep Singh to All Participants:

150

from Anuradha to All Participants:

150

from Pradeep Singh to All Participants:

300

from Animesh Shrivastava to All Participants:

300

from GIJAULHAK ANSARI to All Participants:

300

from Bagdiya Suraj Santoshkumar to All Participants:

300

from panditpragya to All Participants:

300

from Anuradha to All Participants:

300

from tusharrobin to All Attendees:

300

from Bander Mansor AlQahtani to All Participants:

150/300

from Bander Mansor AlQahtani to All Participants:

0.5

from Gaurav kumar verma to All Participants:

.5

from tusharrobin to All Attendees:

.5

from GIJAULHAK ANSARI to All Participants:

yes

from Pradeep Singh to All Participants:

yes
from Dhanalaxmi Pawar to All Participants:

yes

from Chaudhary Tuba to All Participants:

yes

from KHUSHBOO NAG to All Participants:

Yes

from Ganesh Kadam to All Participants:

Error coming only 1000 can be added

from akhilraparthi1996 to All Participants:

please repeat

from Rishabh . to All Participants:

click add all members

from Anuradha to All Participants:

yes

from Chaudhary Tuba to All Participants:

from Pradeep Singh to All Participants:

yes

from Nikhil Bhalerao to All Participants:

done

from akhilraparthi1996 to All Participants:

string function explaination sir

from akhilraparthi1996 to All Participants:

okies

from Dhanalaxmi Pawar to All Participants:

793

from panditpragya to All Participants:

793

from Gaurav kumar verma to All Participants:

793

from akhilraparthi1996 to All Participants:

793

from Ruta Narkhede to All Participants:

793

from Chaudhary Tuba to All Participants:

793

from Karthikeyan Ramasamy to All Participants:

pls repeat, audio issue

from Anand C P to All Participants:

Audio problem

from tusharrobin to All Attendees:

done

from Karthikeyan Ramasamy to All Participants:

pls could you repeat,

from gautamakankshan@gmail.com to All Participants:

done

from Aiswarya S to All Participants:

y 4?

from Peeyush (Faculty) to All Participants:

LEFT([Customer Name] , 4)

from Abhishek kumar to All Participants:

from Anuradha to All Participants:

done

from GIJAULHAK ANSARI to All Participants:

dn

from Divyanshu Gupta to All Participants:

yes

from tusharrobin to All Attendees:

done

from ajayapradhan9777@gmail.com to All Attendees:

YES
from Karthikeyan Ramasamy to All Participants:

could you unmute

from akhilraparthi1996 to All Participants:

y4?

from tusharrobin to All Attendees:

done

from akhilraparthi1996 to All Participants:

ok

from Gaurav kumar verma to All Participants:

done

from panditpragya to All Participants:

done

from GIJAULHAK ANSARI to All Participants:

done

from Pradeep Singh to All Participants:

done Right Func

from Divya Chaurasiya to All Participants:

done

from adeebakhanum633 to All Participants:

Done

from panditpragya to All Participants:

how can we write function to separate first name and last name

from Anuradha to All Participants:

done right func

from Chaudhary Tuba to All Participants:

I have Right Function

from Chaudhary Tuba to All Participants:

done

from Shreya Badkelwar to All Participants:

done
from akhilraparthi1996 to All Participants:

yes

from panditpragya to All Participants:

yes

from akhilraparthi1996 to All Participants:

done

from Ganesh Kadam to All Participants:

yes

from Divya Chaurasiya to All Participants:

yes

from KHUSHBOO NAG to All Participants:

Yes

from akhilraparthi1996 to All Participants:

RIGHT([Customer Name],8)

from panditpragya to All Participants:

RIGHT([Customer Name] , 5)

from Animesh Shrivastava to All Participants:

done

from tusharrobin to All Attendees:

RIGHT("Customer Name", 4)

from Pradeep Singh to All Participants:

RIGHT([Customer Name],4)

from Ganesh Kadam to All Participants:

RIGHT([Customer Name],4)

from Ashish Kumar Mandal to All Participants:

voice is not coming

from kumar kavin to All Participants:

MID(customer name,5)

from Bagdiya Suraj Santoshkumar to All Participants:

abc d

from Shreya Badkelwar to All Participants:

bc def

from PRIYA GADAGI to All Participants:

abc

from chandansingh6025 to All Participants:

c def

from Bagdiya Suraj Santoshkumar to All Participants:

fedc

from Dhanalaxmi Pawar to All Participants:

c def

from PRIYA GADAGI to All Participants:

cdef

from Ganesh Kadam to All Participants:

5 letter

from Bagdiya Suraj Santoshkumar to All Participants:

got it

from Peeyush (Faculty) to All Participants:

RIGHT([Customer Name],5)

from Ganesh Kadam to All Participants:

two

from Santhosh Kumar N P to All Participants:

from Vijay Pratap Singh to All Participants:

not audible

from GIJAULHAK ANSARI to All Participants:

from akhilraparthi1996 to All Participants:

customer name ,customer id

from Ashish Kumar Mandal to All Participants:

not audible

from Chaudhary Tuba to All Participants:

y
from akhilraparthi1996 to All Participants:

from Nikhil Bhalerao to All Participants:

yes

from Anuradha to All Participants:

from Dhanalaxmi Pawar to All Participants:

yes

from Ganesh Kadam to All Participants:

from Renu Pathak to All Participants:

from Bander Mansor AlQahtani to All Participants:

yes audiable

from Gaurav kumar verma to All Participants:

yes

from KHUSHBOO NAG to All Participants:

Yes

from Bander Mansor AlQahtani to All Participants:

done

from ABHAY YADAV to All Participants:

yes loud and clear

from Richa Tiwari to All Participants:

how to write first 5 for lats name?

from Rishabh . to All Participants:

in middle also?

from kumar kavin to All Participants:

true for aa

from GIJAULHAK ANSARI to All Participants:

done

from Anuradha to All Participants:

done

from Abhishek kumar to All Participants:

string

from Dhanalaxmi Pawar to All Participants:

string

from kumar kavin to All Participants:

oolean

from ayush.solanki26@gmail.com to All Participants:

boolean

from Gaurav kumar verma to All Participants:

string

from Abhishek kumar to All Participants:

srry

from Bander Mansor AlQahtani to All Participants:

boolean

from Anand C P to All Participants:

Boolean

from Abhishek kumar to All Participants:

boolean

from kumar kavin to All Participants:

boolean

from Divyanshu Gupta to All Participants:

boolean

from KHUSHBOO NAG to All Participants:

Boolean

from Chaudhary Tuba to All Participants:

done

from PRIYA GADAGI to All Participants:

substring ?

from PRIYA GADAGI to All Participants:

for starts with

from Anuradha to All Participants:

STARTSWITH([Customer Name],"an")

from Mahaveer Singh to All Participants:

STARTSWITH([Customer Name],"aa")

from GIJAULHAK ANSARI to All Participants:

STARTSWITH([Customer Name],"a")

from Shreya Badkelwar to All Participants:

STARTSWITH([Customer Name], "Sa")

from Abhishek kumar to All Participants:

STARTSWITH([Customer Name],"ad")

from Mohammad Sohail to All Participants:

ENDSWITH([Customer Name],"aa")

from Ruta Narkhede to All Participants:

ENDSWITH([Customer Name],'an')

from Anuradha to All Participants:

ENDSWITH([Customer Name],"na")

from Shreya Badkelwar to All Participants:

ENDSWITH([Customer Name],"n")

from Peeyush (Faculty) to All Participants:

STARTSWITH([Customer Name],'aa')

from akhilraparthi1996 to All Participants:

done

from panditpragya to All Participants:

STARTSWITH([Customer Name],"d")---this is not working and showing 1 dependency

from Chaudhary Tuba to All Participants:

done both of them

from Rishabh . to All Participants:

done

from Peeyush (Faculty) to All Participants:

ENDSWITH([Customer Name],'aa')

from Gaurav kumar verma to All Participants:

ENDSWITH([Customer Name],"er")

from panditpragya to All Participants:

done but not showing

from Abhishek kumar to All Participants:

from Pradeep Singh to All Participants:

yes

from Rishabh . to All Participants:

yes

from Bander Mansor AlQahtani to All Participants:

fine

from Anuradha to All Participants:

yes

from Bander Mansor AlQahtani to All Participants:

done

from Bagdiya Suraj Santoshkumar to All Participants:

I have one question

from Bander Mansor AlQahtani to All Participants:

count

from Peeyush (Faculty) to All Participants:

LEN([Customer Name])

from Abhishek kumar to All Participants:

string

from akhilraparthi1996 to All Participants:

dtring

from tusharrobin to All Attendees:

str

from Chaudhary Tuba to All Participants:

int

from Mohammad Sohail to All Participants:

Int
from ABHAY YADAV to All Participants:

int

from tusharrobin to All Attendees:

num

from Ruta Narkhede to All Participants:

number

from GIJAULHAK ANSARI to All Participants:

int

from Anil Kumar to All Participants:

numer

from Anand C P to All Participants:

Numbet

from Gaurav kumar verma to All Participants:

number

from Anuradha to All Participants:

done

from GIJAULHAK ANSARI to All Participants:

dn

from Bagdiya Suraj Santoshkumar to All Participants:

to perform all the funtions , do we need to drag perticular column into the Rows sheld?

from Bagdiya Suraj Santoshkumar to All Participants:

I mean if we do not drag

from panditpragya to All Participants:

can you repeat Len

from Ganesh Kadam to All Participants:

so we have to do discrete

from chandansingh6025 to All Participants:

why the number is 78

from Bander Mansor AlQahtani to All Participants:

why 78

from Peeyush (Faculty) to All Participants:

LEN([Customer Name])

from Bander Mansor AlQahtani to All Participants:

huge number

from Ganesh Kadam to All Participants:

no

from Ruta Narkhede to All Participants:

no

from Shreya Badkelwar to All Participants:

no

from ABHAY YADAV to All Participants:

no

from Ashish Kumar Mandal to All Participants:

no

from Bagdiya Suraj Santoshkumar to All Participants:

No

from chandansingh6025 to All Participants:

nope

from Divyanshu Gupta to All Participants:

no length is wrong

from akhilraparthi1996 to All Participants:

please show len fun

from Bander Mansor AlQahtani to All Participants:

I think we have to use distanct

from akhilraparthi1996 to All Participants:

again

from tusharrobin to All Attendees:

13

from akhilraparthi1996 to All Participants:

got it

from pauldesahagun to All Participants:

13
from Abhishek kumar to All Participants:

13

from Ruta Narkhede to All Participants:

13

from Dhanalaxmi Pawar to All Participants:

13

from GIJAULHAK ANSARI to All Participants:

13

from panditpragya to All Participants:

13

from KHUSHBOO NAG to All Participants:

78

from GIJAULHAK ANSARI to All Participants:

it has cal of all 6 fields

from KHUSHBOO NAG to All Participants:

78

from panditpragya to All Participants:

didn't undsttand

from Rishabh . to All Participants:

yes

from Anuradha to All Participants:

yes

from Ruta Narkhede to All Participants:

yes

from Anil Kumar to All Participants:

yes

from Ashish Kumar Mandal to All Participants:

yes

from Gaurav kumar verma to All Participants:

yes

from chandansingh6025 to All Participants:

why 6

from Ganesh Kadam to All Participants:

agg

from Ashish Kumar Mandal to All Participants:

select 1

from Bagdiya Suraj Santoshkumar to All Participants:

13

from Ashish Kumar Mandal to All Participants:

13

from Anuradha to All Participants:

13

from Dhanalaxmi Pawar to All Participants:

13

from Gaurav kumar verma to All Participants:

13

from Gaurav kumar verma to All Participants:

78

from Ashish Kumar Mandal to All Participants:

78

from Anuradha to All Participants:

78

from Ruta Narkhede to All Participants:

13

from Bagdiya Suraj Santoshkumar to All Participants:

13

from Anamika John to All Participants:

13

from Abhishek kumar to All Participants:

78

from Animesh Shrivastava to All Participants:

13
from Abhishek kumar to All Participants:

13

from Dhanalaxmi Pawar to All Participants:

13

from Ruta Narkhede to All Participants:

13

from Ruta Narkhede to All Participants:

13

from Ganesh Kadam to All Participants:

13

from Dhanalaxmi Pawar to All Participants:

13

from Bagdiya Suraj Santoshkumar to All Participants:

13

from Anamika John to All Participants:

13

from Animesh Shrivastava to All Participants:

13

from chandansingh6025 to All Participants:

why it is taking 6

from chandansingh6025 to All Participants:

row

from Ganesh Kadam to All Participants:

done

from KHUSHBOO NAG to All Participants:

Done

from Gaurav kumar verma to All Participants:

ok

from Mahaveer Singh to All Participants:

done

from Anuradha to All Participants:

yes got it

from tusharrobin to All Attendees:

got it

from Ashish Kumar Mandal to All Participants:

come again

from chandansingh6025 to All Participants:

why it is taking 6 rows

from Chaudhary Tuba to All Participants:

repeat plz

from chandansingh6025 to All Participants:

??

from chandansingh6025 to All Participants:

??

from KHUSHBOO NAG to All Participants:

Count

from Ashish Kumar Mandal to All Participants:

repeat once

from Gaurav kumar verma to All Participants:

count

from tusharrobin to All Attendees:

Count

from KHUSHBOO NAG to All Participants:

Click on count, so we can give 6 rows

from Bagdiya Suraj Santoshkumar to All Participants:

In My tableu, its showing the agg but showing th correct result

from Bagdiya Suraj Santoshkumar to All Participants:

yes

from pauldesahagun to All Participants:

can you repeat it

from Anuradha to All Participants:

can you please repate

from Ganesh Kadam to All Participants:

no display

from chandansingh6025 to All Participants:

yes please repeat

from Anuradha to All Participants:

yes

from chandansingh6025 to All Participants:

got it

from chandansingh6025 to All Participants:

sir

from chandansingh6025 to All Participants:

thanks

from Santhosh Kumar N P to All Participants:

space

from Shreya Badkelwar to All Participants:

space

from akhilraparthi1996 to All Participants:

first name string ?

from GIJAULHAK ANSARI to All Participants:

space

from Diwakar Singh to All Participants:

split

from Anuradha to All Participants:

space

from Rohit Singh to All Participants:

pls go slow

from Diwakar Singh to All Participants:

yes

from KHUSHBOO NAG to All Participants:

No

from Anuradha to All Participants:

done

from Peeyush (Faculty) to All Participants:

SPLIT([Customer Name],' ',1)

from tusharrobin to All Attendees:

Done

from chandansingh6025 to All Participants:

done

from KHUSHBOO NAG to All Participants:

Yes

from GIJAULHAK ANSARI to All Participants:

SPLIT([Customer Name],' ', 2)

from Shreya Badkelwar to All Participants:

done

from tusharrobin to All Attendees:

done

from panditpragya to All Participants:

SPLIT([Customer Name], " ", 2)

from Peeyush (Faculty) to All Participants:

SPLIT([Customer Name],' ',2)

from Anil Kumar to All Participants:

SPLIT([Customer Name],' ',2)

from Divyanshu Gupta to All Participants:

done

from KHUSHBOO NAG to All Participants:

Yes, got it

from Naveen Gambhir to All Participants:

done

from Mahaveer Singh to All Participants:

SPLIT([Customer Name],' ',2)

from Anuradha to All Participants:

done
from Mahaveer Singh to All Participants:

done

from Ashish Kariwdekar to All Participants:

how are the token numbers decided?

from Chaudhary Tuba to All Participants:

done

from Gaurav kumar verma to All Participants:

done

from Bagdiya Suraj Santoshkumar to All Participants:

Cacn you unmute me?

from Animesh Shrivastava to All Participants:

done

from Bagdiya Suraj Santoshkumar to All Participants:

I have one question

from Anuradha to All Participants:

if we have First name and Last name then how to add

from Ashish Kariwdekar to All Participants:

If the nme is Ram Kumar singh then it will will be Ram - 1, Kumar - 2 and Singh -3, righ?

from Mohammad Sohail to All Participants:

Concanate

from Santhosh Kumar N P to All Participants:

concat

from kumar kavin to All Participants:

concatenate

from Bander Mansor AlQahtani to All Participants:

Plus

from Abhishek kumar to All Participants:

concat

from tusharrobin to All Attendees:

add the white space as well in the formula

from Bander Mansor AlQahtani to All Participants:

+''+

from Divyanshu Gupta to All Participants:

yes done

from Animesh Shrivastava to All Participants:

yes

from Abhishek kumar to All Participants:

from Bander Mansor AlQahtani to All Participants:

got it

from Ganesh Kadam to All Participants:

yes

from Santhosh Kumar N P to All Participants:

yes

from Pradeep Singh to All Participants:

yes

from GIJAULHAK ANSARI to All Participants:

yes

from KHUSHBOO NAG to All Participants:

Yes

from Anil Kumar to All Participants:

can add... + ' ' +

from tusharrobin to All Attendees:

done

from Ashish Kariwdekar to All Participants:

Please again

from gadaginamrata92 to All Participants:

please give the formula

from Peeyush (Faculty) to All Participants:

[First Name] + "--"+[Last Name]

from pauldesahagun to All Participants:

how do i do it if i did not assign a function name but instead did straight with the formula?
from Ashish Kariwdekar to All Participants:

How do you come to the formula again from the table column

from Ashish Kariwdekar to All Participants:

Thanks

from Bander Mansor AlQahtani to All Participants:

we can also just add the customer name

from pauldesahagun to All Participants:

yeah but i did not assign a function name how to go forward..

from chandansingh6025 to All Participants:

when to use, in function

from chandansingh6025 to All Participants:

and when not to

from pauldesahagun to All Participants:

yes..for both first name and last name

from Ashish Kariwdekar to All Participants:

Can you paste the formula here

from pauldesahagun to All Participants:

i did not assign a function name but did the calc

from Ashish Kariwdekar to All Participants:

Got it

from pauldesahagun to All Participants:

sure

from chandansingh6025 to All Participants:

when to use , in formula

from Chaudhary Tuba to All Participants:

concat function not shown in tabeu

from Bander Mansor AlQahtani to All Participants:

thanks

from Ashish Kumar Mandal to All Participants:

break

from Ashish Kariwdekar to All Participants:

Can you show the string func tab and the Min and maximum counts shows the same.

from chandansingh6025 to All Participants:

comma

from Ashish Kariwdekar to All Participants:

Like 13 for min and 13 for maximum as well

from ayush.solanki26@gmail.com to All Participants:

break needed

from Ashish Kumar Mandal to All Participants:

break

from Ashish Kariwdekar to All Participants:

10

from Ashish Kariwdekar to All Participants:

yes

from Ashish Kariwdekar to All Participants:

okay, got you

from tusharrobin to All Attendees:

done

from Mahaveer Singh to All Participants:

done

from GIJAULHAK ANSARI to All Participants:

dn

from Santhosh Kumar N P to All Participants:

done

from Diwakar Singh to All Participants:

done

from Ashish Kariwdekar to All Participants:

Done

from Anil Kumar to All Participants:

How long will be the break sir?

from gautamakankshan@gmail.com to All Participants:

done
from chandansingh6025 to All Participants:

done

from pauldesahagun to All Participants:

not 30 mins?

from Divyanshu Gupta to All Participants:

Please Explain this query i am adding a underscore in delimeter but it concat it SPLIT([Customer
Name] , '_' , 1)

from Divyanshu Gupta to All Participants:

And at the token number 2 it doesnot shown any data

from Pradeep Singh to All Participants:

yes

from GIJAULHAK ANSARI to All Participants:

yes

from Ayesha Banu to All Participants:

yes

from Santhosh Kumar N P to All Participants:

yes

from Mahaveer Singh to All Participants:

yes

from Dhanalaxmi Pawar to All Participants:

Yes

from manghluna manghluna to All Participants:

yes sir

from Zubeda begum to All Participants:

yes

from Anuradha to All Participants:

yes

from Ganesh Kadam to All Participants:

yes

from Divyanshu Gupta to All Participants:

yes
from akhilraparthi1996 to All Participants:

from Santhosh Kumar N P to All Participants:

no it cant

from Anuradha to All Participants:

no

from Pooja Yadav to All Participants:

no

from akhilraparthi1996 to All Participants:

no

from Shreya Badkelwar to All Participants:

no

from Pooja Yadav to All Participants:

no

from Santhosh Kumar N P to All Participants:

will it return any error message?

from Divyanshu Gupta to All Participants:

ok

from Divyanshu Gupta to All Participants:

okclear

from Anil Kumar to All Participants:

will add date

from Anuradha to All Participants:

it will add

from Santhosh Kumar N P to All Participants:

i feel like these are a replica of excel formula

from akhilraparthi1996 to All Participants:

from Anuradha to All Participants:

yes

from Anil Kumar to All Participants:

yes

from Bander Mansor AlQahtani to All Participants:

calc the diffrent between two dates

from Gaurav kumar verma to All Participants:

diff between start and end date

from Santhosh Kumar N P to All Participants:

diff in days btwn 2 dates

from akhilraparthi1996 to All Participants:

number of days

from akhilraparthi1996 to All Participants:

between

from Bander Mansor AlQahtani to All Participants:

dates

from Santhosh Kumar N P to All Participants:

int

from Anil Kumar to All Participants:

date

from Dhanalaxmi Pawar to All Participants:

date

from Abhishek kumar to All Participants:

date

from Ruta Narkhede to All Participants:

number

from ABHAY YADAV to All Participants:

numerical

from Gaurav kumar verma to All Participants:

number

from Diwakar Singh to All Participants:

num

from Bander Mansor AlQahtani to All Participants:

sorry numroical
from Divyanshu Gupta to All Participants:

Int

from Ganesh Kadam to All Participants:

number

from Bander Mansor AlQahtani to All Participants:

it will return a numrical format

from Anuradha to All Participants:

number

from Anil Kumar to All Participants:

no..in numbre

from Animesh Shrivastava to All Participants:

number

from Chaudhary Tuba to All Participants:

clear

from Pradeep Singh to All Participants:

yes

from Dhanalaxmi Pawar to All Participants:

order date

from panditpragya to All Participants:

order date

from Gaurav kumar verma to All Participants:

ordr date

from Anil Kumar to All Participants:

yes..

from akhilraparthi1996 to All Participants:

order date

from Ganesh Kadam to All Participants:

order dare

from Santhosh Kumar N P to All Participants:

order date

from akhilraparthi1996 to All Participants:

ship

from akhilraparthi1996 to All Participants:

date

from Ruta Narkhede to All Participants:

ship date

from Mohammad Sohail to All Participants:

Hirarchy

from Anil Kumar to All Participants:

selected the year

from akhilraparthi1996 to All Participants:

we selected as year

from Bander Mansor AlQahtani to All Participants:

as default

from Abhishek kumar to All Participants:

yes

from Bander Mansor AlQahtani to All Participants:

yhes

from akhilraparthi1996 to All Participants:

from Santhosh Kumar N P to All Participants:

yes]

from Ganesh Kadam to All Participants:

yes

from Anil Kumar to All Participants:

ys

from Pradeep Singh to All Participants:

yes

from Chaudhary Tuba to All Participants:

from akhilraparthi1996 to All Participants:

right click
from Abhishek kumar to All Participants:

clicking on +

from akhilraparthi1996 to All Participants:

change to dte

from KHUSHBOO NAG to All Participants:

Yes

from GIJAULHAK ANSARI to All Participants:

please repeat

from Anuradha to All Participants:

from Chaudhary Tuba to All Participants:

done

from Pradeep Singh to All Participants:

done

from Gaurav kumar verma to All Participants:

done

from Animesh Shrivastava to All Participants:

done

from tusharrobin to All Attendees:

Can you repeat how to remove year from order date?

from chandansingh6025 to All Participants:

repeat please

from Peeyush (Faculty) to All Attendees:

DATEADD('day' , 2 , [Order Date])

from Pradeep Singh to All Participants:

done

from Chaudhary Tuba to All Participants:

from chandansingh6025 to All Participants:

please repeat

from Peeyush (Faculty) to All Attendees:

DATEADD('month' ,1 , [Order Date])

from Chaudhary Tuba to All Participants:

done

from chandansingh6025 to All Participants:

can you please repeat

from Pradeep Singh to All Participants:

done

from Gaurav kumar verma to All Participants:

done

from tusharrobin to All Attendees:

repeat for dateadd

from chandansingh6025 to All Participants:

from Ruta Narkhede to All Participants:

previous month

from akhilraparthi1996 to All Participants:

behind 1 month

from Anuradha to All Participants:

2nd

from Anil Kumar to All Participants:

previous month?

from Animesh Shrivastava to All Participants:

2013

from Dhanalaxmi Pawar to All Participants:

yes

from tusharrobin to All Attendees:

please repeat dateadd

from chandansingh6025 to All Participants:

can you please check chat box

from chandansingh6025 to All Participants:

please repeat the date add function

from chandansingh6025 to All Participants:

yes

from Richa Tiwari to All Participants:

please repeat ship date calculation

from Ashish Kumar Mandal to All Participants:

ship date repeat

from Bander Mansor AlQahtani to All Participants:

repeart ship date step please

from chandansingh6025 to All Participants:

having issues with mic

from Bander Mansor AlQahtani to All Participants:

so like it is

from Bander Mansor AlQahtani to All Participants:

without any shange right

from chandansingh6025 to All Participants:

got it

from Rishabh . to All Participants:

from Dhanalaxmi Pawar to All Participants:

from Ganesh Kadam to All Participants:

from Anuradha to All Participants:

from Santhosh Kumar N P to All Participants:

from Peeyush (Faculty) to All Attendees:

DATEDIFF('day', [Order Date], [Ship Date])

from Bander Mansor AlQahtani to All Participants:

done

from tusharrobin to All Attendees:

done

from Chaudhary Tuba to All Participants:

done

from Anuradha to All Participants:

done

from KHUSHBOO NAG to All Participants:

Done

from Shreya Badkelwar to All Participants:

no

from Ganesh Kadam to All Participants:

no

from Shreya Badkelwar to All Participants:

minimum

from Ganesh Kadam to All Participants:

avg

from Ganesh Kadam to All Participants:

max

from Bander Mansor AlQahtani to All Participants:

repeat please

from Ganesh Kadam to All Participants:

why 6th jan had 3 results

from Ashish Kariwdekar to All Participants:

why ae we taking order in text?

from Ashish Kariwdekar to All Participants:

okay

from Peeyush (Faculty) to All Attendees:

DATENAME('month', [Order Date])

from Ashish Kariwdekar to All Participants:

you have to give space after evey , in the alculation?

from Ashish Kariwdekar to All Participants:

ok
from Chaudhary Tuba to All Participants:

done

from Anuradha to All Participants:

done

from Pradeep Singh to All Participants:

done

from Peeyush (Faculty) to All Attendees:

DATENAME('year', [Order Date])

from Bander Mansor AlQahtani to All Participants:

done

from Anuradha to All Participants:

number

from panditpragya to All Participants:

num.

from Ganesh Kadam to All Participants:

number

from Chaudhary Tuba to All Participants:

num

from Peeyush (Faculty) to All Attendees:

DATEPART('month' ,[Order Date])

from Ashish Kariwdekar to All Participants:

why date part for this one?

from tusharrobin to All Attendees:

done

from Bander Mansor AlQahtani to All Participants:

date part again please

from Bander Mansor AlQahtani to All Participants:

wrong

from Bander Mansor AlQahtani to All Participants:

wrong result

from Ashish Kariwdekar to All Participants:

But why are we using date part here?

from Chaudhary Tuba to All Participants:

done

from Ashish Kariwdekar to All Participants:

okay

from ABHAY YADAV to All Participants:

it returning yesr in date part

from Santhosh Kumar N P to All Participants:

how to get, Sunday, Monday ???

from akhilraparthi1996 to All Participants:

from Ganesh Kadam to All Participants:

yes

from Chaudhary Tuba to All Participants:

no

from chandansingh6025 to All Participants:

YEAR TO DATE

from 1984shashankkumar to All Participants:

year till date

from Santhosh Kumar N P to All Participants:

Year to date

from Anuradha to All Participants:

year till date

from Ganesh Kadam to All Participants:

year to date

from chandansingh6025 to All Participants:

QUARTER TO DATE

from Santhosh Kumar N P to All Participants:

Month to date

from Ganesh Kadam to All Participants:

month to date
from Rishabh . to All Participants:

quarter

from chandansingh6025 to All Participants:

MONTH TP DATE

from Ganesh Kadam to All Participants:

qtr to date

from Santhosh Kumar N P to All Participants:

2022

from akhilraparthi1996 to All Participants:

full year data

from chandansingh6025 to All Participants:

TOTAL FROM1/1

from Gaurav kumar verma to All Participants:

jan to 24 sep

from Rishabh . to All Participants:

24 spet 2023

from Ganesh Kadam to All Participants:

fy or cy

from akhilraparthi1996 to All Participants:

monthly data in MTD

from Anuradha to All Participants:

till 24 sep 2022

from chandansingh6025 to All Participants:

MTD :01/09/2022

from Gaurav kumar verma to All Participants:

1 sep to 24 sep

from Ashish Kariwdekar to All Participants:

please cn you provide the diff between date name and date part?

from Bander Mansor AlQahtani to All Participants:

only month calculations

from Bander Mansor AlQahtani to All Participants:

calculations in the same quarter

from chandansingh6025 to All Participants:

01/09/2022

from chandansingh6025 to All Participants:

3RD

from Gaurav kumar verma to All Participants:

st july to 24 sep

from Santhosh Kumar N P to All Participants:

from Ganesh Kadam to All Participants:

jas

from panditpragya to All Participants:

1 july to today

from Anuradha to All Participants:

from Bander Mansor AlQahtani to All Participants:

third

from V.V.S. PADMAPRIYA to All Participants:

q3

from GIJAULHAK ANSARI to All Participants:

from V.V.S. PADMAPRIYA to All Participants:

1juky

from Ganesh Kadam to All Participants:

1 july

from Santhosh Kumar N P to All Participants:

1july

from V.V.S. PADMAPRIYA to All Participants:

1july

from Bander Mansor AlQahtani to All Participants:

7,8,9
from chandansingh6025 to All Participants:

12/4

from Rishabh . to All Participants:

okk

from Chaudhary Tuba to All Participants:

from Anand C P to All Participants:

But Financial Year in India is Q1-Apr-Jun,q2-Jul-Sep,q3 Oct Dec and Q4 Jan-Mar

from Bander Mansor AlQahtani to All Participants:

1 jan - 20 aug

from Dhanalaxmi Pawar to All Participants:

1 jan to 20aug

from Gaurav kumar verma to All Participants:

01 jan to 20 aug

from Rishabh . to All Participants:

1jan 2017 to 20 aug 2017

from Bander Mansor AlQahtani to All Participants:

2017

from panditpragya to All Participants:

1 jan to 20 aug

from gautamakankshan@gmail.com to All Participants:

1jan2017 till 20aug

from GIJAULHAK ANSARI to All Participants:

yes

from Anuradha to All Participants:

jan 2017 till aug 20 2017

from Gaurav kumar verma to All Participants:

01aug to 20 aug

from panditpragya to All Participants:

1 aug to 20 aug

from Mahaveer Singh to All Participants:

1 JAN 2017 TO 20 AUG 2017

from gautamakankshan@gmail.com to All Participants:

1aug2017

from Bander Mansor AlQahtani to All Participants:

1 - aug -2017 to 20 aug 2017

from Gaurav kumar verma to All Participants:

01 july to 20 aug

from gautamakankshan@gmail.com to All Participants:

1july2017 til 20aug

from panditpragya to All Participants:

1 uly to 20 aug

from Rishabh . to All Participants:

july aug sept

from Bander Mansor AlQahtani to All Participants:

1 july - 20 aug

from panditpragya to All Participants:

no

from GIJAULHAK ANSARI to All Participants:

no

from Bander Mansor AlQahtani to All Participants:

no thanks

from Mahaveer Singh to All Participants:

NO

from Gaurav kumar verma to All Participants:

no

from Ganesh Kadam to All Participants:

here year type needs to be considered

from Ganesh Kadam to All Participants:

financial year or calender year

from Peeyush (Faculty) to All Attendees:

DATETRUNC('month', [Order Date])

from BIMOSH SAHOO to All Participants:

SHOW THE CAL ONCE AGAIN

from Shreya Badkelwar to All Participants:

done

from Gaurav kumar verma to All Participants:

done

from tusharrobin to All Attendees:

done

from Ganesh Kadam to All Participants:

Done

from Anuradha to All Participants:

done

from GIJAULHAK ANSARI to All Participants:

dn

from Mohammad Sohail to All Participants:

DATETRUNC('year',[Order Date])

from Anuradha to All Participants:

DATETRUNC('year', [Order Date])

from Peeyush (Faculty) to All Attendees:

datetrunc('year', [Order Date])

from tusharrobin to All Attendees:

done

from Ganesh Kadam to All Participants:

How we can do this for finanacial year

from Chaudhary Tuba to All Participants:

done

from Ganesh Kadam to All Participants:

done

from Mohammad Sohail to All Participants:

DATETRUNC('quarter',[Order Date])

from Peeyush (Faculty) to All Attendees:

datetrunc('quarter', [Order Date])

from Shreya Badkelwar to All Participants:

yes

from Gaurav kumar verma to All Participants:

done

from Chaudhary Tuba to All Participants:

from akhilraparthi1996 to All Participants:

i am getting 2014 data in datetrunc

from akhilraparthi1996 to All Participants:

not 2015 data

from Ganesh Kadam to All Participants:

yes

from Bander Mansor AlQahtani to All Participants:

clear

from akhilraparthi1996 to All Participants:

DATETRUNC('year',[Order Date])

from akhilraparthi1996 to All Participants:

2014 data

from Richa Tiwari to All Participants:

DATETRUNC("month", [Order Date])

from Richa Tiwari to All Participants:

please repeat

from akhilraparthi1996 to All Participants:

only 2014 data

from akhilraparthi1996 to All Participants:

ok

from Ashish Kumar Mandal to All Participants:

explain fiscal year once again

from Richa Tiwari to All Participants:

ok
from Ashish Kumar Mandal to All Participants:

ok

from chandansingh6025 to All Participants:

TODAYS DAY

from akhilraparthi1996 to All Participants:

from akhilraparthi1996 to All Participants:

got it

from Peeyush (Faculty) to All Attendees:

TODAY()3

from Shreya Badkelwar to All Participants:

yes

from tusharrobin to All Attendees:

done sir

from Rishabh . to All Participants:

23

from Ashish Kariwdekar to All Participants:

I am not able to get the details for fiscal year in the tab

from GIJAULHAK ANSARI to All Participants:

please repeate this section

from Ganesh Kadam to All Participants:

no

from Shreya Badkelwar to All Participants:

no

from Karthikeyan Ramasamy to All Participants:

i am geting ABC

from Ganesh Kadam to All Participants:

i am getting discrete for todya

from Pradeep Singh to All Participants:

yes

from chandansingh6025 to All Participants:

I AM GETTING ABC AS WELL

from Bander Mansor AlQahtani to All Participants:

yes

from Shreya Badkelwar to All Participants:

yes

from Rishabh . to All Participants:

yes

from Rohit Singh to All Participants:

ur tsking finan year till June

from Ganesh Kadam to All Participants:

calender year

from akhilraparthi1996 to All Participants:

no audip

from Ganesh Kadam to All Participants:

yes

from 1984shashankkumar to All Participants:

yes

from Pradeep Singh to All Participants:

yes

from V.V.S. PADMAPRIYA to All Participants:

1JUNE

from Ruta Narkhede to All Participants:

1st apr

from Ganesh Kadam to All Participants:

1 april

from Pradeep Singh to All Participants:

no

from Ashish Kariwdekar to All Participants:

it goives me year when i put in today in text

from pauldesahagun to All Participants:

would you send that screenshot?

from Ashish Kariwdekar to All Participants:

it goives me year when i put in today in text

from akhilraparthi1996 to All Participants:

today fun pls

from Shreya Badkelwar to All Participants:

now() function usage

from pauldesahagun to All Participants:

for the assignment

from Ashish Kariwdekar to All Participants:

year

from Ashish Kariwdekar to All Participants:

okay, got tht

from Shreya Badkelwar to All Participants:

okay

from akhilraparthi1996 to All Participants:

ok

from Karthikeyan Ramasamy to All Participants:

still i get now fallowed by row ABC!!

from panditpragya to All Participants:

and meands both multiple condition

from panditpragya to All Participants:

or means any condition

from V.V.S. PADMAPRIYA to All Participants:

AND checks for both conditins to be true

from V.V.S. PADMAPRIYA to All Participants:

or any one is true

from Pradeep Singh to All Participants:

done

from Peeyush (Faculty) to All Attendees:

if SUM([Profit]) >0

then 'Profitable'
END

from tusharrobin to All Attendees:

done

from tusharrobin to All Attendees:

null

from Shreya Badkelwar to All Participants:

null

from ABHAY YADAV to All Participants:

null

from Rohit Singh to All Participants:

pls go slow

from Ganesh Kadam to All Participants:

done

from Gaurav kumar verma to All Participants:

done

from pauldesahagun to All Participants:

can you sahre the syntax

from chandansingh6025 to All Participants:

WHY WE USE SUM INSTEAD OF PROFIT

from Peeyush (Faculty) to All Attendees:

if SUM([Profit])>0

then 'Profit'

ELSE

'Loss'

END

from Gaurav kumar verma to All Participants:

done

from KHUSHBOO NAG to All Participants:

Can you show again this if else part

from KHUSHBOO NAG to All Participants:

Thanks
from Shreya Badkelwar to All Participants:

done

from Peeyush (Faculty) to All Attendees:

if SUM([Profit])>0

then 'Blue'

ELSE'Red'

END

from GIJAULHAK ANSARI to All Participants:

color

from Gaurav kumar verma to All Participants:

color

from akhilraparthi1996 to All Participants:

from tusharrobin to All Attendees:

yes

from chandansingh6025 to All Participants:

I WROTE GREEN

from Ganesh Kadam to All Participants:

no

from Gaurav kumar verma to All Participants:

yes

from Divyanshu Gupta to All Participants:

yes

from Ruta Narkhede to All Participants:

yes

from ABHAY YADAV to All Participants:

yes

from Ganesh Kadam to All Participants:

my chart got both colour for all

from Ashish Kariwdekar to All Participants:

Please can you show me the fiscl year again

from Mohammad Sohail to All Participants:

Can anyone share the community link please

from Ganesh Kadam to All Participants:

IF [Profit]>0

THEN 'blue'

ELSE 'red'

END

from Peeyush (Faculty) to All Attendees:

https://public.tableau.com/app/profile/peeyush.jain/viz/24sept2022_16640396886840/LF-Color?
publish=yes

from tusharrobin to All Attendees:

Great!

from Ganesh Kadam to All Participants:

ok

from Anuradha to All Participants:

Fical year is not coming

from chandansingh6025 to All Participants:

HOW TO LOG IN TO OUR PROFILE

from chandansingh6025 to All Participants:

YES

from chandansingh6025 to All Participants:

YES

from pauldesahagun to All Participants:

no

from Anuradha to All Participants:

https://public.tableau.com/app/profile/anuradha.deshpande/viz/Anuradha_16640397515980/
Sheet11?publish=yes

from chandansingh6025 to All Participants:

I SAVE IT DIRECTLY

from Ashish Kariwdekar to All Participants:

Everything shows from Jul to me

from Ashish Kariwdekar to All Participants:

2014 as well

from chandansingh6025 to All Participants:

I DID IT

from chandansingh6025 to All Participants:

I WANT TO SEE THE WORKBOOK ONLINE

from Shreya Badkelwar to All Participants:

will you please share how you added the profit/sales and sum(profit)/sum(sales) formula in sheet 1

from Ganesh Kadam to All Participants:

https://public.tableau.com/app/profile/ganesh8307/viz/GaneshKadam/Sheet12?publish=yes

from Shreya Badkelwar to All Participants:

i missed that part