Set chart to pick current date (today) automatically

[Anonymous]

Hi!

My data has 4 columns;

Date

Aging Group

Warehouse

B/O Qty.

All 4 columns are updated daily. I have a bar chart which depicts Aging Group.

Instead of selecting date which impacts other data charts. On reloading the document, I want this chart to pick the current date (Today) data automatically to get the below view.

[juraj_misina]

Hi,

you can use set analysis for that purpose. Something like:

Sum({<Date={$(=Today())}>} [B/O Qty])

Optionally, you can use on open trigger to make selection for today after opening the app, but I generally do not recommend using triggers.

Hope this helps

Juraj

[Anonymous]

Hi Juraj,

The expression seems to be correct but is retaining a blank chart.

Date (Today) is the column header.

Sum({$<[Date (Today)]={$(=Today(),'MM/DD/YY')}>} [B/O Qty])

Regards,

Dev

[juraj_misina]

Try

Sum({$<[Date (Today)]={$(=Date(Today(),'MM/DD/YY'))}>} [B/O Qty])

Juraj

[Anonymous]

Hello Juraj,

I went with the option of creating a variable which gave me the desired result;

=sum({<Date_Today={'$(vMax_Date_Today)'}>}[B/O Qty])

Thanks for all the help!

Regards,

Dev