Forum Discussion

gcrespo's avatar
gcrespo
Helper I
3 years ago
Solved

Use values in calculated column without summarization

Hi, I'd like to use the values in a calculated column as values in a visual (Y axis). These columns are set to "Don't summarize" in the Table view (check screenshots).   Every time I t...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Here are the 2 changes i carried out.

    1. Dragged Name from the Tactics table (rather than Tactics from the techniques table)
    2. Changed the summarisation function to sum

    Hope this helps.

     

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    A column chart visual requires aggregation over the Y axis.  I changed the visual to Table and the column is showm without aggregation.

     

     

    • gcrespo's avatar
      gcrespo
      Helper I
      3 years ago

      Hi Ibendlin,

      Thank you, but I'm afraid that's not the point. The point is why can't I use a measure in the Y axis? I have previously calculated that aggregation myself. I need to show the following values:

       

      Number of Techniques with CdU / Total number of techniques * 100 (percentage)

       

      this is to show the coverage of Techniques I have over the total number of them. And this has to be done grouped by Tactic (That's why I was using a radar chart). Honestly, it's nonsense I cannot use a INTEGER value in a Y axis!!!

       

      Regards,

      Gabriel Crespo

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        You cannot measure or aggregate a measure. Incorporate your complete loginc in a single measure.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    Here are the 2 changes i carried out.

    1. Dragged Name from the Tactics table (rather than Tactics from the techniques table)
    2. Changed the summarisation function to sum

    Hope this helps.

     

    • gcrespo's avatar
      gcrespo
      Helper I
      3 years ago

      Hi Ashish Mathur,

      Thank you for that, however, I'm afraid that's not solving the problem. I need to know why I can't use an INTEGER value in a Y axis.

       

      Regards,

      Gabriel Crespo

    • gcrespo's avatar
      gcrespo
      Helper I
      3 years ago

      Hi again,

      I've been investigating and it looks like what I'm looking for will not be possible. Your answer works and provides the same output I was looking for.

       

      Thank you and regards,

      Gabriel Crespo