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 |
