#Of0 discussing

Data looks like this

Order No.     |     Complete     |     Completed Time

123                    1                             Jan 5, 1:25pm

234                    0                              NULL

345                    1                              Jan 5 2:30

456                    0                              NULL

The graph I want to create is the total number of completed orders each hour as a percentage of the total number of orders for the day.  I have the completed items counted for the hour they are completed, but I can't figure out how to graph the data as a trend line moving to 100%

Thanks,

Adam.

Hi All,

I am trying to build a waterfall chart based on value present in certain columns. My data looks something like this.

I want to create a waterfall chart to show that we are considering only those records which have US as the country and a non-null DMA for modeling purpose. I am trying to build a waterfall chart to show this.

Based on the above data it should be like this:

I am attaching the dummy excel in case you need to play around.

Thanks,

Tejal Narkar

Hi,

I'm trying to see if there is a calculated field or something that can help me resolve a problem. The below image is just a cross tab of some data I have in a workbook, what I am trying to do is come up with some dummy field or calculation that says if ALL Source values = ALL CSS values then PASS, else FAIL for an individual Unique ID. I am trying to roll up the "Pass" or "Fail" indicator at the Unique ID level, not the individual record level.  For example, for both of the Unique ID's below these would FAIL because they have at least 1 record that fails.

I am working off of Tableau 9.1, and can attach a sample workbook if necessary.

Thanks!

Morgan

Hi guys,

I have an issue with my formula here.

My goal is to show the CUMULATIVE cases, not THE CASES in that period

Let's say that I'm choosing Oct 10/13/22 to 10/17/22, I also want to see the cases before that. Here's the example of my logic:

I hope someone can help with this. I appreciate your time so much! Thank you!

Question: - In the below snapshot, there is a column called business day which shows #of working days(excluding Sat and Sun).

                  1. want this business days to be fixed whether I select single employee or multiple employees. (Business days as per months)

                  2. When I select individual days from days filter, then business days should be as per the dates selected.

                  3. whenever a month is completed, show complete business days for that month.

Could anyone in this forum assist me in getting this issue resolved?

Thanks

Ashwini

Hello,

I'd like to be able to use the bottom Category/Sub-Category/ProductName charts to filter # Order Id in the middle chart while keeping the # State unaffected.  At the same time, I'd like the Ship Mode Filter on the right to continue working.

The top "Verify # State" chart is there to just eyeball that it's working  correctly.

I've tried various LODs and using the LOOKUP(ATTR([dimension]), 0) filter replacement to no avail.

Many Thanks!,

Alex

Hello All ,

I have just started working in tableau for 6 months. I want to plot a line graph between Order Date(Continuous) and #Of Bookings. Order Date is in Second granularity.

In the line graph I am not able to show the seconds for which there are no bookings. Ideally for those order date #of Bookings should be shown as zero. (Graph Sheet)

But in the tabular form I am able to see #of Bookings as 0 by clicking "Show Missing Values"(Table Sheet).

Please let me know if this is possible to show the missing dates record in a line graph with some default value(In this case 0 Bookings) .

Hello All,

I'm a Tableau newbie. Trying to understand the LOD expressions. For most part I believe I understand how the LOD work and how the results are reconciled with View level of detail.

What is creating the biggest confusion is, for example the difference between the two expressions below and when to use these:

1) AVG({FIXED Category: SUM(Sales)})

As I understand: For each Category, find the sum of sales and then average them

and

2) {FIXED Category: AVG(Sales)}

As I understand: For each Category, find the Average Sales

They return different results. 1) is average sales by category 2) average sales when computed dividing by #of records.

Question: When do I use 1 or 2? What practical use cases are there that I can determine which one to use.

Thanks

Anu