I’m trying to create a simple KPI view that shows me the count of a certain item on this month compared to the count of the last month.
For now, I have a runningSum that sums or counts (depending of the entity) the values for each months that exists registers (“Projects” example): runningSum(distinct_count({project_id}), [truncDate("MM", {project_creation}) ASC])
So, for views that I actually have registers for the current and last month (December - November in this case) the KPI works fine, but for my “Projects” view, I don’t have any register for December (my last register is from November) I have the following:
On this case I would expect to have the same 58 projects (since I have no new registers for the month of December) giving me 0% of difference compared to November.
What can I do to always have the primary value as the quantity for the current month and the secondary value as the last month, whatever the “entity” (volume, projects, users…)?
Yeah, exactly. But is there a way to “assume” that the last registered value is the current value?
For example, in this case, I can say that in November there were 58 registered projects on the platform. If there were no new records, I continue with the same 58.
Was @ErikG 's suggestion helpful, and if so could you mark their comment as a solution to help the community?
It has been some time since we have heard from you but would still like to help you find a solution. If we do not hear from you in the next 3 business days this topic will be archived.
