Forum Discussion
Table shows the same values
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
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.
8 Replies
- Pragati11Super User
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.
- AnonymousNot applicable
- Pragati11Super User
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.
- AnonymousNot applicable
- Pragati11Super User
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:
- AnonymousNot applicable
it actually does not give me the chance to choose in between average, sum... only count and count distinct
- AnonymousNot applicable
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!
- Pragati11Super User
Hi Anonymous ,
I am glad I was able to help 🙂