that probably has to do with the Table Calculation
Do you have a sample workbook you can share?
If we use the calc as
this will give % in both category, if we select one category only then this will show 100%.
Please attach workbook.
Not sure if I understood your question, but I will try to answer.
If you try to use a table calculation formula in a calculated field you need to use aggregate fields. Therefore your formula should look like:
( sum([Volume]) / WINDOW_SUM(sum([Volume])) )*100
If you just want a % of total based on some measure, I suggest you just do that directly on the table: pick a value from the column showing the absolute values, then select Analysis -> Percentage of -> Column. The absolute values will become relative values (percentages)
If you want to keep the absolute value and add an additional column with the percentage, then you could duplicate the measure, add both to the table, and make one of these columns become your "percentage of" column.
Hope this helps.
For Niko.twbx 33.0 KB
Yes, it does that.
But when filtering with dimensions like Store or Substore, it does not show correctly the data.
Unless I put the dimensions Store and Substore to for example Tooltip shelf.
I can't attach workbook from this, it is NDA-under work :/
Thank you for your input
This is really odd.. I think Tableau populates the data really strange way for some reason on my workbook.
I use certain dimensions to filter data and I have to add some dimensions and metrics to tooltip shelf to make the chart to work. For some reason when I select some dimension from quickfilter, it shows Null value and then with two value it shows the right values..
And sometimes I select any values and it works correctly, but when I select (All) again, it shows only Null.
How is this possible? Do I have too many rows of data or something?
How does the Tableau data population work with quickfilters.. And the quickfilters also filter eachother.
Thank you for the links, but it is too risky to upload outside of the organization. Sensitive data and so on ..
Do not get desperate with your issue. Filters are very powerful and flexible tools and it is easy to have something wrong.
In this community there are hundreds of people willing to help you. I am one of them.
But you need to give us that chance. I understand the sensitivity of your data but I suggest you try to reproduce the odd behavior with test data.
Sometimes, when you work out a simplified test trying to isolate the issue, you see the answer to your question without needing further assistance.
In the mean time, I do not believe volume of records is an issue for Tableau. It is designed to work with very large number of records.
Filters may affect one another. Maybe this will help in your case:
I look forward to here from you.
Thank you for your answer, I will take a look on that article that you linked
I think I have read that earlier, but maybe it could be good to refresh my memory.
Today I got a following error message when using filters:
Error in parameters for command 'categorical-filter' missing: visual-id-pres-model
After that, it just worked "normally".
I also applied these changes on my filters (The power of 3):
No help yet from that..
Volumes seems to be ok for time to time, but when I change to median, then the numbers does not add up again.
I have o time series, also there, and that is the only chart that works correctly all the time.
I have maybe solved this problem and I think it has something to do with my time filters.. Or not.
Only time will tell (no pun intended).
But now when I want this new solution to work with my pie chart, it is almost impossible.
When I filter the last values via Time, then I of course get two time values. The C has only occured on time period C.
But if i but the A\B\C dimension to columns, it only shows the last time, in this case 8/15.
And what I would like to see, would only be the 8/15 but without that dimension on columns shelf, 'cause it causes the piechart to go in dimension pies A and B. After that there is only two 100% pies.