asked on August 9, 2021
Hi,
We are trying to display month data for a rolling year starting from the current month. Our json response that we are sending to the pivot is as attached. However the pivot considers only the first element in the array to form the slice (measures) - attached screen shot of the pivot table.
Can you help us in finding a solution to display the current month till Dec under current year (2021) and the remaining months (Jan to current month -1) in the next year (2022)? Data in json is as per this structure (please see attached).
Thanks.
⋅ August 10, 2021
Hello,
Thank you for reaching out.
To achieve the described visualization, we suggest creating a separate "Month" field instead of using a separate measure for each month.
Such an approach would allow displaying different months under each year.
We have prepared a JSFiddle for illustration: https://jsfiddle.net/flexmonster/cdez2j61/.
In the example, we preprocessed the data a bit in the following way:
From this format:
[
{
"id": "FOID_411F9462-4A0F-482F-8335-12820B07090A",
"FinancialYear": 2021,
"ProductName": "Potash",
"MarketerName": "Admin Bhagin",
"ProductCategoryName": "Paper Crafts & Hand",
"LocationName": "Bangalore",
"CustomerName": "Emisha Tech",
"Aug": 0,
"Sep": 10,
"Oct": 0,
"Nov": 5,
"Dec": 8
}
]
To the following:
[
{
"id": "FOID_411F9462-4A0F-482F-8335-12820B07090A",
"FinancialYear": 2021,
"Month": "Aug",
"ProductName": "Potash",
"MarketerName": "Admin Bhagin",
"ProductCategoryName": "Paper Crafts & Hand",
"LocationName": "Bangalore",
"CustomerName": "Emisha Tech",
"Aug": 0,
"Sep": 0,
"Oct": 0,
"Nov": 0,
"Dec": 0,
"Value": 0
},
{
"id": "FOID_411F9462-4A0F-482F-8335-12820B07090A",
"FinancialYear": 2021,
"Month": "Sep",
"ProductName": "Potash",
"MarketerName": "Admin Bhagin",
"ProductCategoryName": "Paper Crafts & Hand",
"LocationName": "Bangalore",
"CustomerName": "Emisha Tech",
"Aug": 0,
"Sep": 10,
"Oct": 0,
"Nov": 0,
"Dec": 0,
"Value": 10
},
{
"id": "FOID_411F9462-4A0F-482F-8335-12820B07090A",
"FinancialYear": 2021,
"Month": "Oct",
"ProductName": "Potash",
"MarketerName": "Admin Bhagin",
"ProductCategoryName": "Paper Crafts & Hand",
"LocationName": "Bangalore",
"CustomerName": "Emisha Tech",
"Aug": 0,
"Sep": 0,
"Oct": 0,
"Nov": 0,
"Dec": 0,
"Value": 0
},
...
]
Please let us know if this helps.
Feel free to reach out should other questions arise.
Kind regards,
Vera
⋅ August 10, 2021
Hi Vera,
Thank you for your response! This helps.
Warm Regards,
Akshay
