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!
Caroline Ginty
Merged in a post:
Line chart with formula field
Marcos Santiago
It would be great to have the possibility to generate a line chart from a formula field, would you have any idea when this function will be available?
Olivier
That would be a huge upgrade !
If possible to consider :
- Using and creating custom fields / variables to be used inside a dashboard with other formulas and variables.
- Some custom fields like "Rating" are not accessible in formula fields but they should be easy to convert into numerals.
- Custom Graphs can only do one thing : i.e calculate sums with the selected fields. would be great to have other means of compiling data within a graph (averages, count, diff, etc.)
Caroline Ginty
Merged in a post:
It would be nice if there's a greater flexibility on what formulas can be used in calculation custom field and additional analytics/cards that are same with other top tier project management softwares
Jan Roald Triumfante
Paul McGarry
I have saved some very simple formula fields in my list templates but they do not get created when using templates to create a list. This makes automation of project setup impossible
Sigurd Seteklev
Paul McGarry: Lily is this perhaps a bug or a limitation with templates?
H
Harry Hodge
Hi, this would be great as currently I cannot use clickup for some processes until this is complete. Thank you!
Sigurd Seteklev
Harry Hodge: Thank you! Are there any specific limitations you are facing?
H
Harry Hodge
Sigurd Seteklev I currently cannot calculate efficency or lastest value. I would recommend getting some inspiration from Google Looker Studio as that's what we currently use. The most valuable feature to me would be the ability to calculate an already calculated field and then being able to use this in an automation at the same time. For example, Average Mileage for the fleet at the time an automation is complete.
Julie Babin
Hi Caroline Ginty, I see here we should be able to calculate data from a custom field formula, but it is not an option in my Space, can you please advise ?
Caroline Ginty
Julie Babin Which card are you using, and what is the Formula in question? cc Sigurd Seteklev
Julie Babin
Caroline Ginty Thank you for your reply. I am trying to calculate an average from a Formula custom field in a Dashboard. Idealy, a bar chart per month, if not at least a calculation widget. Thank you for your support !
Caroline Ginty
Julie Babin Thanks for the feedback! cc Sigurd Seteklev
Sigurd Seteklev
Julie Babin: Thank you for your feedback!
Caroline Ginty
Merged in a post:
Formula fields into cards (charts)
M
Manuel Sandoval
Allow Formula fields as metric for charts (Dashboards)
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
Victoria Fox: Sorry for the late reply. We often do that, but we will have to plan for that when we start this work again. It depends on the risks we see with releasing the feature :)
Sigurd Seteklev
marked this post as
planned
Mariana Irazu
Sigurd Seteklev �
Load More
→