Creating Sparklines

-

 

Creating Sparklines

The example uses the Superstore sample to create a sparkline that shows sales and profit for various product categories over a long period.

Create the View

1.       From the Dimensions pane, drag Order Date to the Columns shelf

1.      On the Columns shelf, right-click Order Date and select the second instance of Day
Alternatively, if you want to view the profits over four years on a continuous axis, select the second instance of Month.

2.       From the Dimensions pane, drag Category and Segment to the Rows shelf

3.       From the Measures pane, drag Sales to the Rows shelf

4.       On the Columns shelf, right-click Month and uncheck Show Header

5.       On the Rows shelf, right-click Sales and uncheck Show Header

Optional: Add a Text Column for a Measure

1.       Select Analysis > Create Calculated Field

2.       In the Calculated Field dialog box that opens, do the following, and then click OK:

1.       Name the calculated field. In this example, the calculated field is named "Profit per Category per Segment"

2.       In the formula field, create a calculation similar to the following:

3.       { EXCLUDE DATETRUNC('day', [Order Date]), [Segment] : SUM([Profit]) }

3.       Right-click Profit per Category per Segment in the data pane, and select Convert to Discrete

4.       Drag Profit per Category per Segment to the Rows shelf

Comments

Post a Comment

Popular posts from this blog

String Functions in C Language(C Language)

-
  C String Functions There are many important string functions defined in "string.h" library. No. Function Description 1) strlen(string_name) returns the length of string name. 2) strcpy(destination, source) copies the contents of source string to destination string. 3) strcat(first_string, second_string) concats or joins first string with second string. The result of the string is stored in first string. 4) strcmp(first_string, second_string) compares the first string with second string. If both strings are same, it returns 0. 5) strrev(string) returns reverse string. 6) strlwr(string) returns string characters in lowercase. 7) strupr(string) returns string characters in uppercase. 8) strstr( st...
Read more

PHP Array Functions

-
  PHP  Array  Functions The array functions allow you to access and manipulate arrays. Simple and multi-dimensional arrays are supported. Function Description array() Creates an array array_column() Returns the values from a single column in the input array array_combine() Creates an array by using the elements from one "keys" array and one "values" array array_flip() Flips/Exchanges all keys with their associated values in an array array_pop() Deletes the last element of an array array_push() Inserts one or more elements to the end of an array array_replace() Replaces the values of the first array with the values from following arrays array_reverse() Returns an array in the reverse order array_search() Searches an array for a given value ...
Read more

Home Menu Options in Ms Word

-
Image
Microsoft Word Ribbon The following are the different options and tools listed in the Microsoft Word Ribbon for each of the tabs. Each section below is outlined first by the tab name, then by each section on the tab. Home tab                                    Undo Undo Typing  - Removes the last thing you typed. Repeat Typing  - If you accidentally hit undo typing, you can re-enter the previous text.                                      Clipboard Paste  - Pastes information from the  clipboard . Cut  - Removes information from the document and puts it in the clipboard. Copy  - Copies information from the document for the clipboard. Format Painter  - Applies formatting from another section of a docume...
Read more