In my data I have two data types - Count and Percent

In the bullet graph in the viz below I am filtering on Percent. I created a calc field to show the value which is

[County Data]

Now the client would like to see the Count data in the same graph, as a column before the Value column.

Is there a way to create a new calculated field that would override the Percent filter and show the Count instead.

Here is the link to the viz. I tried Inserting it, but it showed a previous version of the viz

| Tableau Public

Thanks,

Joel