user082291 Member

Hi James, I don't recall as this was back in July 2021. But interestingly has started happening again in the last few days. I submitted a ticket to Support. Sorry I can't be of more help. I suggest submitting a ticket with support.

Ok. Thanks for the answer.

Ok, I was able to replicate this now. Thank you.

Oh no I think I jumped the gun, I can't seem to get to the three dots and this drop down. Sample of my data table below the card Are you says to click this below the card or something else when in Analyzer? Thank you,

Oh my gosh. Thank you so much Mark.

Thank you for the prompt answer. This is what I was looking for.

Perfect, That worked! Thank you very much Mark.

Thank you, Can you give me an example of the round function. I tried and not getting it to work. What would go inside the parentheses? Thank You. AVG(DATEDIFF(`Investigation End Date`,`Investigation Start Date`))Round()

Thanks, I did try that formula and get the same output in decimal format. I now want to round the output to the nearest whole number and not sure how to. I tried to use the round function, but it's not working or I am not using it correctly. thanks for you assistance AVG(DATEDIFF(`Investigation End Date`,`Investigation…

Thank you for the reply. I do have that checked and it is not working for me. My output is based on a formula: AVG(`Investigation End Date`-`Investigation Start Date`) so I wonder is that has something to do with it. It is taking the difference between the start and end dates of reports with the quarter and getting an…

Hello, and thank you for responding. I think if I add an attachment, it might help what I trying to explain however,I think I might know what the issue is. I had created a collection of cards for a dashboard then did a save as to create several other dashboards for each of our organizations. When you go to edit the card to…

Hello @GrantSmith Thank you for your input, this is most helpful. I will give this a try.