Creating a Visual by refrancing my Cross Tab Values

1 Answer 13 Views
Actions CrossTab Graph
Mahhin
Top achievements
Rank 1
Mahhin asked on 31 Oct 2024, 12:49 PM | edited on 31 Oct 2024, 12:50 PM
Hey Everyone, 
I am very new to telerik and have no .Net Knowlege at all . 
In my standalone App

I had these KPI that I aggregated LIKE EBTIDA AND COGS that I am getting my Grouping my quarters at row level and at column level by my Subsection columns.

Now, 
I just simply want to reference this Total aggregated value from my table to directly in my Linear Gauge 
please guide in detail 
 








1 Answer, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 04 Nov 2024, 03:13 PM

Hi Mahhin,

Report items are not aware of and cannot access the values of other report items directly. For the Linear Gauge to be able to use the total aggregated value of the table, the solution would be for the gauge to use the same data source component as its DataSource.

When the same data source is used, to get the totals, you may use an aggregate function such as Sum(expression) on the Value property of the Gauge item, for example:

Since the data source would be the same, the total aggregated in the Gauge and the Table should be the same as well. However, if the table has filters, the same filters would need to be added to the Gauge item as well. 

I hope that the provided information will help. Please let me know if you need further assistance.

Regards,
Dimitar
Progress Telerik

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
Tags
Actions CrossTab Graph
Asked by
Mahhin
Top achievements
Rank 1
Answers by
Dimitar
Telerik team
Share this question
or