Category
Data Transformation
Product Version
9.0
Accumulation by month
Answered
Hello,
I would like to have accumulation by month and to have a curve by month.
I have this :
So I would like accumulation by month and the dots are connected (it's because i have blanked)
I forget to mention, the two columns are not in the same dataset, I use a subquery join by the date.
Best Regards
Maxime Bombart
The same question
Hi Maxime,
Thanks for contacting Yellowfin. Can I ask which client you are working for or which partner you've purchased Yellowfin from? I can't find Total Energies on our records.
As for your request, it should be possible, what exactly are the issues you are running in to here? I can see that you've already got what looks like separate columns for the accumulated value and joined it via date so the records match up.
Your chart is in order of value rather than date, is that what you want to see? It looks like you're possibly already using a Vertical Overlay chart to view the point representations of the accumulated value as well as the per month value. If the date column is formatted as a date in the view, you can turn on the Time Series so they are in order.
I've created something similar below:
I hope that helps!
Kind regards,
Chris
Hi Maxime,
Thanks for contacting Yellowfin. Can I ask which client you are working for or which partner you've purchased Yellowfin from? I can't find Total Energies on our records.
As for your request, it should be possible, what exactly are the issues you are running in to here? I can see that you've already got what looks like separate columns for the accumulated value and joined it via date so the records match up.
Your chart is in order of value rather than date, is that what you want to see? It looks like you're possibly already using a Vertical Overlay chart to view the point representations of the accumulated value as well as the per month value. If the date column is formatted as a date in the view, you can turn on the Time Series so they are in order.
I've created something similar below:
I hope that helps!
Kind regards,
Chris
Replies have been locked on this page!