Dynamic table order incorrectly for decimal points columns

[YY1]

Hi

Anyone knows how to show 0 for 0 value and blank for empty dates in Dynamic table?

Thanks,
YY

[BertrandDrouhard1]

Hi @YY1 ! Could you show a sample of the data you use? It will be easier to reproduce your problem.
Regards,
Bertrand

[YY1]

Hi @BertrandDrouhard1

Thanks for your help.

The data exported are correct. Please use spreadsheet or Excel to open it becaus it’s a CSV file:
sprintdata_2024-03-08T13-16-06.docx (2.0 KB)

The app is under development enviroment. I think we can install it to triage the issue if you need it.

Thanks,
YY

[BertrandDrouhard1]

I can’t open your docx file, the format is invalid. Maybe you could just share the csv content in a post in a code section.

[YY1]

boardName,boardLink,sprintName,sprintLink,sprintGoal,sprintStatus,completionRate,committedStoryPoints,completedStoryPoints,timeProgress,timeEstimate,timeSpent,toDoIssuesCount,inProgressIssuesCount,doneIssuesCount,startDate,endDate,completeDate
IPD Scrum Board,https://hangzhouace.atlassian.net/jira/software/c/projects/IPD/boards/4,Hurrican Sprint 2,https://hangzhouace.atlassian.net/issues/?jql=Sprint%3D140,,future,0,0,0,0.000,1.0,0.0,2,0,0,,,
IPD Scrum Board,https://hangzhouace.atlassian.net/jira/software/c/projects/IPD/boards/4,IPD Sprint 4 (Dallas),https://hangzhouace.atlassian.net/issues/?jql=Sprint%3D135,完成 Sprint 4,active,0.000,317,0,0.570,12.5,7.1,10,1,5,2023/11/13,2023/11/24,
IPD Scrum Board,https://hangzhouace.atlassian.net/jira/software/c/projects/IPD/boards/4,IPD Sprint 20 (Tijuana),https://hangzhouace.atlassian.net/issues/?jql=Sprint%3D17,,future,0,0,0,0,0.0,0.1,0,0,1,2024/1/8,2024/1/19,
IPD Scrum Board,https://hangzhouace.atlassian.net/jira/software/c/projects/IPD/boards/4,Voyager Sprint 1,https://hangzhouace.atlassian.net/issues/?jql=Sprint%3D16,Goal is big big goal,closed,0.455,11,5,0,0.0,0.0,0,1,4,2022/10/17,2022/10/28,2022/12/16
IPD Scrum Board,https://hangzhouace.atlassian.net/jira/software/c/projects/IPD/boards/4,Voyager Sprint 2,https://hangzhouace.atlassian.net/issues/?jql=Sprint%3D13,探索插件开发方式,closed,0.048,336,16,1.997,3.0,6.0,1,0,12,2022/10/31,2022/11/11,2022/12/16
IPD Scrum Board,https://hangzhouace.atlassian.net/jira/software/c/projects/IPD/boards/4,IPD Sprint 3 (Chicago),https://hangzhouace.atlassian.net/issues/?jql=Sprint%3D3,Delivery Cycle任务管理,closed,0.934,572,534,0.162,6.2,1.0,0,11,44,2022/11/14,2024/1/12,2024/2/5
IPD Scrum Board,https://hangzhouace.atlassian.net/jira/software/c/projects/IPD/boards/4,Voyager Sprint 4,https://hangzhouace.atlassian.net/issues/?jql=Sprint%3D2,Discovery Cycle Tasks 管理（Delivery Teams任务除外）,closed,0.206,339,70,2.574,8.5,21.9,0,0,9,2022/11/28,2023/3/30,2023/3/29

[BertrandDrouhard1]

In my DynanicTable, if the content value of a cell is null, then it works as expected and displays nothing (and not a 0).
Maybe in your code the null values from a csv are changed by mistake into a 0.

[YY1]

@BertrandDrouhard1

are

The csv file are data returned from backend and you can see completedStoryPoints is 0. The front end code is:

        {
          key: sprint.completedStoryPoints,
          content:
            <Inline alignInline="center">{sprint.completedStoryPoints || 0}</Inline>,
        }

However, the frontend shows blank.

[YY1]

I changed it to hard code

        {
          key: sprint.completedStoryPoints,
          content: 0,
}

the result is: all blank

[BertrandDrouhard1]

Usually what I do in such situations, is to test with static data, to make sure that the bugs really comes from my side.

I also confirm that the sorting feature of DynamicTable does not work (sorting is done one the last column in my case).

[BertrandDrouhard1]

I think that the key must be unique for a cell. Try to add an id to sprint.completedStoryPoints. Good luck!

[YY1]

If I changed 0 to 1 as hard code, the result is correct：

[BertrandDrouhard1]

A solution is to send a string: '0'. Not very clean but it should work. The same for empty dates: ''.

[YY1]

Thanks for your help @BertrandDrouhard1