# YTD and YOY dashboard **URL:** \ **Category:** Get Help\ **Tags:** dashboard\ **Created:** [May 10, 2024, 7:52am UTC](https://community.fibery.io/t/ytd-and-yoy-dashboard/6170 "2024-05-10T07:52:35Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\ **Post date:** [May 10, 2024, 7:52am UTC](https://community.fibery.io/t/ytd-and-yoy-dashboard/6170/1 "2024-05-10T07:52:35Z")
Hi guys, I’m trying to create a YTD and YOY dashboard. For YTD I’ve used the RUNNING\_SUM formula. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/2df805e640b8be86743d71e1bfd0ff1a2bc9bfd5.png) I’ve put the trendline on. But I think I’m doing something wrong since all 0 values are included? How can I get a correct trendline? ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/2bafa2f42aceea257c2f436b6e741770aaf943fb.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/ed6054a5b818cbf227e11b1ca7cb3dad74f7a6f3.png) And what is the best way to create a YOY dashboard? Ideally I want both months next to each other in 1 graph (so Jan 23 / Jan 24 / Feb 23 / Feb 24 etc.) but I couldn’t find an option for this. Thanks! ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [May 10, 2024, 9:28am UTC](https://community.fibery.io/t/ytd-and-yoy-dashboard/6170/2 "2024-05-10T09:28:57Z")
> [@YvetteLans](#): > > But I think I’m doing something wrong since all 0 values are included? How can I get a correct trendline? I’m not sure how Fibery can make a correct trendline, since I don’t know how it can determine whether a particular value is zero because there is no data yet available or because it is genuinely zero value. ---
**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\ **Post date:** [May 10, 2024, 3:50pm UTC](https://community.fibery.io/t/ytd-and-yoy-dashboard/6170/3 "2024-05-10T15:50:09Z")
Is there a way to have an ‘empty’ outcome in a number formula field? Or will it always be 0, even when it’s empty? And if we skip the trendline; is there a way to show the data YOY? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [May 10, 2024, 4:03pm UTC](https://community.fibery.io/t/ytd-and-yoy-dashboard/6170/4 "2024-05-10T16:03:56Z")
Do you mean a report formula or a normal formula field? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [May 10, 2024, 4:05pm UTC](https://community.fibery.io/t/ytd-and-yoy-dashboard/6170/5 "2024-05-10T16:05:09Z")
> [@YvetteLans](#): > > And if we skip the trendline; is there a way to show the data YOY? What would your definition of YOY value be? ---
**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\ **Post date:** [May 13, 2024, 1:06pm UTC](https://community.fibery.io/t/ytd-and-yoy-dashboard/6170/6 "2024-05-13T13:06:10Z")
> [@Chr1sG](#): > > Do you mean a report formula or a normal formula field? I mean a normal formula field. AFAIK there is no option to have ‘empty’ as a result of a number field. > [@Chr1sG](#): > > What would your definition of YOY value be? Just a visual presentation (bar chart is best I think?) of periods from year 1 next to year 2. > [@YvetteLans](#): > > Ideally I want both months next to each other in 1 graph (so Jan 23 / Jan 24 / Feb 23 / Feb 24 etc.) but I couldn’t find an option for this. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [May 13, 2024, 1:10pm UTC](https://community.fibery.io/t/ytd-and-yoy-dashboard/6170/7 "2024-05-13T13:10:36Z")
> [@YvetteLans](#): > > I mean a normal formula field. AFAIK there is no option to have ‘empty’ as a result of a number field. That’s basically correct. > [@YvetteLans](#): > > Just a visual presentation (bar chart is best I think?) of periods from year 1 next to year 2. > > > [@YvetteLans](#): > > > > Ideally I want both months next to each other in 1 graph (so Jan 23 / Jan 24 / Feb 23 / Feb 24 etc.) but I couldn’t find an option for this. You can probably just set the x-axis to be two variables (month & year). The month will give the position from left to right, and for each month there will be as many columns as there are year of data (which you can constrain with filters if necessary)