Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to sum count of country.
For Example,
Week | Qty | Count Of Store |
10 | 6 | |
2018-01 | 1 | 3 |
2018-02 | 0 | 3 |
2018-03 | 0 | 3 |
2018-04 | 3 | 3 |
2018-05 | 0 | 6 |
2018-06 | 0 | 6 |
2018-07 | 1 | 6 |
2018-08 | 0 | 6 |
2018-09 | 5 | 6 |
2018-10 | 0 | 6 |
I want Sum(Count of Store) = 48 but Sum(Count( DISTINC Store)) is not working.
Please Help,
Count DISTINCT only finds the number of stores ...not the the total of stores
Count(DISTINT Store) = 7, this is correct as there are only 7 distinct stores
If you wish to sum the store, you will need to add a separate expression Sum(Store)
hello
if you want to sum the values, use
sum([Count of Store])
your formula sums the number of distinct values
Try it with: Sum(aggr(Count( DISTINC Store), Week))
- Marcus
İts work. Thank you so much
@Anonymous @marcus_sommer @olivierrobin @ljackson
Hello, I have a similar question on this forum:
I was wondering how could I Sum the Count of several different values (by specifying which ones I want to Sum) to obtain the total percentage in a pie chart.
Does anyone here know how to help? I would really appreciate it.