How to show zero values in graphs in Analytical boards?

I have  a graph created for finding number of connects with customers in the last quarter. However, the graph does not include customer names when there has been no connect in the last quarter. Is there any way, I can see the customer names in the graph with zero count in date section.

 

Below is a sample data where I want CDEcustomer to  be included in the graph with 0 count, since last connect is more than a quarter ago.

   
   
   
   
   
0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
8 comments

Hello! Are you doing this in a regular report or in Wrike Analytics?

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Wrike Analytics Board

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

I have been able to do this in Analytics by choosing the 3dot menu next to "Values" and selecting "Display missing values as zeros."

 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

This is already enabled, but doesn't work in the example I had attached in the original post. The reason being the function works only if there is a unique set of names & if one of the dates is blank then the graph would show as 0, however here we have a multiple names with multiple dates

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hmm. It's hard to say without knowing your exact set up. I would submit a help ticket and include as much info as possible.

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

hi Hitesh Karkal, can you provide setup of widget?

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Sure Pietro, here you go

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Hitesh Karkal, I confirm i can display also values with zero.

Maybe have you some filters enabled that break something

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: How to show zero values in graphs in Analytical boards?
[this list is visible for admins and agents only]

Top
Didn’t find what you were looking for? Write new post