Date clarification

Question & Answer
,
1

Hi Team

I have a table called master
in that fields are
inward date
tag_id
generated value
dispatched date
processed value

but i need to calculate total generated value based on inward date and total processed value based on dispatched date

these two values i need o mention in line graph for comparison like shown in the image
image

but i need to use date filter to filter the data based on the period
if i ill select last 1 year the values generated value and processed value based on their date field

what should i need to do like these scenarios

please provide me the solution
its little bit urgent

2

Hello Vinodh,

you may need to combine the date into single date field at the backend level, may like union to capture all the data points for inward date as well as dispatched date… there may be duplicates but that you could filter out at dashboard levels.

hope this gives some idea to proceed.

Cheers,
Deep

1 Like