chunk 0
page ?
id 9274335fa1460dc2c64c7f8f83dd
2000 chars
{ "data": { "columnsData": [ { "id": "2878b5a1-3e5e-4535-9e95-178fb84fef64", "dataSourceId": "0a813e1d-83ce-4195-a195-5efa001110ed", "columnId": "d9548429-4161-4d39-89e4-f4cc2b28eecd", "mainColumnId": "00000000-0000-0000-0000-000000000000", "columnName": "نوع درخواست", "dataType": "Text", "dataModuleType": "Quality", "chartColumnType": "Descriptor", "columnAggregationType": "None", "showAsPercentageOfTotal": false, "priority": 1, "data": [ "چك", "تنخواه", "اردويي", "علي الحساب" ], "totalValue": null, "isHighlightColumn": false, "conditionalFormattingValue": null, "conditionalFormattingValueColor": null, "domainFormattingColor": null, "colors"
Show metadata
{
"collection": "test_alavi_request_type",
"source": "request_type.json",
"doc_id": "9274335fa1460dc2c64c7f8f83dda53b"
}
Show full text preview
{ "data": { "columnsData": [ { "id": "2878b5a1-3e5e-4535-9e95-178fb84fef64", "dataSourceId": "0a813e1d-83ce-4195-a195-5efa001110ed", "columnId": "d9548429-4161-4d39-89e4-f4cc2b28eecd", "mainColumnId": "00000000-0000-0000-0000-000000000000", "columnName": "نوع درخواست", "dataType": "Text", "dataModuleType": "Quality", "chartColumnType": "Descriptor", "columnAggregationType": "None", "showAsPercentageOfTotal": false, "priority": 1, "data": [ "چك", "تنخواه", "اردويي", "علي الحساب" ], "totalValue": null, "isHighlightColumn": false, "conditionalFormattingValue": null, "conditionalFormattingValueColor": null, "domainFormattingColor": null, "colors": { "__BLANK_VALUE__": "#4A8DDC", "چك": "#e0e0e0", "تنخواه": "#ffecb3", "اردويي": "#ef9a9a", "علي الحساب": "#b2dfdb", "صورت وضعيت": "#95C8F0" }, "additionalData": { "maxValue": -1.7976931348623157E+308, "minValue": 1.7976931348623157E+308 }, "needAdditionalData": false, "isConditionalFormattingColumn": false, "hasError": false, "errorMessage": "" }, { "id": "4adbb488-9afa-4815-aa12-170527976258", "dataSourceId": "0a813e1d-83ce-4195-a195-5efa001110ed", "columnId": "d4edc700-7b4a-4899-be54-016c8ec4eebd", "mainColumnId": "00000000-0000-0000-0000-000000000000", "columnName": "درخواست", "dataType": "Text", "dataModuleType": "Quality", "chartColumnType": "Value", "columnAggregationType": "Count", "showAsPercentageOfTotal": false, "priority": 1, "data": [ 1613, 111, 57, 31 ], "totalValue": null, "isHighlightColumn": false, "conditionalFormattingValue": null, "conditionalFormattingValueColor": null, "domainFormattingColor": null, "colors": { "Value": "#4A8DDC" }, "additionalData": { "maxValue": -1.7976931348623157E+308, "minValue": 1.7976931348623157E+308 }, "needAdditionalData": false, "isConditionalFormattingColumn": false, "hasError": false, "errorMessage": "" }, { "id": "873cf832-efe2-4939-b297-9bc3579f7292", "dataSourceId": "0a813e1d-83ce-4195-a195-5efa001110ed", "columnId": "da152ca4-ba38-45f9-a56a-e08089a95008", "mainColumnId": "
chunk 1
page ?
id 9274335fa1460dc2c64c7f8f83dd
2000 chars
00000000-0000-0000-0000-000000000000", "columnName": "مبلغ ناخالص صورت وضعیت میلیارد تومان", "dataType": "DecimalNumber", "dataModuleType": "Quantity", "chartColumnType": "Tooltip", "columnAggregationType": "Sum", "showAsPercentageOfTotal": false, "priority": 1, "data": [ 1003.948634699, 14.632455646299993, 12.736488410399994, 1512.3465863842998 ], "totalValue": null, "isHighlightColumn": false, "conditionalFormattingValue": null, "conditionalFormattingValueColor": null, "domainFormattingColor": null, "colors": {}, "additionalData": { "maxValue": -1.7976931348623157E+308, "minValue": 1.7976931348623157E+308 }, "needAdditionalData": false, "is
Show metadata
{
"collection": "test_alavi_request_type",
"source": "request_type.json",
"doc_id": "9274335fa1460dc2c64c7f8f83dda53b"
}
Show full text preview
00000000-0000-0000-0000-000000000000", "columnName": "مبلغ ناخالص صورت وضعیت میلیارد تومان", "dataType": "DecimalNumber", "dataModuleType": "Quantity", "chartColumnType": "Tooltip", "columnAggregationType": "Sum", "showAsPercentageOfTotal": false, "priority": 1, "data": [ 1003.948634699, 14.632455646299993, 12.736488410399994, 1512.3465863842998 ], "totalValue": null, "isHighlightColumn": false, "conditionalFormattingValue": null, "conditionalFormattingValueColor": null, "domainFormattingColor": null, "colors": {}, "additionalData": { "maxValue": -1.7976931348623157E+308, "minValue": 1.7976931348623157E+308 }, "needAdditionalData": false, "isConditionalFormattingColumn": false, "hasError": false, "errorMessage": "" } ], "columnsSortPriority": [ { "columnId": "d4edc700-7b4a-4899-be54-016c8ec4eebd", "chartColumnType": "Value" }, { "columnId": "d9548429-4161-4d39-89e4-f4cc2b28eecd", "chartColumnType": "Descriptor" } ], "totalRowCount": 0.0, "result": null, "query": "DEFINE \nVAR _START = 0\nVAR __DS0FilterTable0 = TREATAS ({ \"1404\" }, 'TB_25ceb9610a8e4631b8feb29d00eb1b03_0e5e3f1507f549608dfaf026f62f8ba9'[Year_Name]) \nVAR __DS0FilterTable1 = FILTER ( KEEPFILTERS ( VALUES ( 'TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed'[A_req_type_title] )), Not('TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed'[A_req_type_title] IN { BLANK(),\"صورت وضعيت\" }) )\nVAR __DS0FilterTable2 = TREATAS ({ true }, 'TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed'[F20]) \nVAR __DS0Final = SUMMARIZECOLUMNS ( 'TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed'[A_req_type_title],__DS0FilterTable0,__DS0FilterTable1,__DS0FilterTable2,\"TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed_Count_Id\n\", CALCULATE(COUNTA('TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed'[Id])),\"TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed_Sum_da152ca4-ba38-45f9-a56a-e08089a950
chunk 2
page ?
id 9274335fa1460dc2c64c7f8f83dd
487 chars
08\n\", CALCULATE(SUM('TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed'[da152ca4-ba38-45f9-a56a-e08089a95008])))\nEVALUATE __DS0Final \n\nORDER BY \n[TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed_Count_Id\n] DESC,'TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed'[A_req_type_title] \n", "failed": false, "msg": null }, "isSuccess": true, "statusCode": "Success", "message": "عملیات با موفقیت انجام شد", "showPopUp": false }
Show metadata
{
"doc_id": "9274335fa1460dc2c64c7f8f83dda53b",
"source": "request_type.json",
"collection": "test_alavi_request_type"
}
Show full text preview
08\n\", CALCULATE(SUM('TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed'[da152ca4-ba38-45f9-a56a-e08089a95008])))\nEVALUATE __DS0Final \n\nORDER BY \n[TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed_Count_Id\n] DESC,'TB_25ceb9610a8e4631b8feb29d00eb1b03_0a813e1d83ce4195a1955efa001110ed'[A_req_type_title] \n", "failed": false, "msg": null }, "isSuccess": true, "statusCode": "Success", "message": "عملیات با موفقیت انجام شد", "showPopUp": false }