I am rather new to this. I am attempting to quantify activity during shift work. I am wanting to list the hours of a shift as hour 1, hour 2, Hour 3 etc. in a simple report that has a quantity of tickets worked.
The Timestamps of 25_01_01 06:00:00 to 25_01_01 07:00:00 would be listed as hour 1.
Comparing current month vs previous month spend, keeping items consistent despite category changes
I have a dashboard showing spend broken down by Category, Item, and Date. I want to compare the total spend for all items under each category for the current month against the total spend for those same items in the previous month.
The catch is that some items might have been under a different category last month. I still want to include their spend in the comparison, even if they switched categories.
Essentially, I need to:
Sum the spend for all items currently under a category for this month.
Compare that total to the spend of those same items from last month, regardless of their category last month.
How can I achieve this? Any help with calculations or approach would be appreciated.
How to create the calculated fields? I have tried FIXED, MAX and etc and all failed.
Objective:
I would like to have all items in a Sales Order to be included only if every single associated material is startwith "EXP."
If even one material in the Sales Order Item is not start with "EXP," the entire Sales Order should be excluded.
To achieve this, we need to make sure that the calculation accounts for whether every material in the same Sales Order is startwith "EXP" and only includes the Sales Order when all materials are startwith "EXP."
I have a dashboard where the user can select a year via the bar chart (using the bar chart as a filter). The selected year's store count is shown and I want to derive the previous year's store count so I can use it in a calculation for the YoY difference (so for example: Store Count: 287 ▲14 stores from prior year)
I've tried:
COUNTD(if [Transaction Date]=DATEADD('year',-1,[Transaction Date]) then [Store ID] end)
But it returns 0. I found elsewhere that using a filter means the previous years aren't available, so could be one reason it's not working. I would prefer not to use a self-join solution because the real dataset (this is an example I made for this question) has a lot of relationships, could get messy.
current start date and previous end date difference
I have 3 columns, start dt, end dt and event type for each vehicle. In a day there are several maintenance events happened at different times of the day, and i want to calculate the gap between each event and call it available.
and then make 2 sheets , Morning hours(8am-8pm) and Night Hours(8pm-8am(next day))
where i show all vehicles on columns and hours on y-axis/rows. With this i can show all the available hours and trip hours on stacked bar.
The image below is for 24 hrs of a day and each stacked bar represents total available hrs(green) and total driven hrs (blue), which will allow me to see how i have utilized out of my available hours. and i want this to split it in 2 sheets.
actually in the data i have available event but they have given 12:00:00 am as start and end dt. you can see that in 1 st image attached. i want calculate total availability from maintenance events.
Let know if you need additional information. Please help me as I'm getting confused with the calculations.
I am back with the rank question revised to mimic my dataset as much as I can. I would like to be able to produce a single line chart per rank (by distinct count) of a category within a T/F parameterised date window. In the attached workbook, I have set it up so that
01Jan - 31Mar2024
Blue is Rank 1
Green is rank 3
Red is rank 2
01Apr - 01Sep2024
Blue is rank 2
Green is rank 3
Red is rank 1
Using these DateFrom and DateTo as an example, how would I set up a calculation to create a rank I can filter on so that the "Line Rank 1" would only show Blue when the dates are 01Jan-31Mar2024, "Line Rank 2" would only show Red etc? Then, when switching to 01Apr-01Sep2024, "Line Rank 1" would show Red, "Line Rank 2" would show Blue etc.
From there, I should be able to write a calculation for the chart title (naming the category) and the axis fixer, but I cannot figure out how to calculate the rank within the time window. MY actual data does also have a "location" filter under the DateFilter, so I have added that as a dummy field for now just so it can be built in.
I've done my best to create a normal distribution chart in Tableau and would appreciate your feedback. I'd like to incorporate shading for 1, 2, and 3 standard deviations but could use some guidance on how to achieve this. Please refer to the attached picture for reference.
Remove Floating Object from View based on Calculated Field
I want to have a floating overlay image at the top of my dashboard if a user has not chosen a value for a drop down. Is there a way to make the floating on top of the underlying dashboard disappear from the view? Tried to do it with Dynamic Zone Visibility, but because it is using a field that has a calculation on it, it won't accept the calculated field created as a way to determine whether to hide it or not. Any help on this is appreciated. Thanks!
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.