Forum Discussion

dickfederle's avatar
dickfederle
Regular Visitor
9 years ago
Solved

Percent column in json data displaying as decimal

I have a Json.Document(Web.Contents query that works great except that one of the expanded columns, which comes in as "any", I change it's data type to "percent" and it shows in the query correctly as a percentage.  However, when I pull it into any visual including tables and matrices, it shows as decimal.  This is happening for mutliple columns on two different Json.Document(Web.Contents query calls.

 

Any thoughts?

Need Help
  • dickfederle's avatar
    dickfederle
    9 years ago

    I just found my own answer.  I have to change it in the "model" as well (or not change it in the query at all) for it to pass through to the reports.  It shows as numeric in the "model" even though I change it to percentage in the query transforms.

     

    I would think this was a "bug"

1 Reply

  • dickfederle's avatar
    dickfederle
    Regular Visitor
    9 years ago

    I just found my own answer.  I have to change it in the "model" as well (or not change it in the query at all) for it to pass through to the reports.  It shows as numeric in the "model" even though I change it to percentage in the query transforms.

     

    I would think this was a "bug"