asked on December 8, 2020
Hi!
Few words to explain what I want to achieve on my chart. I want to visualize how the value of all managed assets has changed in years / months. The thing is, for a year users want to see values for the last available month but want an option to split the year to see how the values have changed monthly. There is no option to calculate the "last" month in calculated fields so we decided to take a different approach.
For a new asset, the original price is saved as the value. And every time the value changes, we just save the difference. This solution works perfectly for a year. The problem is, if more years are shown, runningtotalsofrow is reset when the year is broken down into months.
Example can be found here: http://jsfiddle.net/szrb8Lc1/23/
Is there an option to disable runningtotalsofrow reset? Or maybe there is a different way to build this chart?
Kind regards!
⋅ December 10, 2020
Hello, Randolph,
Thank you for posting to our forum.
Our team is currently working on your questions.
We will make sure to reach out to you as soon as possible.
Best regards,
Milena
⋅ December 14, 2020
Hi, Randolph,
Thank you for describing the desired component behavior in detail and for providing the JSFiddle example and screenshots.
Our team would like to suggest a solution for both cases you mentioned. Please find it below.
To see values for the last available month, please add the last_month field, which has true/false values, to your dataset. This will allow you to filter the months by last month.
For the case with runningtotalsofrow and months, we suggest showing only months instead of the year/month/day hierarchy.
Please see the example we have prepared for you: http://jsfiddle.net/flexmonster/43cv5arq/.
Here are some explanations about the code in the sample:
We defined preprocessData function to add the year, month, and last_month fields to the original dataset. Please define your own logic to mark whether the month is last available. As an example, we specified that the last_month has value true if the month == 12.
To show only months on the x-axis, the month field is selected in the slice. To display only the last months, the months are filtered by the last_month == true using filter object:
"filter": {
"members": [
"last_month.[true]"
]
}
The runQuery API call is used to change the slice.
Please let us know if the suggested approach works for your case.
Looking forward to your response.
Kind regards,
Milena
⋅ December 15, 2020
Hi Milena!
Thanks for you answer and for an example. I will try to adapt our data model and chart in next days.
Kind regards!
Randolph
⋅ December 24, 2020
Hello, Randolph,
Hope you are doing well!
Our team was wondering whether the suggested approaches helped.
Have you achieved the desired charts' appearance?
We will be glad to hear your feedback.
Best regards,
Milena
⋅ January 15, 2021
Hi, Randolph,
How are you?
We would like to kindly take an interest in whether our response helped.
Could you please let us know if our suggestions worked for your case?
Looking forward to hearing from you.
Best regards,
Milena