Create Chart Widget Using a Report (not a Sheet)
Answers
-
Genevieve P. Employee Admin
Hi@markh10
Thank you for the screen capture, that's very helpful! Can you explain what it is you're looking to chart, or how you want the chart to appear?
The image of your report shows 4 cells of data, and all of them have Text associated with them (no numbers). A Chart would need numbers in order to map information into bars or pieces of a pie.
-
markh10 ✭
Doh. No numbers = cannot chart. Thank you.
-
Genevieve P. Employee Admin
No problem
If you Group and Summarize rows in a report it can use those numbers for a chart, or you could use a formula to create your calculations.
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/20306/create-chart-widget-using-a-report-not-a-sheet/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/20306/create-chart-widget-using-a-report-not-a-sheet/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>