I have a Table with following columns:
-startDate (Date)
-courseId(Decimal Number)
I want to create a chart that shows how many courses were taken in the different moths of the year. I tried using Count under aggregation, but the result is wrong: My table has about 20 000 rows, yet it says that in total, there is only 632 rows of courseId.( I created a calculation for the y axis, and the dimension for the x axis which extracts the year from the date format)
Example Table:
startDate courseID
1.1.1970 9817398217
2.3.1971 028302830
4.5.1990 391280391
Output should be a bar chart, which shows how many courses were done in the y dimension, and the years from 1970 - 1990 in the x dimension.
How do I do this?