Forum Discussion

tomringer's avatar
tomringer
Frequent Visitor
9 years ago
Solved

Cumulative chart not rendering correctly after refresh.

Hi, I am having an issue with some cumulative/ period to date measures. They appear how i want them on teh desktop version and, untill I installed a gateway to refresh daily, rendered correctly on p...
  • tomringer's avatar
    tomringer
    9 years ago

    Thanks for getting back to me Qiuyun Yu.

     

    I have solved the issue, which wasn't connected to the date/ time format after all. I was pulling the data through from two different sources - one a static historical worksheet and the other from a live sage query. It turns out a sage developer had changed the format of the value field from whole decimal to $ meaning I wasn't joing, and subsequently summing teh same data types. It's all good now though :smileyhappy:

     

    Best wishes,

    Tom

tomringer's avatar
tomringer
Frequent Visitor
9 years ago

Thanks for getting back to me Qiuyun Yu.

 

I have solved the issue, which wasn't connected to the date/ time format after all. I was pulling the data through from two different sources - one a static historical worksheet and the other from a live sage query. It turns out a sage developer had changed the format of the value field from whole decimal to $ meaning I wasn't joing, and subsequently summing teh same data types. It's all good now though :smileyhappy:

 

Best wishes,

Tom