need answers to the below

[sonysree88]

Please provide the exact answer to the provided questions which are in the image files.

 1)Please let me know the expression or a query to find the number of spaces in the string 'S1 S2 S3S4 '

2)preffered visualization to be based when you were asked show% change in product sales of current year vs prev year

3)PFB screesnshot

Result:

Please send one 1 QVW along with answers to these questions

[pradosh_thakur]

1:
substringcount('S1 S2 S3S4 ',' ')

[pradosh_thakur]

You can use different chart. If you need to show just the percent change you can use a bar chart .

[marcus_malinow]

So you have an interview right?

Maybe the hiring manager would like someone who answers the questions given to them rather than outsourcing.

Show some initiative and do the work yourself

[sonysree88]

HI Pradosh,

Thanks for your reply.

Could you please provide the answer to the attached screenshots as well.

Regards,

Sonysree