search

ngs-doo / TemplaterExamples

Creating reports in .NET and Java
https://templater.info
The Unlicense
48 stars 27 forks source link

Stacked bar does not render #36

Closed aabusalha closed 1 year ago

aabusalha commented 3 years ago

I am development a new report that contains Stacked bar, the issue which I am facing is the bar does not render automatically unless do Edit Data, the stacked bar contains 3 columns (list of project(name), start date(date), finish date(date), and calculated duration.

Json file is attached. any assistance! Json.txt

zapov commented 3 years ago

Please also upload the template. Its hard to reproduce the issue without it

aabusalha commented 3 years ago

Hi Zapov,

here is the template for showing CategoryPiplineChart.docx the project chart

zapov commented 3 years ago

Since the JSON you provided is not really a valid JSON, can you please upload the expected output here?

Without that info I'm guessing you are having problems with duration because its an expression instead of value. You can fix that by using explicit tag which calculates the duration instead of using Excel to calculate it

zapov commented 1 year ago

Alternative way to solve this is to use low level plugin to calculate this expression instead of using formulas for expression. There is an example here of how to have custom evaluation in expressions: https://github.com/ngs-doo/TemplaterExamples/tree/master/Advanced/DepartmentReport