[14 day sales trend,split by student type][1] I was trying to plot an average line for the sales over the past 14 days. I have used average line in analytics pane for the entire table. And I have made bar chart to stacked bar chart by splitting the sales on each day with old/new student types. The average line was at ~470 when I tried without adding student type to "color" in marks card. The average line moved to 235 when I have added student type to "color" however the tooltip is showing ~470. The granularity level tableau taking is the student type but I need it at the day level. What change should I make to bring back the average line to the correct value i.e., 470 showing the student type details too.?
Tableau desktop average line granularity error
187 Views Asked by Rajkumar Shenigaram At
1
There are 1 best solutions below
Related Questions in AVERAGE
- Moving Average of a variable frequency signal
- Finding average of numbers excluding -1
- How to Sum Values by Column 'Date' After Averaging by Column 'Site'?
- Calculate the average of a filtered list/column with a condition (libre office calc)
- Excel - Aggregating Data in One Column Based on Values in Another Column
- DAX, Calculating Average of a measure within a hierarchy
- I have an array of percentages I want to find the average to
- Can't use double, can't use int, what do I use to stop the rounding? (Java)
- How to calculate an average value based on K-nearest neighbors?
- The average results are calculated differently by the same average measure in the DAX for different time periods
- Averaging Multiple Ranges to ignore 0's and N/As
- Split budget column by total number of months to give average monthly budget
- Pairwise differences between rolling average values for different window widths
- Averaging between several arrays javascript
- How to calculate a daily sales average based off the working days in a month
Related Questions in STACKED-CHART
- In R, how to place error bars at each bar which is stacked?
- Sharing multiple ggplot legend symbols with one label
- Find time spent in each state using DAX
- GGplot - Stacked Bar Chart
- space between groups on stacked grouped barchart
- Display SQL Query result in Stacked Bar Chart with C# and WinForms
- Creating a stacked bar chart in R
- Power BI, ranking Stack Column Chart based on highest y-axis value (Qty) per x-axis (Day)
- Updating data labels using Value from Cells Option
- Google Sheets not plotting (stacked column chart) all my series data
- chartjs: automatic data sorting
- chartjs: unable to create Stacked Chart
- Highcharts sorted stacked columns : position of labels
- How to make a 100% Stacekd chart with multiple columns?
- How to adjust error bars position in matplotlib stacked bar plot?
Related Questions in TREND
- Is there an algorithm to identify the increasing Period/Interval of a time series?
- how do i use Latent Dirichlet Allocation with python for my dissertation topic on Trend Analysis of IoT vulnerability
- How to get Anti-Malware events from Trend Micro Cloud One API
- Linear Trend of NDVI time series
- R: Color scatterplot using a variable from a different data frame
- Trend calculation using snowflake sql
- decompose timeseries including NAs
- Getting a Nan ouput from KendalTau method for detecting trend in monthly based sales
- Require monotonic trend of variables by iterating over rows in dataframe
- Time-series trend analysis in python
- Hodrick and Prescott (HP) filter in R
- Error in filter(x, PHETAS[[i]], sides = 1) : missing values in 'filter' using Sieve Bootstrap Based Test with Mann-Kendall for Trend Analysis
- Trends spatial map in R
- What Can Prevent Time-Series Prediction Model From Learning Trend?
- Auto Correlation in Time Series
Related Questions in TABLEAU-DESKTOP
- Tableau Calculation Based on Filter
- Need to replicate this Bar plot in Tableau
- Importing JSON data into Tableau where each column is a separate array
- Is there any method to download tables from tableau for further using?
- Is it possible to chain Tableau dashboard actions to run on one click?
- How to pass a value from one Tableau worksheet to another worksheet's Title
- Highlight or color the Text value in tabular/grid report using wildcard search filter in tableau dashboard
- Creating a Pie Chart distribution on a map in Tableau
- how can i compute relative change across previous months with multiselecet month filter
- How to filter top n records from hierarchical fields
- Calculate and display percentage of a boolean column, and date ranges across a set of columns
- Controlling visibility of multiple dashboards in tableau dashboard
- Is it possible to have a dynamic datasource in Tableau? I am using an API to get data
- Trying to create a table from line data in a dual axis spatial sheet
- Are iceberg tables compatible with tableau? how to create tableau reports using iceberg tables?
Related Questions in GRANULARITY
- Getting issue with Snapchat Marketing API for granularity as DAY and TOTAL
- Building dimensional model from multiple sources
- Confusion in Granularity for Time Series Data
- why do pipeline constraints of Coarse-grained multithreading and Fine-grained multithreading differ?
- How to create a custom grid on a Folium Map?
- Fragmentation-Does Anyone know what the alignment of _alloca() is?
- tables daily granularity left join monthly granularity
- Breakdown data-frame into second-by-second time-series
- How to aggregate to group level, order and enumerate groups chronologically? (in SQL Server)
- Tableau desktop average line granularity error
- Change granularity of function plot to make plot look smooth
- how do i convert the working hours to Boolean?
- Aggregate values according to date granularity
- best practices for protecting a production database when using entity framework
- firebase analytics hourly granularity reports
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Two points:
As you stated, you have configured the average line to be calculated across the whole table, which should result in the average line calculation ignoring any more granular levels of detail. Since your line is moving as you add more dimensions to the view, this behavior indicates that you may have configured your average line to display AVG(Sales) Average, instead of SUM(Sales) Average. Right-click the average line and choose Edit. Then, change the Value selectors to SUM(Sales) Average.
When you add an average line from the analytics pane, this metric does not automatically also get added to the tooltip. So, comparing the value of the average line to what you have in the tooltip is likely not a valid, "apples to apples" comparison. Check to see if you may have added AVG(Sales) somewhere else in the view in addition to adding the average line from the analytics pane.