Hi Nicole - Can you share a sample of the dataset? I'm pretty sure you'll have to use Fixed (LOD expression) but difficult to make suggestion without looking at the data structure/granularities.
Ah awesome! Thank you.
But there is still one thing. The grand total changes when i just filter for true or just for false. for exxample for building 5 it would present 61.54 percent instead of 100%. Even if i filter one of them i want to show them how much of these 100% is right and false when i filter them.
Is this also possible to change? That the grand total is always the same (fixed)?
Nichole that is a separate question
Grand totals - total what is in the view -
you are using a table calculation to determine the Total Deliveries
I tried to follow your data but got lost in the detail - but replace the table calc with the LOD
Let me know if this helped
i am sorry. I am a really beginner in tableau and try to improve my skills.
How can i change the table calc with the LOD? I have no idea how to do it.
The thing is the importance is to see how much of the total deliverys were false. Therefore i want to show the percentage of the false one depending on the total view.
I know that the grand total shows always all information/values which are visualized thats the reason why it changes with different filter settings.
Thats the reason why i wanted to ask if there is another opportunity to show the totals, not with grand total, or if you can fix it that it will stay the total.
1 of 1 people found this helpful
Ok First welcome to tableau
if you haven't done so already look at the video training modules on the Tableau site - they are very good - Calculations is a good place to start
as noted earlier - you data is complex and I don't have the time here to go through it -
but below is a superstore example on how to use LOD calculations instead of table calculations to get the percent of each subcategory within catgeory
first determine the total sales in each category as
In words it says 'for each category sum the sales" the way Fixed works is that it makes permutations of the dimension(s) that precede the colon then aggregates that by what follow the colon
Then the percent becomes
and they will return
Hope this helps
Hi Nicole - I have created something like the screenshot below for Checkout time. You can replicate it to create similar view for check ins. Also, you have have the Percentage variable that you can use in different ways to get the view that you need (can use it as different shapes).
I'm on 10.4 so I had to save it as a twb file format and then convert to 10.3 so that you can view it.
Hope it helps!
PS: Please mark it as helpful if it resolves your issue, so that others can benefit from it. Happy Learning!
Percentage calculation.twb 153.7 KB
what does happen when i have further filters??
The total by category depends on the date of the sign in. I want to calculate the total amount of a week? Is this also possible?
Thanks for support!