1 of 1 people found this helpful
I think you could accomplish something like this using a calculated field to determine how you want to scale it. You could probably duplicate the calculation to give you a label.
Test Data 1 Value
IF [testdata1] / 10000 > 1 THEN [testdata1] / 10000
ELSEIF [testdata1] / 1000 > 1 THEN [testdata1] / 1000
Test Data 1 Label
IF [testdata1] / 10000 > 1 THEN "Test Data 1 scaled by 10,000"
ELSEIF [testdata1] / 1000 > 1 THEN "Test Data 1 scaled by 1,000"
Maybe that will spark some ideas. However, I would question whether this is a best practice. Perhaps using a logarithmic axis would be better? http://onlinehelp.tableausoftware.com/current/pro/online/en-us/log_axes.html
http://onlinehelp.tableausoftware.com/current/pro/online/en-us/log_axes.htmlOr maybe showing the values as percents / percent change would be meaningful?
Just a note, those calculations above are just samples to show the logic and are probably not at all what you would really want to use to get your actual scaling.
thank you very much for the quick reply, that's nearly exactly what I'm searching - just the essential part is: How to show the user of my dashboards how much a value has been scaled? Do you have an idea how this can be achieved? I mean having like a little box on the dashboard telling: Value testdata1 has been devided by 1000/100 etc.
It will depend on how you determine the scale factor for each measure. Either way will result in a visualization that you can include in your dashboard:
If you go with a parameter for manual input, you can have a blank visualization and edit the title (or caption) and include the parameter value in the text.
testdata1 has been divided by <Parameter1>
testdata2 has been divided by <Parameter2>
If you use calculated field for automatic determination, you may want to do the calculation in two steps:
1. Determine the scale factor. Create a calculation called testdata1 Scale Factor and use the logic to get the factor (1,000; 10,000; 100,000, etc...). Do that for each testdataX.
2. Create a new view that uses Measure Names / Measure Values to show each one of the values (but watch the aggregation so you aren't summing for each row).