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 in Tableau by Neha
• 8,940 points
171 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 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
620 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,230 points
2,122 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,240 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,204 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
5,968 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 in Tableau by Vaani
• 7,020 points
121 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

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

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

Tableau Map view Continent List

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

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

Tableau - Conditions on LOD Expression

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

answered Mar 16 in Tableau by Vaani
• 7,020 points
574 views
0 votes
1 answer
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