You need to modify your calculated field as -
IF SUM(sales) >= Target sales THEN
ELSE "Below Target"
then drag this field on Color button on Marks card.. you will two colors (discrete) with options - Above Target & Below Target..
Look at this screen shot.. You need to click the 'Center' button and enter your target value within the box below.. Then it will set Green color to all bars having values above the target and Red color to all bars with values below target..
Other way is to create a calculated field which tests...
The YTD options are greyed out when your chart doesn't contain MONTH component along with YEAR component.. If you bring the year & month both on the sheet then YTD option in Table calculations will become enabled..
You get different dates because RANDBETWEEN function is active till the formula values are replaced by actual values.. So there is nothing wrong.. Just make sure that once you paste the dates as values in Excel sheet, it shouldn't contain any formula..
1.Create two parameters - Year & Category
2. Then create a new calculated field to select the category dimension based on the Category parameter value...
3. Then you need to create two more calculated fields -
Average value of selected category & selected year
Average value of selected...
Pls try one of the links below on your machine for Tableau Public setup -
1. Error "0x80070109" When Installing Tableau Desktop
2. Unable to install tableau desktop
Error 0x80070666 Installing Tableau Desktop, Tableau Prep or Tableau Reader
Make sure you have Windows 10 OS...
Pls find some useful links for below from where you can download the datasets for Tableau practice -
Tableau datasets - https://www.tableau.com/learn/articles/free-public-data-sets
Data sets for everyone - https://www.tableau.com/data-sets-students
How to find the best...
The error that you are getting due to aggregate / non-aggregate values produced by "Year" field and parameter "Year Parameter".. Try ATTR() function to both fields instead of INT() function.. Hope that might resolve the issue..
Well done.. You are almost there.. a quick suggestion - instead of setting the bullet chart layout as "Entire View", change it to "Fit Width" since currently it looks cramped.. Setting it to "Fit Width" might produce vertical scroll bar but it will look better than current layout.. Give a try...
The Simplilearn community is a friendly, accessible place for professionals of all ages and backgrounds to engage in healthy, constructive debate and informative discussions. Get your pressing questions answered,
participate in monthly contests, create polls to get a feel for the market, build your network, and more! Pull up a chair and come join the discussion -today!