CODEWITHSUNDEEP
tableau-api
Todd
Todd

Reputation: 692

Tableau: How to divide two table calculations?

I have these calculated measures which I use within a tool tip as table calculations

[alert_count_by_action] = total([distinct_alerts]) compute using day
[alert_count_all] = total(distinct alerts]) compute using table across

When I mouse over an action name colored widget type I can see that the [alert_count_by_action] and [alert_count_all] are producing the correct values. What I would like to do is to compute a percent by dividing [alert_count_by_action] / [alert_count_all] which I will call [alerts_by_action_percent_overall]. This is not working at all despite trying every combination available on the table calculation options within the Marks card.

What am I doing wrong?

stacked bar chart of alerts by action

Upvotes: 0

Views: 3085

Answers (1)

Dimitri B
Dimitri B

Reputation: 164

Without the attached workbook, I can only suggest to check the partitioning of your % calculation. Because both components of the fraction are themselves table calculations, they can be partitioned separately (i.e. "compute using" options). There should be a combo-box in the 'Edit table calculation' dialog that selects which component is being configured. Maybe you have configured one part, but not other?

Upvotes: 1

Related Questions