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
Thanks,
Joel
Hey Joel,
I'm not following the requirements 100%, but I think that the following will help:
You can override filters with LoD calculations. They allow you to specify the grain of your data.
Here is some more information on them: Overview: Level of Detail Expressions
If you need to filter inside of a calculation, you can do that inside of the aggregation functions, for example:
SUM(IF [MyField] = 'A' THEN [MyValue] END)
Hope this helps!
- Derrick