Forum Discussion

PatrickCote's avatar
PatrickCote
New Member
9 years ago

Data with no sum

Hi everybody, I'm  trying to build a chart with values ​​without any sum, only the raw values. I tried to change the sum default value to "no sum" but it does not work, a calculation is still mandat...
Need Help
PatrickCote's avatar
PatrickCote
New Member
9 years ago

I can drill down, but still a sum and I DON'T want it as a sum but only the values.

 

Sorry, my english hurts, but I hope you understand what my problem is?

  • fhill's avatar
    fhill
    Resident Rockstar
    9 years ago

    This is a good mystery...  I thought your data was Text because you don't have the Sigma symbol next to you values...???  (Blue circle below)  I think this is a symtom of the problem you are seeing.  

     

    Did you create your visual before changing the coulmn type to Numeric?  If so, you may need to rebuilt your visual now that you have changed the column type.  If they were numbers all along, what did you do to get the "(Value, 99D99)" nex to the column name, maybe this is part of the issue...?

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    OK, there is no issue with a SUM if it is a SUM of a single value. I think that is the issue here. You need to get your visual to a state where you are summing a single value. You have to have an aggregation of some sort, SUM, MAX, MIN, etc. 

     

    So, the question I have is, "what is preventing you from having this displayed where every value is the sum of a single value?"?

     

    If you have your visual drilled down to date and hour, you have a single value unless you have multiple metrics, but you can solve that by either filtering or putting that column into your legend.