I have two data label objects on a dashboard that are each displaying the Standard Formula Totals results from two separate columns from the same dataset. I want to divide DataLabel1 results by DataLabel2 results. For example, I want to divide $1,000,000 by 25 and display the results ($40,000) in a separate data label. How would you go about accomplishing this?
Dividing two formula results
Since you already have 2 data labels on the dashboard, you can just use a Formula Visualization to divide DataLabel1 by DataLabel2.
The formula bar will open after you click on the Formula Visualization where you can click on the existing data labels and write your formula:
This will create a new visualization (the default view is a table which you can easily re-visualize to be a new data label. If you do re-visualize to a data label, you can go to the visualization tab under the data analysis panel and make sure only the new calculated measure shows up under the text section).