How to check data for accuracy in report

[littlepatos]

I have created a report using free healthcare data but am not confident in the outcome- it's showing that all states spend the exact amount of $ on the same type of healthcare and I don't think this would be accurate. Any suggestions please?

https://drive.google.com/file/d/1uU_wb3M5oPlQGCe8EtPe4avJpAnRuNAN/view?usp=sharing

https://drive.google.com/file/d/10d_4hHdTp0WHlIlnp5YI4A8Atf-hUiBb/view?usp=sharing

[vanessafvg · Accepted solution]

I am not sure you are using the correct measure, you have a count of the states placed on your x-axis 

i replaced that with the real expenditure changing the aggregation to a sum and this is what i get - if this is what you are expecting change your measure, see your file attached.  

[littlepatos]

Thanks @vanessafvg - much appreciated! 

[littlepatos]

ooops sorry.... @vanessafvg 

https://drive.google.com/file/d/1uU_wb3M5oPlQGCe8EtPe4avJpAnRuNAN/view?usp=sharing  

https://drive.google.com/file/d/10d_4hHdTp0WHlIlnp5YI4A8Atf-hUiBb/view?usp=sharing

[vanessafvg]

you need to give access to the data.

first off i would say make the visual a matrix to check the values explictily if you want to test.  once you happy change to the viz above