Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

  • 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's avatar
      Anonymous
      Not applicable

       

      • Pragati11's avatar
        Pragati11
        Super 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.

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Pragati11 

     

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

     

    • Pragati11's avatar
      Pragati11
      Super 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:

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable

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

         

         

  • Anonymous's avatar
    Anonymous
    Not 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!

    • Pragati11's avatar
      Pragati11
      Super User

      Hi Anonymous ,

       

      I am glad I was able to help 🙂