Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
When download timeseries data to the report the dataset apperas as sum. But I need the count by year. Exapmle, population data from 2010 to 2022 by county.
Solved! Go to Solution.
@Sujit-TN Simple by taking the required fields like this:
If I click year in slicer can I get the output for that year?
Hi @Sujit-TN
--If I click year in slicer can I get the output for that year?
Yes, it is.
If Tahreem's answer was helpful, don't forget to mark it as an soluntion~🤗
How to Get Your Question Answered Quickly
Best Regards,
Gao
Community Support Team
County Year and population in the input set.
How can I attachinput dataset from my computer ? I am concern about security.
@Sujit-TN I am not at all interested in your original data. I clearly mentioned "Sample" word in my first reply.
Here is one dataset as a sample.
Anderson | 2010 | 75129 |
Bedford | 2010 | 45058 |
Benton | 2010 | 16489 |
Bledsoe | 2010 | 12876 |
Blount | 2010 | 123010 |
Bradley | 2010 | 98963 |
Campbell | 2010 | 40716 |
Cannon | 2010 | 13801 |
Anderson | 2011 | 75224 |
Bedford | 2011 | 45503 |
Benton | 2011 | 16429 |
Bledsoe | 2011 | 12854 |
Blount | 2011 | 123899 |
Bradley | 2011 | 100063 |
Campbell | 2011 | 40529 |
Cannon | 2011 | 13743 |
Anderson | 2012 | 75418 |
Bedford | 2012 | 45571 |
Benton | 2012 | 16372 |
Bledsoe | 2012 | 12786 |
Blount | 2012 | 124174 |
Bradley | 2012 | 101140 |
Campbell | 2012 | 40433 |
Cannon | 2012 | 13817 |
Report should contain population by county and year in slicer. Also, population by county and year in TN county map.
@Sujit-TN I think you misunderstood my question. Add the Expected output column in your input table. So I can help you out with your query.
Did you get the inputset? In output: Population in y-axis and location in x-axis in the bar chart. Year in slicer.
Does it help.?
@Sujit-TN Simple by taking the required fields like this:
Looks good. I am not interested in sum of population. Rather, population by year.
@Sujit-TN Thanks for sharing the sample data. Please also add your expected output.
@Sujit-TN Could you share the dummy input data and expected output in order to understand your query.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |