Skip to Content
0
Aug 02, 2023 at 12:47 PM

Count rows in SAC with no aggregation?

67 Views Last edit Aug 01, 2023 at 11:18 AM 2 rev

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?