in Technology by

Design a view in a map such that if a user selects any state, the profit and sales in the cities under that state would show up.

1 Answer

0 votes
by

If we want to show the sales and profit of each and every city under the states in the same worksheet, first, we should have State, City, Sales, and Profit fields in our dataset.

  1. Double-click on the State field
  2. Drag City and drop into Marks card (under the State field)
  3. Drag Sales and drop into Size
  4. Drag Profit and drop into Color
  5. Click on Size legend and increase the size (75%)
  6. Right-click on the State field and select Show Quick filter
  7. Select any state and check whether we got the required view or not.
  8. In this, the view size indicates the number of sales and the color indicates the profit values.

Related questions

0 votes
    Suppose, without using a line/bar chart, I want to design a view to show the region-wise profit and sales. How should I go about doing it? Explain...
asked Oct 30, 2020 in Technology by JackTerrance
0 votes
0 votes
    If E1 and E2 are the two events such that P(E1) = 1/4, P(E2) = 1/3 and P(E1 ∪ E2) = 1/ , show that E1 and E2 are independent events. Select the correct answer from above options...
asked Nov 16, 2021 in Education by JackTerrance
0 votes
    A student says that, if you throw a die, it will show up 1 or not 1. Therefore, the probability of ... this correct? Give reasons. Select the correct answer from above options...
asked Nov 21, 2021 in Education by JackTerrance
0 votes
    How Can You Display the Top Five and Bottom Five Sales in the Same View?...
asked Mar 30, 2021 in Technology by JackTerrance
0 votes
    How to display the top five and the last five sales in the same view?...
asked Oct 30, 2020 in Technology by JackTerrance
0 votes
    A system is in a ______ state if there exists a set of transactions such that every transaction in the ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    After reading the chapter, I know these points: I know that data gets highlighted after being selected. I know ... entry and editing. Select the correct answer from above options...
asked Nov 26, 2021 in Education by JackTerrance
0 votes
    If the state of the database no longer reflects a real state of the world that the database is supposed ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    If the state of the database no longer reflects a real state of the world that the database is ... Query Processing in portion Query Processing Techniques of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    Numerical values that describe a trait of the code such as the Lines of Code come under ________. (1)Relative Metrics (2)Absolute Metrics...
asked May 13, 2021 in Technology by JackTerrance
0 votes
0 votes
    If you do not need any facts from the host, what command would you use? 1. gather_facts: no 2. gather_facts: False 3. gather_facts: no AND gather_facts: False 4. gather_facts: y...
asked Jan 27 in Technology by JackTerrance
...