How can we merge two metrics in microstrategy?

+1 vote

I have created those line charts in MicroStrategy 10 visual insights , but I want them to look as a merged chart. How to do so?

May 30, 2018 in MicroStrategy by Daisy
• 8,020 points

recategorized May 30, 2018 by Daisy 116 views

2 answers to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

You can probably do the following:

I got the result by using the combo chart from the visualization gallery. Also make sure that the metrics are in different axes like left and right axes.
Drag and drop the metrics name into the Color By box to give different colors to those metrics.

answered May 30, 2018 by sophia
• 1,400 points
0 votes

So far we saw reporting with one source of data as the source. But we can also add more than one data source to the same report. In such a case, we can use the attributes and metrics from both the sources in creating the visualization. The result appears as if we are dealing with one source of data. This happens because MicroStrategy combines both these sources and internally treats them as one.

Following are the steps to combine two source data sets and create a visualization.

Step 1:

Create a report with one source of data. We will use All_sales.xlsx in the example. Next, click the New Data menu as shown in the following screenshot.

Step 2:

Now you can see both the data sources available under the Dashboard. The attributes and metrics of both of these sources are available under their respective names. 

Step 3:

Next, drag the attribute “Business Line” from All_sales.xlsx to the rows box. Drag the attributes “customer segment” and “Product Category” from the second data set to the rows box in Microstrategy application online. The grid visualization appears showing data from both the data sets.

Thanks 

Suresh Prabhu

answered Feb 8 by Suresh
• 700 points

Related Questions In MicroStrategy

0 votes
1 answer

How to change the title of the graph in microstratey?

In Microstrategy desktop you can edit a ...READ MORE

answered May 30, 2018 in MicroStrategy by Daisy
• 8,020 points
35 views
0 votes
1 answer

What sholud be the practise for good MicroStrategy workflow

To be precise you can: Use Object Manager ...READ MORE

answered Jun 26, 2018 in MicroStrategy by scarlett
• 1,280 points
29 views
+13 votes
2 answers
0 votes
1 answer
0 votes
1 answer

How can we take screenshots of tests in Selenium 2 using C#

We can take screenshots using below function ...READ MORE

answered Mar 23, 2018 in Selenium by nsv999
• 5,030 points
108 views
0 votes
1 answer

How can I compare the content of two files in Python?

Assuming that your file unique.txt just contains ...READ MORE

answered Apr 16, 2018 in Python by charlie_brown
• 7,710 points
33 views
0 votes
1 answer

How can I iterate through two lists in Parallel

You have to use the zip function ...READ MORE

answered Apr 17, 2018 in Python by anonymous
39 views
+2 votes
1 answer

How can we handle authentication popup in Selenium WebDriver using Java

The Alert Method, authenticateUsing() lets us skip ...READ MORE

answered Apr 18, 2018 in Selenium by king_kenny
• 3,590 points
2,854 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.