Tableau calculated field
I have data table with the total of health insurance coverage per state for the period of 5 years, so I created a calculated field that calculates the yearly coverage per state by using the divide statement to calculate for that in this way div(health insurance coverage,5) and I titled it Yearly coverage per state and this worked as a measure.
The next step I want to execute for my analysis is to create another calculated field using the Yearly coverage measure to divide the Health insurance coverage to give the coverage rate per state for 5 years. I tried this sum(Yearly coverage per state)/sum(Health insurance coverage), the calculation is valid but when I drag the new field to row section and drag the states field to the column section of my viz, it gives me one figure which is 0.20 for all states and that isnt what I am looking for. I tried it without the sum statement and its the same, tried both fields inside the divide statement and its giving me 0 for all states. I need it to calculate the individual health insurance coverage rate using that formula above. Please help!
here is the situation:your formula seems to be a circular reference. i mean if you perform [Yearly insurance coverage per state]/[Health Insurance Coverage Change 2010-2015] then you are just repeating the same calculation : [Health Insurance Coverage Change 2010-2015]/5, because divide by 5 will result in 20% for all the records. Is there any other formula that you are using , are the fields correct ?
- Calculated field to detail marks of 30+ worksheets
- How to create a calculated field in Tableau for Aggregated and Non-Aggregated Fields
- Live or Extract in Tableau?
- While publishing report with embedded password getting error in Tableau with google spreadsheet as data source
- CountD of employees who were active only during date range specified?
- Table is too long for normal presentation, how do I break it by rows
- Tableau: How can I combine calculated fields from 2 blended data sources in a text table
- How to make dimension filters work, even when they are not present in LOD functions
- Related to clean data either in tableau Or in Alteryx Or in Excel to process report on tableau
- How can I match up rows with columns in Tableau?
- Rounding to three decimals in tableau
- Tableau Calculated field going off
- Getting rolling sum without using a window_function?
- Attempting to clean a string value using regex in tableau desktop designer
- excel to Tableau Aggregation formula conversion
- Tableau: Use one bin for multiple variables in "side-by-side bars" chart/ histogram
- Tableau - have a chart with data which is not included in filter
- How to download specifc rows when using Tableau Desktop?
- Only return job numbers that contain certain suppliers but return all parts in that job number?
- Connecting to Microsoft SQL Server in Python
- hiding part of text or string characters
- How do I create a third column in tableau that calculates the difference between this year and last year for drug purchases?
- What is the best option for a Tableau using custom SQL code that needs to be translated?
- How can I click on a row in one sheet, and goto another sheet?
- How do write a calculated field in tableau to pick the latest record based on column criteria?
- How can I limit the amount of rows returned in my report?
- In Tableau, I have values by year, but I need values by decade. How do I bin or create a group of years to create that?
- Setting tooltip to show specific dates based on the field it hovers over?
- Tableau - Dynamic Reference line that changes based filter selection
- How to inset dummy data in a SQL Server SELECT statement based on table columns