How to make custom report in Tactic?

[EricTsuei]

Hi
I have look for the docs, and can't find any samples to make custom report.
can you show me some samples?
like chart difference pipeline status, or total count or sum some custom columns by certain filters?

[listy]

You can see how it is made in source codes, also check out Report samples.

Here you can find widget, and use it as boilerplate:
tactic.ui.chart.CalendarChartWdg

[EricTsuei]

I am sorry but I can't find any info about CalendarChartWdg, in all pdfs.
is there any samples of this wdg?

and I am thinking , this "chart.SObjectChartWdg" wdg should more useful for my case.

[remkonoteboom]

It not very well documented. We have a bunch of old examples in xml format in the file:

$TACTIC_INSTALL_DIR/src/tactic/ui/config/reports-conf.xml

They are in an old format using LinkWdg, but you can translate it pretty easily:

For example:

<element name='weekly_tasks_completed' title='Weekly Tasks Completed' image="GRAPH_BAR_04" description='Task count completed each week'>
<display class="LinkWdg">
<class_name>tactic.ui.chart.CalendarChartWdg</class_name>
<title>Task Completed Chart</title>
<y_title># Tasks</y_title>
<search_type>sthpw/task</search_type>
<start_date>{$THIS_YEAR}</start_date>
<elements>{@COUNT()}</elements>
<column>actual_end_date</column>
<chart_type>bar</chart_type>
</display>
</element>

The current format does not use "LinkWdg" and is translated as follows:

<element name='weekly_tasks_completed' title='Weekly Tasks Completed' image="GRAPH_BAR_04" description='Task count completed each week'>
<display class="tactic.ui.chart.CalendarChartWdg">
<title>Task Completed Chart</title>
<y_title># Tasks</y_title>
<search_type>sthpw/task</search_type>
<start_date>{$THIS_YEAR}</start_date>
<elements>{@COUNT()}</elements>
<column>actual_end_date</column>
<chart_type>bar</chart_type>
</display>
</element>

... which can be used directly in a Custom Layout

or you can just use straight Python code:

widget = CalendarChartWdg(
title="Task Completed Chart",
y_title="# Tasks",
search_type="sthpw/task",
start_date="{$THIS_YEAR}",
elements="{@COUNT()}",
column="actual_end_date".
chart_type="bar"
)

[EricTsuei]

I just want to add some graph like attachment, 
this is the graph I create in shotgun.
I can count, sum all values that I need.
display values in bars.
please see for the attachment, graph and graph definition.
Can I make some graph in tactic? with python or html  in custom layout?

[remkonoteboom]

This will do something similar.

<element>
<display class="tactic.ui.chart.SObjectChartWdg">
<title>Number of check-ins per user</title>
<chart_type>bar</chart_type>
<expression>@SOBJECT(sthpw/login)</expression>
<x_axis>login</x_axis>
<elements>{@COUNT(sthpw/task['status','Pending'])}|{@COUNT(sthpw/task['status','In Progress'])}</elements>
<rotate_x_axis>true</rotate_x_axis>
</display>
</element>

It's a bit cryptic, but if you know the expression language, you could graph almost any information. We haven't really build a fancy front end for this. For something better looking, you could add this to a custom layout and window dress it.

[EricTsuei]

thank you
I have create some graph finally.
but this can't work:
<elements>{@SUM(production_management/main_page['budget'])}</elements>

and need to change to this:
<elements>{@sum(production_management/main_page.budget)}</elements>

don know why.

but can we do some more? like display sum or count value at the top of each bar?

[Celton McGrath]

thank you
I have create some graph finally.
but this can't work:
<elements>{@SUM(production_management/main_page['budget'])}</elements>

and need to change to this:
<elements>{@sum(production_management/main_page.budget)}</elements>

don know why.

but can we do some more? like display sum or count value at the top of each bar?

In the TEL (TACTIC Expression Language), square brackets are used for filters and SQL operators

ie. "[<column>, <value>]"
ie. @SOBJECT(prod/shot.sthpw/task['@ORDER_BY','process']['@LIMIT','50'])

and "." are used for columns and schema connections.

In this case, to sum the budget column, "." is correct. 



Best,

Celton

[remkonoteboom]

I would like to note that the TACTIC charts were developed a long time ago when most of the charting libraries left a lot to be desired. This is no longer the case. I would recommend using something like chart.js (https://www.chartjs.org/) which would be super easy to just use. We could consider putting this into TACTIC itself.

[EricTsuei]

is it possible to put it in 4.5v1? by my self?