Hi,
I want to count no. of days with respect to different dimensions. As I have dimension as segment and month. I want to count total days for of current fiscal year wrt segment and want to count days in that month wrt month.
I want to achieve this from a single variable. Kindly suggest a set analysis from which I can achieve this:
(Desired output is from 1 Apr to 7 June, so total count of days are 68).
Desired output:
Segment_1 | Days |
---|
| 68 |
Agro Commodity | 68 |
Aluminium | 68 |
Buildestate | 68 |
Common | 68 |
IT Service | 68 |
Lead | 68 |
Non-Ferrous | 68 |
Month | Days |
---|
| 68 |
Jun | 7 |
Apr | 30 |
May | 31 |