Jump to content
  • 0

Is it possible to have last 12 months in charts and automatically update them?


Aleksandra
 Share

Question

Hello,

Does anyone know if it is possible to create a chart, so it shows a period by month for the last 12 months? So, for example, if I have data from 2020-2022, I want to be able to see data on my chart from November 2021 to November 2022. On the 1st of December, I would like to see data from December 2021 to December 2022 and so on. So, I would like to see data for the last 12 months updated automatically for each month. Is it possible to do this in Caspio and if it is, what would be the best way to do it?

Also, there is an option for yearly records to roll out by the current year, but it shows data for the current calendar year (2022). I would prefer my yearly data to show values from the last 12 months, not a particular calendar year. Is there a way to make this work as well?

So, I need data rolled out by months and by years for 2 separated charts. Thank you all in advance.

Regards,

Aleksandra

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0

Hello @Aleksandra,

While I would still need more details to be sure, the concept you have mentioned seems attainable.

In regards to the filtering the last 12 month of records, what I would do there is create a task that will run daily which checks the date and mark those records that are from 12 months before and less, then, we can simply apply filters on view or datapage search function to only include marked records.

In my opinion, we will really need to use a task on this since we cannot use dynamic or live dates on formula fields.

Link to comment
Share on other sites

  • 0

It should be possible, I think? 

The values on the charts still relies on the filtering on the search form. As mentioned, we will use the task to mark records that are 12 months and below and use the datapage filtering to filter out unmarked records. 

Link to comment
Share on other sites

  • 0

I just got another idea from my colleague. 

You may also try having a formula field with a dateadd function. Basically, get the date value on your date field and add 12 months to it. 

Then, on your datapage, just filter the records using the formula field set to capture all records that are greater than and equal today.

So if the date is about 9 months ago, plus 12 months to it, then it would be about 3 months in advance the current date. Since the filter capture every records that are greater than today, then they will be captured.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...