Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
My dataset was like
Year | Count({<Statu] = {'Active'} Emp_ID) |
2000 | 20 |
2001 | 9 |
2002 | 48 |
2003 | 54 |
2004 | 95 |
2005 | 65 |
2006 | 53 |
2007 | 57 |
2008 | 77 |
2009 | 23 |
2010 | 100 |
2011 | 47 |
2012 | 53 |
2013 | 30 |
2014 | 69 |
2015 | 63 |
2016 | 38 |
The second column is how many new employees started in that year. I would like to create a line chart, X axis is Year and Y axis is the total active employees in that year, so the results should be like below
Year | Count({<Statu] = {'Active'} Emp_ID) | Active Emp |
2000 | 20 | 20 |
2001 | 9 | 29 |
2002 | 48 | 77 |
2003 | 54 | 131 |
2004 | 95 | 226 |
2005 | 65 | 291 |
2006 | 53 | 344 |
2007 | 57 | 401 |
2008 | 77 | 478 |
2009 | 23 | 501 |
2010 | 100 | 601 |
2011 | 47 | 648 |
2012 | 53 | 701 |
2013 | 30 | 731 |
2014 | 69 | 800 |
2015 | 63 | 863 |
2016 | 38 | 901 |
But I only want to check dtaa after 2010 , do I use if(Year >= 2010, Year) as Dimension, and use
rangesum(above( count({<Status= {'Active'}, Year = {">=2010"}>} Emp_ID), 0, RowNo()))
as measure.
But the results are not correct, as in 2010, the number is 100 instead if 601
can you please assist with that?
Many thanks
Hey Nina,
If I understand it correctly, it seems like the issue with your current approach is that the ''above'' function only looks at the rows above the current row in the chart, not in the underlying data. Since you’re using if(Year >= 2010, Year) as your dimension, the chart only includes rows where the year is greater than or equal to 2010. This means that the ''above'' function only looks at rows where the year is greater than or equal to 2010, and doesn’t include the data from previous years.
To get the correct result, I think you need to include all years in your chart, not just those greater than or equal to 2010. You can do this by using ''Year'' as your dimension instead of if(Year >= 2010, Year). Then, you can use a set analysis expression to limit the data used in your measure to only include years greater than or equal to 2010