WeeklyAlteryxTips#75 Show the total at the center of the pie chart by Overlay tool

Alteryx

This blog series is a weekly AlteryxTips blog that will provide you with Alteryx tips every week.

I would like to explain how to show the total label at the center of the pie chart by a different approach than last time.

The reporting snipets are able to be ovelayed by the Overlay tool

Normally, the Overlay tool is useful to overlay some reporting snipets. In the past, I explained how to ovelay the legend to wasted map margin in this blog.

In this post, I would like to explain the same way to overlay the total label.

Create a text to overlay

This is quite easy. Summarize by the Summarize tool and create a text by the Report Text tool. The Report Text tool’s setting is as follows.

[Sum_sales:0] is inserted by “Available Fields”. This makes as follows.

The failure way

First, create a pie chart.

Next, the reporting text is appended to the pie chart by the Field Append tool. And then, use the Overlay too. The workflow is as follows.

The Overlay tool’s setting should be as follows.

Base Field is “Chart” which is created by the Interactive Chart tool. This field is the “Base” layer because it is placed at the bottom. And to place the reporting snipet(text) at the top of the report, the “Text” field is set to the “Overlay Fields”. This made as follows.

This is not a desired outcome.

Improved version

The correct way is to place the Layout tool after the Interactive Chart tool. The correct workflow is as follows.

The important point is the setting of the Layout tool, which is “Layout Width” and “Layout Height”. To fix the pie chart size, you have to set this value correctly. The value “Fixed” should be set here, NOT “Percentage” or “Automatic”.

The size should be set to what you like.

Next, at the Overlay too, set the “Base Field” to “Layout” which you create at the Layout tool.

Congratulatins! The pie chart with the total label is completed!

Conclusion

  • I have explained to place the total label by the Overlay tool at the center of the pie chart.
  • The Layout tool should be set after the Interactive Chart tool.
  • This way is easier than the last week’s tips.

Sample workflow download

The next blog post is…

The next blog is how to create the workflow quickly.

コメント

Copied title and URL