Tag Archives: graphs

Custom Tooltips in Graphs

Hello there!

Today I’m going to show how to change tooltips in graphs.

You just need to:

1. Edit your graph;

2. Go to Series;

pic

3. In “Show Tooltip (Web only)” field choose one of those options below:

{&TOOLTIP} – All values
{&GROUPLABEL} – Attribute’s information.
{&SERIESLABEL} – Metric’s information.
{&VALUE} – Value of the point.
{&XVALUE} – X-value of a point.
{&YVALUE} – Y-value of a point.
{&ZVALUE} – Z-value a point.

Hope it helps!

God bless you!

How to change the default messages for blank rows in grid/graphs

Hello there!

Today I’m going to show you have to change the default blank message: No data returned for this view. This might be because the applied filter excludes all data.

You just have to:

1. Go to Desktop/Developer;

2. Log using Administrator;

3. Right click on the project and go to Project Configuration

pic

4. Go to Report Definition -> Advanced;

5. Fill the text Area with some text. This text is going to be used when you don’t have rows for a grid/graph.

pic

You can also hide the document grid if you want.

Restart your Intelligence Server and Web Server.

That’s it.

Hope it helps!

God bless you!

4.

Color graphs

Hello there!

Today let’s talk about a quick fix while colorizing a graph. When you try to specify the colors of the bars in a horizontal bar graph, for example, it doesn’t change to those selected colors.

Let reproduce to problem.

1- Create a new report with Year and Cost;

pic1

2- Create a document using this report as dataset and create a Vertical Bar Graph;

pic1

3- Change the color mode to “Color by Categories“;

pic1

4- Change the color of the graph to Apex;

pic1

5- Run your document and you will see that your graph didn’t get those selected colors;

pic1

So, to make it works, you have to:

1- Change the color mode to “Color By Series“;

pic1

2- Edit your graph in Desktop/Developer and choose “Set Series by Row“;

pic1

Now when you run your document, you will see that it got the selected colors.

pic1

 

Hope it helps!

 

God bless you!

Hidding data labels in a graph

Hello there!

Today let’s talk about how to display only specific values for data labels in graphs.

Let’s go!

1. Create a new report with Year and Cost using Web:

pic1

2. Switch to graph:

pic1

3. Run your report. Go to Data->Advance Threshold Editor:

pic1

4. Create a new Threshold for Cost using Year = 2010:

pic1

5. Click on Cell formatting… (pic1)button. Format the number to Custom and use this value:

“[>0] ”

You have to type a space after the square brackets and remove the double “. So, if must be something like this

[>0]            <- Remove to type 1 space after everything

pic1

6. Apply the threshold. Now you won’t see the data label for 2010.

pic1

That’s it.

Hope it helps!

 

God bless you!

Changing the default formatting for Graphs

Hi there!

Today let’s talk about changing the default formatting of your graphs!

Everybody knows that is almost impossible to use the default formatting of MicroStrategy Graph. You always have to change the colors, fonts, sizes, number format, and so on. So, if you use 5 times the horizontal bar graph, you have to format it 5 times… That is so boring…

What if you edit it once and everytime that you insert a new horizontal graph, for example, you get that specific formatting? Wouldn’t that be nice? In fact, it can be done and it is very easy to implement.

To do that, you have to:

1. Edit the formatting of your graph in Desktop/Developer and apply your format to it.

Here I’m going to change the Horizontal Bar graph formatting.

pic1

2. While editing, go to Graph -> Save Graph Style and name it as: HorizontalBar.

pic2

3. Go to the folder: C:\Program Files\Common Files\MicroStrategy\GraphStyles or C:\Program Files (x86)\Common Files\MicroStrategy\GraphStyles, make a backup of the HorizontalBar.3tf file that is inside that folder, and substitute it with the new file that you have just saved.

pic3

pic3

 

4. Thats it!!

The next time that you use the Horizontal Bar graph, you will get your new cool and well done formatting.

You can also create a folder with all edited graphs and just apply the styles to your graphs manually. You just have to edit your graph, go to Graph -> Apply Graph Style and look for your .3tf file that you have created.

pic3

I hope it helps.

God bless you.