7 Replies Latest reply on Feb 16, 2017 6:20 AM by Jim Dehner

What level of detail to show?

Hey all,

This exercise is nothing new here but I have a different question.

How does Tableau know we are asking it to count and show us the days indeed? Is it because there is no lower level of detail in the Date dimension?

I mean, the LOD only sums the Profit for each order date. How does it know it has to filter exactly by days?

Thanks,

Esther

• 1. Re: What level of detail to show?

Hi Esther

I may be missing your question-

Tableau is summing the Calculated fields you set up for Profitable and Non-Profitable

If you had mad the calculations total profit like >>>

{ FIXED [Order Date] : IF SUM([Profit])<0 THEN sum([Profit]) end }

and if you set the date pill to month vs day

Then the viz would sum the dollar values and would look like this

Yes you are correct - order date in the superstore data only goes to the date level

Does this help?

Jim

3 of 3 people found this helpful
• 2. Re: What level of detail to show?

Hi esther,

look at this video you wil get an idea:How to Calculate the Number of Profitable Days per Month - YouTube

Thanks,

Tharashasank

• 3. Re: What level of detail to show?

Hi Twain,

The LOD expression is calculating based on the Profitability/Non-Profitability on a particular date and returning boolean 1 an 0 and same 1/0 are being Summed up here for specific month and year.

Hope this Helps!!

Thanks,

Dhruv Gupta

2 of 2 people found this helpful
• 4. Re: What level of detail to show?

Ohhh,

So, in the LOD expression { FIXED [Order Date] : IF SUM([Profit])>0 THEN 1 end } Tableau is grabbing all those ones (1) and summing them up?

What a major revelation this is to me

Thanks, Jim Dehner !

1 of 1 people found this helpful
• 5. Re: What level of detail to show?

Oh, sorry Dhruv Gupta, I didn't see your answer!!

That's exactly what I thought!

Thank you

• 6. Re: What level of detail to show?

Hi Twain,

I think the LOD aggregation at the marks card SUM(Profitable) and SUM(Non Profitable) is summing all those 1's. Dhruv has already highlighted that part in the attached image.

Regards,

Abhi

2 of 2 people found this helpful
• 7. Re: What level of detail to show?

Thanks Esther -

Glad to be of help - if you get a chance please mark the original respose as helpful

Jim