How can we merge two metrics in microstrategy

+2 votes

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

recategorized May 30, 2018 by Daisy 3,815 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, 2019 by Suresh
• 720 points

Related Questions In MicroStrategy

+1 vote
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,120 points
0 votes
1 answer

how can i start using micro services as a fullstack beginner??

Hello @ aminegac , For your query you can refer ...READ MORE

answered Dec 4, 2020 in MicroStrategy by Niroj
• 82,880 points
+1 vote
2 answers

What sholud be the practise for good MicroStrategy workflow

Hii , MicroStrategy development in a team environment, ...READ MORE

answered Jul 13, 2020 in MicroStrategy by anonymous
• 340 points
+15 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 27, 2018 in DevOps & Agile by DragonLord999
• 8,450 points
+2 votes
1 answer
0 votes
2 answers

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

Hey, try using following code command to ...READ MORE

answered Aug 23, 2019 in Selenium by Abha
• 28,140 points
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
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP