LearningNinja Member

@JoshMillheim - Thanks for providing detailed information around cache. Is there any mechanism available on DOMO to clear the cache created from Federated connection? Something like a force flush?

The data table shows aggregated value with only 4 rows. 2021, 2022, 2023, 2024. The same 4 rows are visible in HTML Table as well.

@david_cunningham - Yes! The same beast modes and same combinations worked earlier. Infact, I have a chart which has a same configuration which shows in the desired way. Howver, if I just remove and add same beast, the x-axis is shown with duplicate values.

@ColemenWilson - Unable to find that here. The kebab icon…

@jessdoe - Yes, that removes the comma but on the Year, I need to perform a Year - 1. What I have performed is: Set up a variable > Text > 2024,2023, 2022. ⇒ Variable name: variableYear In Beast mode, multiplied variableYear*1 which converted the value to integer. Now, i am looking to perform a sum based on year.…

Thanks for the response, @david_cunningham. Is there any possibility without using ETL. Due to limitations, I am looking for solutions without ETL and limited to beast mode. Also, I am looking for a more dynamic solution where the user may select any Year from the dropdown which would become my base/current year and the…

But, I am unable to use it in formulas. I think, I am unable to put the issue clearly here. The main purpose of using YEAR as variable is to use in the formula to perform -1 of it.

@ArborRose Default, Percent and Currency. Checked through all three options but no luck to handle it.

@ArborRose - Can we quickly connect once? If it is possible, please.

@ColemenWilson I have gone through the post, but it talks about converting a numeric column to a string. However, when setting a variable, how do we do that? I do not see any option do perform anything. This is the only window I have to edit its configuration:

@ColemenWilson - I have created a variable > dropdown for Year with a list of values : 2024, 2023,2022,2021. Displayed this variable on a card on the dashboard by Creating a card > Insert a variable. Now, the dropdown on the dashboard shows the values with comma. Also, why did I use this variable in first instance is, to…

@Luke_Mielke - I have tried doing a DATE_SUB, still no luck. For some reason it is not picking the calc. If I hard-code it with prev month number , it prints the value. something like, Let's say my current month is 2. If i pass 1, it gives value but not able to make it dynamic. WHEN Year = YrSelector AND 'Month' = 1) THEN…

@GrantSmith - Thanks for the detailed guide. I believe this solution would require the ETL to run every day to ensure Last week, Last 3 weeks etc etc to be adjusted with my Data to real-time. Having around 10+ million rows of data, I think, this is would make an impact on the performance. Do you think I can write some…