For a dashboard I have created I have a tile which is supposed to show the percentage change from previous the previous week for a measure. I have a date column summed up to a week, my measure, and then the calculated field for percent change from previous. I hid the first two columns, leaving just the calculated field left. When I view the viz in an explore it shows the correct value I would expect to see. But the single value viz itself either shows the wrong value or gives me back a null symbol. Any advice as to why this might be happening would be great! If you’d like more context please feel free to comment.
Hi @j_witty ,
If you can share a screenshot containing the Visualization and Data, I might be able to help.
In my experience with Single Value visualizations, organizing your columns is key. Typically the first unhidden column on the left will populate as the single value. Adding an additional column beneath the single value needs to use the Show Comparison option toggled in the visualization dropdown.
If you are trying to get a table calculation as the Single Value, it has to be the only column not hidden and the Show Comparison option must be off.
Again, if you can send a screenshot of what you are seeing, I could help more.
Take care!
Hi @minerkt
Thanks for getting back to me! Below is the screen shot of the value I am expecting to see come through in my Single Value visual. But rather than showing 8% my visual is coming back with 20% and no where in that calculated field does the value 20% show up. (rows are limited to 5 for organization purposes, did a check on max rows). Now i’m wondering if it might have to do with taking this value as a weekly summation.
Any insight would be much appreciated!
Hey @j_witty ,
Thanks for the screenshot. That is interesting that you are getting 20% instead of 8%.
I am wondering a few things here:
Feel free to try either of my ideas and if one works, then great!