Question

Dashboard query

  • 9 August 2021
  • 5 replies
  • 110 views
I
Rank
Badge +1
  • Ian J
  • Do Gooder (Customer)
  • 3 replies

Hi All,

 

Hopefully this is an easy fix for someone :

 

I’ve created a metric on IFS using Element Designer which I want to show me the total value of stock in a specific location.  The issue I have is that it’s counting everything as single items (inventory value) instead of showing the full cost if there are multiple items (Total inventory value).  When creating the metric I couldn’t see any options to count from the Total Inventory Value column.

 

Does anyone have any ideas how to achieve this please ?

 

Thankyou

 

This topic has been closed for comments

5 replies

B
Rank
Userlevel 5
Badge +13

Hi @Ian J,
 

Is it possible to share the query that you have already written?

Thanks!
Bhagya

I
Rank
Badge +1

Hi Bhagya,

 

It’s from a Saved Search:

Lobby Data Source Designer:

 

There doesn’t appear to be a Total Inventory Value column ..

 

Element Designer

 

T
Rank
Userlevel 7
Badge +19

Add a calculation in your field. Change “UNIT_COST” to “UNIT_COST * QTY_ONHAND” in the data source and you will get the inventory value.

You will have to redo the element after changing the data source. By that I mean that you have to select the Column again in the element.

AanHGTS
Rank
Userlevel 5
Badge +12

Is this what you want?
 

If Yes, build the query using Advance Query and Group for Location. 

 

Cheers, Aan de Silva - https://www.linkedin.com/in/aandesilva/
I
Rank
Badge +1

Add a calculation in your field. Change “UNIT_COST” to “UNIT_COST * QTY_ONHAND” in the data source and you will get the inventory value.

You will have to redo the element after changing the data source. By that I mean that you have to select the Column again in the element.

Thankyou Tomas - that now works

Terms & ConditionsCookie settings