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,050 points

recategorized May 30, 2018 by Daisy 462 views

2 answers to this question.

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.


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,050 points
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
+13 votes
2 answers

Git management technique when there are multiple customers and need multiple customization?

Consider this - In 'extended' Git-Flow, (Git-Multi-Flow, ...READ MORE

answered Mar 26, 2018 in DevOps & Agile by DragonLord999
• 8,380 points
0 votes
1 answer
0 votes
2 answers
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,720 points
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
+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,650 points