Tableau - What would the LOD calculation be

0 votes

I'm new to Stack Overflow, but I'm hoping to obtain a response to one of my project questions.

City       Sales   Sales (LOD calculation) 
Mumbai      150           50
Bangalore    90           0 
Kolkata     130          -10

What would be the LOD calculation to get 0, 50, and 100 in the Sales column (LOD calculation only)?

Rows 2 and 3 are both deducted from the first row, as far as I understand. It's simple to implement with Table Calculation, but I'm stumped on the LOD component.

Mar 3, 2022 in Tableau by Neha
• 9,060 points
420 views

1 answer to this question.

0 votes
Based on your requirements, I don't feel a LOD expression would be appropriate. You said that you can already achieve your findings using table calculations, which is the correct way for this situation.

When you need to execute some aggregation of your data that is at a different granularity than the specified dimensions, LOD expressions are employed.

I hope this information is useful.
answered Mar 3, 2022 by Vaani
• 7,020 points

Related Questions In Tableau

0 votes
1 answer

What are the important question for a Tableau Interview?

Here is a link to the blog ...READ MORE

answered Apr 25, 2018 in Tableau by ffdfd
• 5,550 points
822 views
0 votes
1 answer

What are the prerequisites to learn Tableau software?

As such there is no prerequisite or ...READ MORE

answered Apr 27, 2018 in Tableau by Atul
• 10,240 points
2,424 views
0 votes
1 answer

What are the disadvantages of Tableau?

1. Planning or notice of reports: Scene ...READ MORE

answered May 8, 2018 in Tableau by Abhishek Patel
1,533 views
0 votes
1 answer

What are the prerequisites to learn tableau

Well, there is no as such mandatory ...READ MORE

answered May 16, 2018 in Tableau by DragonLord999
• 8,450 points
1,495 views
0 votes
1 answer

How can I calculate the median of sales price using 3 variables in Tableau

First let me clarify things for you. ...READ MORE

answered Apr 12, 2018 in Tableau by xyz
• 1,560 points
6,619 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,020 points
323 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,020 points
336 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28, 2022 in Tableau by Vaani
• 7,020 points
404 views
0 votes
1 answer

Tableau - Conditions on LOD Expression

You can use LODing on both uid ...READ MORE

answered Mar 16, 2022 in Tableau by Vaani
• 7,020 points
1,748 views
0 votes
1 answer

combine two data sets in tableau so that I can show a forecast for the next 3 months

I believe the best approach is to ...READ MORE

answered Apr 5, 2022 in Tableau by Vaani
• 7,020 points
613 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP