marisaborges

The total and subtotal assume the aggregation fuction you use on your variable. If you use SUM on variable hours, total and subtotal will use SUM too. Maybe try to add the same column and use average?

in Pivot Table Average Summaries instead of Totals Comment by marisaborges July 2020

according to the attachment no, I think the goal is to filter by the last date

in how to set up filter for the last day of data set in the new text card for summary Comment by marisaborges April 2020

Hi! The beastmode with MAX(date) will change its value every day and will require you to change the value to be filtered every day. You should try in the Dataflow to create a new column to use as a filter. For example, CASE WHEN date = MAX(last_date) THEN 1 ELSE 0 END AS is_last_date Then filter when is_last_date = 1

in how to set up filter for the last day of data set in the new text card for summary Comment by marisaborges April 2020

marisaborges Member

Comments