Dashboard Charts

Cheryl Collins

Hi

I'm trying to create a graph to show the number of hours per person per day. I've tried every type of graph on the dashboard but none will show the data from the report?! Why? What am I doing wrong? Never had a problem with charts before!

Report:

Dashboard:

Super frustrated at the moment as even the simplest of things I can't get working! 😪

TIA

Cheryl

Andrée Starå

Hi @Cheryl Collins

I hope you're well and safe!

You need to convert the text to numbers, it seems, with the VALUE function.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

@Cheryl Collins

Excellent, i will be happy to help you any time. Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Bassam Khalil

Hi @Cheryl Collins

Hope you are fine, did the number in this report created by formula?

Cheryl Collins

Hi @Bassam Khalil

Yes it is. Is that the issue? I thought it may be that. Am I better putting the formula in the sheet summary and creating a report from there?

Thanks

Cheryl

Andrée Starå

Hi @Cheryl Collins

I hope you're well and safe!

You need to convert the text to numbers, it seems, with the VALUE function.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

@Cheryl Collins

Excellent, i will be happy to help you any time. Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Cheryl Collins

Hi @Andrée Starå

Fabulous, that's done it! Never come across that one before.

@Bassam Khalil Thanks for your help and I have accepted and voted up.

Stay safe both.

Thanks again

Cheryl

Andrée Starå

@Cheryl Collins

Excellent!

You're more than welcome!

Bassam Khalil