Table shows the same values

[Anonymous]

Hi all

Sorry for my superstupid question, I am an absolute beginner and struggle with the same mistake over and over.

I'm trying to set up a table that has different months and different values.

Unfortunately, all months show the same january-values. Any suggestion what my mistake is?

BR;

bdstinella

[Anonymous]

Ah I found the problem now - I had to change one of the columns from text to "whole number" - Thanks a lot- you brought me on the right way!

[Pragati11]

Hi @Anonymous ,

I am glad I was able to help 🙂

[Anonymous]

Hi @Pragati11 

Thank you for the speedy information! Find below the visualisation and the figures...

[Pragati11]

Hi @Anonymous ,

I actually wanted to see what you are moving in the visual not your data.

Have you got any summarisation on the value that you are using to your visual like SUM, AVERAGE, etc.?

Something like shown below:

[Anonymous]

it actually does not give me the chance to choose in between average, sum... only count and count distinct

[Pragati11]

HI @Anonymous ,

Can you share the complete screenshot of the visual? Specially with the columns and values you are moving to it.

Also check the data or may share some sample data that you are representing on this chart.

[Anonymous]

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You still haven't shown me what I want to see. I am looking for this in a chart:

It seems like you are moving a TEXT type of value to the chart, therefore it is giving you only Count/Count(distinct) options for summarisation.

What you really want to display?

Chat seems to be displaying correct information as the COUNT of Total signed off may be is same for Every month.

I would suggest checking your data here.