Formula fields in Dashboard
planned
Eva Shapiro
Hello! Can I use formula fields too in my Dashboard, in such widgets like Bar chart, etc? Now I only can use money fields, but would really appreciate adding Formula fields too!
Log In
Sigurd Seteklev
Hi!
This is now marked as Planned, but we have built support for formula fields in calculation cards and bar charts. We don't have 100% support yet, but that is planned. We have a lot of things in progress, so please keep posting on the parts you feel are missing and upvote and it'll help us prioritize based on your needs :)
Thank you!
L
Levi Bretz
I'm sure this has been said, but I would really love to see formulas using TODAY() able to be used in dashboards.
Sigurd Seteklev
Hi!
This is now marked as Planned, but we have built support for formula fields in calculation cards and bar charts. We don't have 100% support yet, but that is planned. We have a lot of things in progress, so please keep posting on the parts you feel are missing and upvote and it'll help us prioritize based on your needs :)
Thank you!
L
Logan Neave
Sigurd Seteklev can I just confirm on the calculation cards, is it supported yet? I have created an advanced formula field and yesterday I was able to see it in custom calculation measure drop down, but today it is not an option. Any ideas?
Sigurd Seteklev
Logan Neave: No, sorry. It sounds like a bug. We'll try to explore. It's good to report these things to support since they help us triage and prioritize things like this :)
V
Victoria Fox
Sigurd Seteklev Will there be a beta release & sign up for this feature?
Sigurd Seteklev
marked this post as
planned
Mariana Irazu
Sigurd Seteklev �
J
James Gill
What the heck...I ran across this video from a year ago clearly showing that I can use formula fields in a Calculation Card. So this feature WAS in ClickUp, and yet the support AI says its not a supported feature.
Wut
Sigurd Seteklev
James Gill: You should be able to use formula fields in Calculation card, but we don't have support for everything yet (see my screenshot).
Can you explain what you are seeing in the UI?
L
Logan Neave
Sigurd Seteklev this is what I was seeing but then it vanished. I was looking to use a formula that is using an advanced formula
Monika LaPlante
Sigurd Seteklev Thank you for all of this information! I am not seeing the "formula" option- was this feature released for everyone?
J
James Gill
Sigurd SeteklevThat's exactly what I'm looking for and see initially, but after I add the formula field it eventually disappears and no longer allows me to select it as a field in the calculation card configuration screen.
I confirmed with Mark in the Technical Support Team that there is an internal development ticket tracking this issue and he verified that this is an open bug.
Here is the Report ID: CLK-869202
I'm not sure what you mean when you say that "you don't support everything yet", but I'm simply trying to average a calculation that tracks the number of NETDAYS an issue has been active.
This appears to be a limitations of Formula fields and specifically, the TODAY() function.
So how am I supposed to calculate the age of a ticket in Network Days as a whole number?
Sigurd Seteklev
James Gill: So how am I supposed to calculate the age of a ticket in Network Days as a whole number?
I don't know. This is one of the limitations we have with the formula fields today. It will be something we look into when we finish this feature.
A
Awais Ali
Hi Lily Chan
I'm trying to add a custom formula field as a measure on the Y-axis of a bar chart. However, I'm not seeing the option for formula fields that you showed in your video. This is what I'm seeing:
Thanks for your help.
Sigurd Seteklev
Awais Ali: Sorry about the late reply. The best way to report bugs like this is via support.
Did you find a solution? If not, can you share how your formula is defined?
Elena Ramirez
Hello! I can't add a calculation-type card with an average of a formula. Is this planned? Thank you!!
Sigurd Seteklev
Elena Ramirez: Can you explain what you are seeing? I'm able to do it in my workspace, but perhaps you are hitting a bug?
Sunny See
Any update for this feature? would like to have formula fields to be displayed in pie chat!
Barbara Szwabowski
Lily Chan Has the option of adding a formula to workload - particularly on the Team View - been discussed yet??
Lily Chan
Hi Barbara Szwabowski! It looks like there is existing canny requests related to adding Formula fields in Workload view: https://feedback.clickup.com/feature-requests/p/track-formula-custom-field
Please vote on this and comment on your particular use case.
For Team view, it doesn't look like there's a canny request for adding formula fields to that one yet, so please submit a new one for the Team view category.
Barbara Szwabowski
Lily Chan Thank you for the quick reply!
Drew Griffiths
Hi!
One thing I noticed is that you can't select a formula field in a calculation card that is setup on a space level. Will this also be included when this is finished? Or any update on when this part of the feature will be included?
Lily Chan
Merged in a post:
Pie chart group by formula
J
Jonathan Cocuy
it has already been included in the bar chart, but it is not in the pie chart.
Load More
→